Data Formats


In order to successfully transmit data values to the database servers the data must be correctly formatted. Below are are some guides for formatting complex data values. Depending on your country/region locale, other formats may also work.

Date Formats

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

YYYY-MM-DD for example: '2003-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, 2003 9:35:17 PM'.

YYYY-MM-DD HH:mm:ss for example '2003-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