mobile databases, mobile forms, and mobile synchronization … where you need to work
Providing Pocket Access, Mobile Database, Windows CE Database, and Windows CE Development Solutions

Date and Time Functions

Report CE software adds reporting, printing, and graphing capabilities to mobile database applications Visual CE software allows you to build custom mobile database applications for any Windows Mobile, Pocket PC, Smartphone, or Windows CE device

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.

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.