Joanne Pham wrote:
Hi All, Should I create the column in DATETIME or the INTEGER to store the time. DATETIME has the value of GMT time. So I store this value as INTEGER then I need to convert datetime format but it will be use less space if I use the INTEGER. Please give me an advice.
See http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions where it says "The julian day number is the preferred internal representation of dates."
A Julian day number is a floating point number that can be easily compared and converted to data and time strings for display.
HTH Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
