Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I have a table which has one of column is defined as INTEGER and stored the > GMT time. > I would like to convert this GMT time from INTEGER format to DATETIME format. > Is there any function to convert from GMT in INTEGER to DATETIME format.
datetime(<integer>, 'unixepoch', 'localtime'); -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
