On 8 Mar 2011, at 13:47, Enrico Thierbach wrote:

> I would like to state in which place a time is meant to be meaningful, and 
> have sqlite come up 
> with the proper timezone and DST correction depending on place and time. 
> Sorry for not making that clear in the beginning.
> 
> Is there a way to do that?

Generally, this is impossible. For instance, here in Britain every time from 1 
AM through 2 AM will occur twice on 30 October 2011. Any function designed to 
give a unique answer to the question of when in UTC the local time for the UK 
given as "1.30 AM 30 October 2011" must necessarily be wrong half the time.

> How do you guys solve this?

I avoid successfully avoided having to solve it thus far.

Best Regards,

Phil Willoughby
-- 
Managing Director, StrawberryCat Limited

StrawberryCat Limited is registered in England and Wales with Company No. 
7234809.

The registered office address of StrawberryCat Limited is:

107 Morgan Le Fay Drive
Eastleigh
SO53 4JH

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to