Apollo SQL > Date and Time Functions

General

Now	Returns the current system date in floating point format.

Date

DAY	Return the day for the given date
MONTH	Return the month for the given date
YEAR	Return the year for the given date

Time

HOUR	Return the hour for the given time
MIN	Return the minutes for the given time
MSEC	Return the milliseconds for the given time
SEC	Return the seconds for the given time