Previous Topic: COUNT Function--Count the Elements in a Set

Next Topic: DATE Function--Convert Year, Month, Day, Hours, Minutes, and Seconds (form 2)

DATE Function--Set to Midnight (form 1)

The DATE function (form 1) accepts a numeric representation of date and time and sets the time to midnight on the specified date.

Syntax

The DATE function (form 1) has the following format:

DATE(date_time)

Parameters

The DATE function (form1) 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 date_time is not a valid representation of date and time, the function returns -1.

Return Value

The DATE function (form1) returns a number.

More information:

DATE Function--Convert Year, Month, Day, Hours, Minutes, and Seconds (form 2)

DATEFROMSTRING Function--Convert String to Number

DATETOSTRING Function--Convert Number to String


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