Previous Topic: DAY Function--Return Day of Month

Next Topic: DOY Function--Return Day of Year

DOW Function--Return Day of Week

The DOW function accepts a numeric representation of date and time and returns a number corresponding to the day of the week.

Syntax

The DOW function has the following format:

DOW(date_time)

Parameters

The DOW function accepts the following parameter:

date_time (number)

Specifies the date and time as the number of seconds that have passed since January 1, 1970. If the date is invalid, the function returns -1.

Return Value

The DOW function returns a number from 0 (Sunday) to 6 (Saturday).

Example

Return_value=DOW(1024804800)
Return_value=0

More information:

DAY Function--Return Day of Month

DOY Function--Return Day of Year


Copyright © 2010 CA. All rights reserved. Email CA about this topic