DelpDate : www.merlyn.demon.co.uk >= 2002-04-04 Delphi 3 : Shows behaviour with negative input Decoded Corrupt Rectify DateTime DoW : DoW Year Mo Dy Hr Mi Sc : DoW Year Mo Dy Hr Mi Sc -3.000 4 4 1899-12-27 00:00:00 4 1899-12-27 00:00:00 -3.000 -2.750 4 5 1899-12-28 18:00:00 4 1899-12-27 06:00:00 -2.750 -2.500 4 5 1899-12-28 12:00:00 4 1899-12-27 12:00:00 -2.500 -2.250 4 5 1899-12-28 06:00:00 4 1899-12-27 18:00:00 -2.250 -2.000 5 5 1899-12-28 00:00:00 5 1899-12-28 00:00:00 -2.000 -1.750 5 6 1899-12-29 18:00:00 5 1899-12-28 06:00:00 -1.750 -1.500 5 6 1899-12-29 12:00:00 5 1899-12-28 12:00:00 -1.500 -1.250 5 6 1899-12-29 06:00:00 5 1899-12-28 18:00:00 -1.250 -1.000 6 6 1899-12-29 00:00:00 6 1899-12-29 00:00:00 -1.000 -0.750 6 7 1899-12-30 18:00:00 6 1899-12-29 06:00:00 -0.750 -0.500 6 7 1899-12-30 12:00:00 6 1899-12-29 12:00:00 -0.500 -0.250 6 7 1899-12-30 06:00:00 6 1899-12-29 18:00:00 -0.250 0.000 7 7 1899-12-30 00:00:00 7 1899-12-30 00:00:00 0.000 - 0.250 7 7 1899-12-30 06:00:00 7 1899-12-30 06:00:00 0.250 0.500 7 7 1899-12-30 12:00:00 7 1899-12-30 12:00:00 0.500 0.750 7 7 1899-12-30 18:00:00 7 1899-12-30 18:00:00 0.750 1.000 1 1 1899-12-31 00:00:00 1 1899-12-31 00:00:00 1.000 1.250 1 1 1899-12-31 06:00:00 1 1899-12-31 06:00:00 1.250 1.500 1 1 1899-12-31 12:00:00 1 1899-12-31 12:00:00 1.500 1.750 1 1 1899-12-31 18:00:00 1 1899-12-31 18:00:00 1.750 2.000 2 2 1900-01-01 00:00:00 2 1900-01-01 00:00:00 2.000 2.250 2 2 1900-01-01 06:00:00 2 1900-01-01 06:00:00 2.250 2.500 2 2 1900-01-01 12:00:00 2 1900-01-01 12:00:00 2.500 2.750 2 2 1900-01-01 18:00:00 2 1900-01-01 18:00:00 2.750 3.000 3 3 1900-01-02 00:00:00 3 1900-01-02 00:00:00 3.000 60.000 4 4 1900-02-28 00:00:00 4 1900-02-28 00:00:00 60.000 61.000 5 5 1900-03-01 00:00:00 5 1900-03-01 00:00:00 61.000 36584.000 2 2 2000-02-28 00:00:00 2 2000-02-28 00:00:00 36584.000 36585.000 3 3 2000-02-29 00:00:00 3 2000-02-29 00:00:00 36585.000 36586.000 4 4 2000-03-01 00:00:00 4 2000-03-01 00:00:00 36586.000 73109.000 1 1 2100-02-28 00:00:00 1 2100-02-28 00:00:00 73109.000 73110.000 2 2 2100-03-01 00:00:00 2 2100-03-01 00:00:00 73110.000 Paradox msec TDateTime Decoded to Gregorian 59926262400000 -3.000000 4 1899-12-27 00:00:00 59926291200000 -3.333333 4 1899-12-27 08:00:00 59926320000000 -3.666667 4 1899-12-27 16:00:00 59926348800000 -2.000000 5 1899-12-28 00:00:00 59926377600000 -2.333333 5 1899-12-28 08:00:00 59926406400000 -2.666667 5 1899-12-28 16:00:00 59926435200000 -1.000000 6 1899-12-29 00:00:00 59926464000000 -1.333333 6 1899-12-29 08:00:00 59926492800000 -1.666667 6 1899-12-29 16:00:00 59926521600000 0.000000 7 1899-12-30 00:00:00 59926550400000 0.333333 7 1899-12-30 08:00:00 59926579200000 0.666667 7 1899-12-30 16:00:00 59926608000000 1.000000 1 1899-12-31 00:00:00 59926636800000 1.333333 1 1899-12-31 08:00:00 59926665600000 1.666667 1 1899-12-31 16:00:00 59926694400000 2.000000 2 1900-01-01 00:00:00 59926723200000 2.333333 2 1900-01-01 08:00:00 59926752000000 2.666667 2 1900-01-01 16:00:00 59926780800000 3.000000 3 1900-01-02 00:00:00 59926809600000 3.333333 3 1900-01-02 08:00:00 Paradox Day 0.000 => 1 0000-00-00 00:00:00 Paradox Day 0.001 => 1 0000-00-00 00:01:26 Paradox Day 1.000 => 2 0001-01-01 00:00:00 Paradox Day 365.000 => 2 0001-12-31 00:00:00 Paradox Day 730.000 => 3 0002-12-31 00:00:00 Paradox Day 1095.000 => 4 0003-12-31 00:00:00 Paradox Day 1461.000 => 6 0004-12-31 00:00:00 Paradox Day 36524.000 => 6 0100-12-31 00:00:00 Paradox Day 146097.000 => 1 0400-12-31 00:00:00 Paradox Day 730485.000 => 1 2000-12-31 00:00:00 First valid Delphi DecodeDate: -693593 2 0001-01-01 00:00:00 -693583 5 0001-01-11 00:00:00 -693584 4 0001-01-10 00:00:00 -693585 3 0001-01-09 00:00:00 -693586 2 0001-01-08 00:00:00 -693587 1 0001-01-07 00:00:00 -693588 7 0001-01-06 00:00:00 -693589 6 0001-01-05 00:00:00 -693590 5 0001-01-04 00:00:00 -693591 4 0001-01-03 00:00:00 -693592 3 0001-01-02 00:00:00 -693593 2 0001-01-01 00:00:00 -693594 1 0000-00-00 00:00:00 -693595 0 0000-00-00 00:00:00 -693596 -1 0000-00-00 00:00:00 -693597 -2 0000-00-00 00:00:00 -693598 -3 0000-00-00 00:00:00 -693599 -4 0000-00-00 00:00:00 -693600 -5 0000-00-00 00:00:00 -693601 1 0000-00-00 00:00:00 -693602 0 0000-00-00 00:00:00 -693603 -1 0000-00-00 00:00:00 -693604 -2 0000-00-00 00:00:00 -693605 -3 0000-00-00 00:00:00 -693606 -4 0000-00-00 00:00:00 -693607 -5 0000-00-00 00:00:00 -693608 1 0000-00-00 00:00:00