Previous Topic: DATETOSTRING Function--Convert Number to String

Next Topic: DOW Function--Return Day of Week

DAY Function--Return Day of Month

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

Syntax

The DAY function has the following format:

DAY(date_time)

Parameters

The DAY 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 DAY function returns a number from 1 to 31.

Example

Return_value=DAY(1024804800)
Return_value=23

More information:

DOW Function--Return Day of Week

DOY Function--Return Day of Year


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