Hello Uriel, Tuesday, February 15, 2005, 2:19:07 AM, you wrote:
Unc> SQLiters: Unc> What would be the best method for creating a Table with one column in the Unc> format 03-Mar-2005 16:05:30? Unc> i.e. dd-mmm-yy hh:mm:ss You should store the datetime in SQL-Timestamp format, in case you need a human-readable date. the format is: yyyy-mm-dd hh:mm:ss like 2005-02-15 11:55:54 it will be sorted correctly with ORDER BY Unc> I will need to retrieve by date/time in proper order. i.e. "select * from Unc> 'table' ORDER BY datetime-field". -- Best regards, Dmitry mailto:[EMAIL PROTECTED]