Previous Topic: HEX Function--Convert to Hexadecimal

Next Topic: HOUR24 Function--Convert to Hour

HOUR Function--Convert to Hour

The HOUR function converts the specified date and time to an hour from 1 to 12.

Syntax

The HOUR function has the following format:

HOUR(date_time)

Parameters

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

Return Value

The HOUR function returns a number from 1 to 12.

More information:

HOUR24 Function--Convert to Hour


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