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: