Joanne Pham <joannekpham-/[EMAIL PROTECTED]> wrote:
Thank Richard,
What is the 'localtime' in this case. If my time zone is Pacific Time
zone.
You actually put the string literal 'localtime'. SQLite uses whatever
time zone your operating system is configured to use.
If you want to use specific time zone, just figure out what the
difference from the GMT is and do something like
datetime(<integer>, 'unixepoch', '-8 hours');
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
