Re: [HACKERS] Date/time on glibc2 linux
От | Oleg Broytmann |
---|---|
Тема | Re: [HACKERS] Date/time on glibc2 linux |
Дата | |
Msg-id | Pine.SOL2.3.96.SK.981210115544.13414C-100000@sun.med.ru обсуждение исходный текст |
Ответ на | Re: [HACKERS] Date/time on glibc2 linux ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>) |
Список | 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 justGOSUB without RETURN.
В списке pgsql-hackers по дате отправления: