Let the time zone given by user
+0530
Therefore its 330 minutes / 13200 seconds
select datetime( StartTime,'unixepoch','+13200.0 seconds') from mytable
--- gives you the local time
Select datetime( StartTime,'unixepoch')gives u universal time
Where StartTime is an integer(unixtimestamp
Thanks Karthick. My code too works fine... (I made a small typo mistake in
query, which executed silently)
But I guess your method is the right one.
Regards,
Lloyd
On Wed, 2006-12-20 at 16:54 +0530, Karthick V - TLS , Chennai wrote:
Let the time zone given by user
+0530
Therefore its
