Data Formats


Below are are some guidelines for formatting time/date data values as well as function names. Depending on your country/region locale, other formats may be used instead.

Date Formats

MMM DD, YYYY for example: 'Mar 10, 2009'.

YYYY-MM-DD for example: '2009-03-10'.

Time Formats

hh:mm:ss aa for example '9:35:17 PM'.

HH:mm:ss (24-hr Time) for example '21:35:17'.

Date Time Formats

These can be combinations of the date and time formats mentioned above. Here are two such combinations.

MMM DD, YYYY hh:mm:ss aa for example 'Mar 10, 2009 9:35:17 PM'.

YYYY-MM-DD HH:mm:ss for example '2009-03-10 21:35:17'.

Functions

Functions can be passed instead of values. Do not enclose the function name in quotes.

For example you can use the function: now()


See also:

View Database Data
Modify Database Data