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.