Edit-DB Edit-DB
(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016

3.6. Dates

This section considers Date, Date-Time and Timestamp data types which are all referred to as date within this section.

Date data values may be output in a number of formats depending on

Edit-DB does not attempt to influence the format of the displayed date data in order to keep the output similar to that produced by individual database-specific utilities such as MS SQL Server's Query Analyser or Oracle's SQLplus.

When inputting or editing existing data, it is intended that the user should be able to use the same format as that employed when displaying data. This enables the user to simply type over existing column values. If there are any cases where this is found not to work, please contact us.

If you are experiencing problems with date entry then
dd/mon/yy e.g. 12/mar/06 will work with most databases
ccyy-mm-dd e.g. 2006-03-12 will work with MySQL