subject:"\[sqlite\] Time zone conversion"

RE: [sqlite] Time zone conversion

2006-12-20 Thread Lloyd

age- > From: Lloyd [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 20, 2006 10:30 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Time zone conversion > > Hi, > I would like to implement a time zone independent function. So I get the > time zone information f

RE: [sqlite] Time zone conversion

2006-12-20 Thread Karthick V - TLS , Chennai

nesday, December 20, 2006 10:30 AM To: sqlite-users@sqlite.org Subject: [sqlite] Time zone conversion Hi, I would like to implement a time zone independent function. So I get the time zone information from user, and plans to convert the datetime to the time zone specified. To make it clear I gi

[sqlite] Time zone conversion

2006-12-19 Thread Lloyd

Hi, I would like to implement a time zone independent function. So I get the time zone information from user, and plans to convert the datetime to the time zone specified. To make it clear I give an example here StartTime is stored as an integer in the database select datetime(StartTime,'unixep