[yunqa.de] Re: Question about UTC and local time

Edwin Yip wrote:

>In my PC which the time zone is UTC + 8, by executing the following SQL at 
>this moment:
>
>select datetime('now') as f1, datetime('now', 'localtime') as f2, 
>datetime('now', 'utc') as f3
>
>I got the following values:
>f1 = 2008-07-05 11:21:08
>f2 = 2008-07-05 19:21:08
>f3 = 2008-07-05 03:21:08
>
>I don't understand why f1 is not equal f3?

The "utc" modifier is the exact opposite of "localtime". While "localtime" 
modifier adjusts a time string so that it displays the correct local time,  
"utc" undoes this, so that a local time string displays in "utc".

>If I have a value in Delphi which is of type TDateTime and equals to Delphi 
>function Now(). How to store this value to the DB correcty?

Just the other way round as you do when retrieving a TDateTime value:

  Stmt.Column_Double(idx) := DateTimeToJulianDate(Now);

Ralf 

_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
http://www.freelists.org/list/yunqa



Other related posts: