DroidDB^® Date and Time Functions

DAYNAME(datetime)
Returns the name of the day for datetime. For example, @dayname('2002-02-14') returns Thursday.

DAYOFMONTH(datetime)
Returns the day of the month for datetime as a integer in the range 1-31.

DAYOFWEEK(datetime)
Returns the day of the week for datetime as an integer in the range 1-7, where 1 represents Sunday.

DAYOFYEAR(datetime)
Returns the day of the year in datetime as integer in the range 1-366.

DAYS
Returns number of minutes in a day (24 * 60).

HOUR(datetime)
Returns the hour in datetime as an integer in the range 0-23.

MINUTE(datetime)
Returns the minute in datetime as an integer in the range 0-59.

MONTH(datetime)
Returns the month in datetime as an integer in the range 1-12.

MONTHNAME(datetime)
Returns the name of the month for datetime. For example, @monthname('2002-02-14') returns February.

NOW
Returns current date and time.

QUARTER(datetime)
Returns the quarter for datetime as an integer value in the range 1-4, where 1 represents January 1 through March 31.

SECOND(datetime)
Returns the second in datetime as an integer in the range 0-59.

TODAY
Returns current date, without time.

YEAR(datetime)
Returns the year in datetime.