From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
---|---|
To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Date/time on glibc2 linux |
Date: | 1998-12-10 08:57:21 |
Message-ID: | Pine.SOL2.3.96.SK.981210115544.13414C-100000@sun.med.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi!
I run postgres with DATEDEBUG and got:
GetCurrentAbsoluteTime- timezone is MSK -> -10800 seconds from UTC
date_in- input string is 1991-10-01
ParseDateTime- input string is 1991-10-01
ParseDateTime- set field[0] to 1991-10-01 type 2
DecodeDateTime- field[0] is 1991-10-01 (type 2)
DecodeNumber- 1991 is 1991 fmask=00000000 tmask=00000000
DecodeNumber- match 1991 (1991) as year
DecodeNumber- 10 is 10 fmask=00000004 tmask=00000000
DecodeNumber- match 10 (10) as month
DecodeNumber- 01 is 1 fmask=00000006 tmask=00000000
DecodeNumber- (2) match 1 (01) as day
DecodeDateTime- field[0] 1991 (00000000/0000000e) value is 1
DecodeDateTime- mask 0000000e (0000000e) set y1991 m10 d01 00:00:00
ParseDateTime- input string is 11:00
ParseDateTime- set field[0] to 11:00 type 3
DecodeTimeOnly- field[0] is 11:00 (type 3)
DecodeTimeOnly- field[0] 11:00 value is -1073763148
DecodeTimeOnly- mask 00001c0e (00001c00) 11:00:00 (0.000000)
date_datetime- date is 1991.10.01
date_datetime- time is 00:00:00 0.0000000
tm2datetime- date is -260409600.000000 (-3014.000000 0.000000 0)
tm2datetime- time is 0.000000 00:00:00 0.000000
datetime2tm- date is -260362800.000000 (2448531.000000 46800.000000)
datetime2tm- date is 1991.10.01
datetime2tm- time is 13:00:00
datetime2tm- time is 13:00:00 0.0000000
datetime2tm- (localtime) 91.09.01 15:00:00 EET dst=0
datetime2tm- date is 1991.10.01
datetime2tm- time is 15:00:00 0.0000000
EncodeDateTime- timezone is EET (EET); offset is -7200 (-10800); daylight is 0 (0
EncodeDateTime- day is 2448531
EncodeDateTime- date result is Tue 01 Oct 15:00:00 1991 EET
The last 3 lines shows an error. Continue searching...
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1998-12-10 09:05:00 | Re: [GENERAL] TODO list elements |
Previous Message | Oleg Broytmann | 1998-12-10 08:35:49 | Re: [HACKERS] Date/time on glibc2 linux |