-24 :20-01-2038
-23 :20-02-2038
-22 :20-03-2038
-21 :20-04-2038
-20 :20-05-2038
-19 :20-06-2038
-18 :20-07-2038
-17 :20-08-2038
-16 :20-09-2038
-15 :20-10-2038
-14 :20-11-2038
-13 :20-12-2038
-12 :20-01-2039
-11 :20-02-2039
-10 :20-03-2039
-9 :20-04-2039
-8 :20-05-2039
-7 :20-06-2039
-6 :20-07-2039
-5 :20-08-2039
-4 :20-09-2039
-3 :20-10-2039
-2 :20-11-2039
-1 :20-12-2039
0 :20-01-2040
1 :20-02-2040
2 :20-03-2040
3 :20-04-2040
4 :20-05-2040
5 :20-06-2040
6 :20-07-2040
7 :20-08-2040
8 :20-09-2040
9 :20-10-2040
10 :20-11-2040
11 :20-12-2040
12 :20-01-2041
13 :20-02-2041
14 :20-03-2041
15 :20-04-2041
16 :20-05-2041
17 :20-06-2041
18 :20-07-2041
19 :20-08-2041
20 :20-09-2041
21 :20-10-2041
22 :20-11-2041
23 :20-12-2041
24 :20-01-2042

Testing adodb_date and adodb_mktime. version=0.33 PHP=5.3.13

adodb: 2025-04-28 14:15:12
php  : 2025-04-28 15:15:12
error for %Y %m %x %X, strftime=2025 04 04/28/25 15:15:12, adodb=2025 04 04/28/25 14:15:12
error for %H %M S, strftime=15 15 S, adodb=14 15 S

Testing gregorian <=> julian conversion

-12219386400 -12219300000 15 Oct 1582, Fri=Fri
4 Oct 1582, Thu=Thu

Testing overflow

Testing 2-digit => 4-digit year conversion

Err 2-digit 1940
Err 2-digit 1950

Testing date formating

5:53:03 am AM 29 Thu May 5 5 05 05 53 29 Thursday 1 05 May 5 +0300 RFC2822 Thu, 29 May 1980 05:53:03 +0300 03 31 328416783 4 80 1980 149 10800 2003 Error date(): 328416783
 
  "date EEST 1980-05-29 05:53:03 am AM 29 Thu May 5 5 05 05 53 29 Thursday 1 05 May 5 +0300 RFC2822 Thu, 29 May 1980 05:53:03 +0300 03 31 328416783 4 80 1980 149 10800 2003" (date len=169)
  "date EEST 1980-05-29 04:53:03 am AM 29 Thu May 4 4 04 04 53 29 Thursday 1 05 May 5 +0200 RFC2822 Thu, 29 May 1980 04:53:03 +0200 03 31 328416783 4 80 1980 149 7200 2003" (adodb_date len=168)

7:54:12 am AM 28 Wed November 7 7 07 07 54 28 Wednesday 0 11 Nov 11 +0200 RFC2822 Wed, 28 Nov 1979 07:54:12 +0200 12 30 312616452 3 79 1979 331 7200 2003 Error date(): 312616452
 
  "date EET 1979-11-28 07:54:12 am AM 28 Wed November 7 7 07 07 54 28 Wednesday 0 11 Nov 11 +0200 RFC2822 Wed, 28 Nov 1979 07:54:12 +0200 12 30 312616452 3 79 1979 331 7200 2003" (date len=174)
  "date EET 1979-11-28 08:54:12 am AM 28 Wed November 8 8 08 08 54 28 Wednesday 0 11 Nov 11 +0300 RFC2822 Wed, 28 Nov 1979 08:54:12 +0300 12 30 312616452 3 79 1979 331 10800 2003" (adodb_date len=175)

Error getdate() 312616452
Array ( [seconds] => 12 [minutes] => 54 [hours] => 7 [mday] => 28 [wday] => 3 [mon] => 11 [year] => 1979 [yday] => 331 [weekday] => Wednesday [month] => November [0] => 312616452 )
Array ( [seconds] => 12 [minutes] => 54 [hours] => 8 [mday] => 28 [wday] => 3 [mon] => 11 [year] => 1979 [yday] => 331 [weekday] => Wednesday [month] => November [0] => 312616452 )

10:08:18 am AM 21 Thu June 10 10 10 10 08 21 Thursday 0 06 Jun 6 +0300 RFC2822 Thu, 21 Jun 1979 10:08:18 +0300 18 30 298796898 4 79 1979 171 10800 2003 Error date(): 298796898

 
  "date EEST 1979-06-21 10:08:18 am AM 21 Thu June 10 10 10 10 08 21 Thursday 0 06 Jun 6 +0300 RFC2822 Thu, 21 Jun 1979 10:08:18 +0300 18 30 298796898 4 79 1979 171 10800 2003" (date len=172)
  "date EEST 1979-06-21 09:08:18 am AM 21 Thu June 9 9 09 09 08 21 Thursday 0 06 Jun 6 +0200 RFC2822 Thu, 21 Jun 1979 09:08:18 +0200 18 30 298796898 4 79 1979 171 7200 2003" (adodb_date len=169)

Error getdate() 298796898
Array ( [seconds] => 18 [minutes] => 8 [hours] => 10 [mday] => 21 [wday] => 4 [mon] => 6 [year] => 1979 [yday] => 171 [weekday] => Thursday [month] => June [0] => 298796898 )
Array ( [seconds] => 18 [minutes] => 8 [hours] => 9 [mday] => 21 [wday] => 4 [mon] => 6 [year] => 1979 [yday] => 171 [weekday] => Thursday [month] => June [0] => 298796898 )

5:39:39 pm PM 31 Thu July 3 15 03 15 39 31 Thursday 1 07 Jul 7 +0300 RFC2822 Thu, 31 Jul 1980 15:39:39 +0300 39 31 333895179 4 80 1980 212 10800 2003 Error date(): 333895179

 
  "date EEST 1980-07-31 15:39:39 pm PM 31 Thu July 3 15 03 15 39 31 Thursday 1 07 Jul 7 +0300 RFC2822 Thu, 31 Jul 1980 15:39:39 +0300 39 31 333895179 4 80 1980 212 10800 2003" (date len=171)
  "date EEST 1980-07-31 14:39:39 pm PM 31 Thu July 2 14 02 14 39 31 Thursday 1 07 Jul 7 +0200 RFC2822 Thu, 31 Jul 1980 14:39:39 +0200 39 31 333895179 4 80 1980 212 7200 2003" (adodb_date len=170)

Error getdate() 333895179
Array ( [seconds] => 39 [minutes] => 39 [hours] => 15 [mday] => 31 [wday] => 4 [mon] => 7 [year] => 1980 [yday] => 212 [weekday] => Thursday [month] => July [0] => 333895179 )
Array ( [seconds] => 39 [minutes] => 39 [hours] => 14 [mday] => 31 [wday] => 4 [mon] => 7 [year] => 1980 [yday] => 212 [weekday] => Thursday [month] => July [0] => 333895179 )

3:56:21 am AM 07 Tue August 3 3 03 03 56 7 Tuesday 0 08 Aug 8 +0300 RFC2822 Tue, 07 Aug 1979 03:56:21 +0300 21 31 302835381 2 79 1979 218 10800 2003 Error date(): 302835381

 
  "date EEST 1979-08-07 03:56:21 am AM 07 Tue August 3 3 03 03 56 7 Tuesday 0 08 Aug 8 +0300 RFC2822 Tue, 07 Aug 1979 03:56:21 +0300 21 31 302835381 2 79 1979 218 10800 2003" (date len=170)
  "date EEST 1979-08-07 02:56:21 am AM 07 Tue August 2 2 02 02 56 7 Tuesday 0 08 Aug 8 +0200 RFC2822 Tue, 07 Aug 1979 02:56:21 +0200 21 31 302835381 2 79 1979 218 7200 2003" (adodb_date len=169)

Error getdate() 302835381
Array ( [seconds] => 21 [minutes] => 56 [hours] => 3 [mday] => 7 [wday] => 2 [mon] => 8 [year] => 1979 [yday] => 218 [weekday] => Tuesday [month] => August [0] => 302835381 )
Array ( [seconds] => 21 [minutes] => 56 [hours] => 2 [mday] => 7 [wday] => 2 [mon] => 8 [year] => 1979 [yday] => 218 [weekday] => Tuesday [month] => August [0] => 302835381 )

20:22:30 pm PM 27 Sun May 8 20 08 20 22 27 Sunday 0 05 May 5 +0300 RFC2822 Sun, 27 May 1979 20:22:30 +0300 30 31 296673750 0 79 1979 146 10800 2003 Error date(): 296673750

 
  "date EEST 1979-05-27 20:22:30 pm PM 27 Sun May 8 20 08 20 22 27 Sunday 0 05 May 5 +0300 RFC2822 Sun, 27 May 1979 20:22:30 +0300 30 31 296673750 0 79 1979 146 10800 2003" (date len=168)
  "date EEST 1979-05-27 19:22:30 pm PM 27 Sun May 7 19 07 19 22 27 Sunday 0 05 May 5 +0200 RFC2822 Sun, 27 May 1979 19:22:30 +0200 30 31 296673750 0 79 1979 146 7200 2003" (adodb_date len=167)

Error getdate() 296673750
Array ( [seconds] => 30 [minutes] => 22 [hours] => 20 [mday] => 27 [wday] => 0 [mon] => 5 [year] => 1979 [yday] => 146 [weekday] => Sunday [month] => May [0] => 296673750 )
Array ( [seconds] => 30 [minutes] => 22 [hours] => 19 [mday] => 27 [wday] => 0 [mon] => 5 [year] => 1979 [yday] => 146 [weekday] => Sunday [month] => May [0] => 296673750 )

6:43:32 pm PM 03 Sun June 4 16 04 16 43 3 Sunday 0 06 Jun 6 +0300 RFC2822 Sun, 03 Jun 1979 16:43:32 +0300 32 30 297265412 0 79 1979 153 10800 2003 Error date(): 297265412

 
  "date EEST 1979-06-03 16:43:32 pm PM 03 Sun June 4 16 04 16 43 3 Sunday 0 06 Jun 6 +0300 RFC2822 Sun, 03 Jun 1979 16:43:32 +0300 32 30 297265412 0 79 1979 153 10800 2003" (date len=168)
  "date EEST 1979-06-03 15:43:32 pm PM 03 Sun June 3 15 03 15 43 3 Sunday 0 06 Jun 6 +0200 RFC2822 Sun, 03 Jun 1979 15:43:32 +0200 32 30 297265412 0 79 1979 153 7200 2003" (adodb_date len=167)

Error getdate() 297265412
Array ( [seconds] => 32 [minutes] => 43 [hours] => 16 [mday] => 3 [wday] => 0 [mon] => 6 [year] => 1979 [yday] => 153 [weekday] => Sunday [month] => June [0] => 297265412 )
Array ( [seconds] => 32 [minutes] => 43 [hours] => 15 [mday] => 3 [wday] => 0 [mon] => 6 [year] => 1979 [yday] => 153 [weekday] => Sunday [month] => June [0] => 297265412 )

9:49:21 pm PM 08 Fri August 7 19 07 19 49 8 Friday 1 08 Aug 8 +0300 RFC2822 Fri, 08 Aug 1980 19:49:21 +0300 21 31 334601361 5 80 1980 220 10800 2003 Error date(): 334601361

 
  "date EEST 1980-08-08 19:49:21 pm PM 08 Fri August 7 19 07 19 49 8 Friday 1 08 Aug 8 +0300 RFC2822 Fri, 08 Aug 1980 19:49:21 +0300 21 31 334601361 5 80 1980 220 10800 2003" (date len=170)
  "date EEST 1980-08-08 18:49:21 pm PM 08 Fri August 6 18 06 18 49 8 Friday 1 08 Aug 8 +0200 RFC2822 Fri, 08 Aug 1980 18:49:21 +0200 21 31 334601361 5 80 1980 220 7200 2003" (adodb_date len=169)

Error getdate() 334601361
Array ( [seconds] => 21 [minutes] => 49 [hours] => 19 [mday] => 8 [wday] => 5 [mon] => 8 [year] => 1980 [yday] => 220 [weekday] => Friday [month] => August [0] => 334601361 )
Array ( [seconds] => 21 [minutes] => 49 [hours] => 18 [mday] => 8 [wday] => 5 [mon] => 8 [year] => 1980 [yday] => 220 [weekday] => Friday [month] => August [0] => 334601361 )

8:49:09 pm PM 06 Fri April 6 18 06 18 49 6 Friday 0 04 Apr 4 +0300 RFC2822 Fri, 06 Apr 1979 18:49:09 +0300 09 30 292261749 5 79 1979 95 10800 2003 Error date(): 292261749

 
  "date EEST 1979-04-06 18:49:09 pm PM 06 Fri April 6 18 06 18 49 6 Friday 0 04 Apr 4 +0300 RFC2822 Fri, 06 Apr 1979 18:49:09 +0300 09 30 292261749 5 79 1979 95 10800 2003" (date len=168)
  "date EEST 1979-04-06 17:49:09 pm PM 06 Fri April 5 17 05 17 49 6 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 06 Apr 1979 17:49:09 +0200 09 30 292261749 5 79 1979 95 7200 2003" (adodb_date len=167)

Error getdate() 292261749
Array ( [seconds] => 9 [minutes] => 49 [hours] => 18 [mday] => 6 [wday] => 5 [mon] => 4 [year] => 1979 [yday] => 95 [weekday] => Friday [month] => April [0] => 292261749 )
Array ( [seconds] => 9 [minutes] => 49 [hours] => 17 [mday] => 6 [wday] => 5 [mon] => 4 [year] => 1979 [yday] => 95 [weekday] => Friday [month] => April [0] => 292261749 )

1:22:07 pm PM 20 Sun May 9 21 09 21 22 20 Sunday 0 05 May 5 +0300 RFC2822 Sun, 20 May 1979 21:22:07 +0300 07 31 296072527 0 79 1979 139 10800 2003 Error date(): 296072527

 
  "date EEST 1979-05-20 21:22:07 pm PM 20 Sun May 9 21 09 21 22 20 Sunday 0 05 May 5 +0300 RFC2822 Sun, 20 May 1979 21:22:07 +0300 07 31 296072527 0 79 1979 139 10800 2003" (date len=168)
  "date EEST 1979-05-20 20:22:07 pm PM 20 Sun May 8 20 08 20 22 20 Sunday 0 05 May 5 +0200 RFC2822 Sun, 20 May 1979 20:22:07 +0200 07 31 296072527 0 79 1979 139 7200 2003" (adodb_date len=167)

Error getdate() 296072527
Array ( [seconds] => 7 [minutes] => 22 [hours] => 21 [mday] => 20 [wday] => 0 [mon] => 5 [year] => 1979 [yday] => 139 [weekday] => Sunday [month] => May [0] => 296072527 )
Array ( [seconds] => 7 [minutes] => 22 [hours] => 20 [mday] => 20 [wday] => 0 [mon] => 5 [year] => 1979 [yday] => 139 [weekday] => Sunday [month] => May [0] => 296072527 )

1:32:07 am AM 26 Sat December 1 1 01 01 32 26 Saturday 0 12 Dec 12 +0200 RFC2822 Sat, 26 Dec 1981 01:32:07 +0200 07 31 378171127 6 81 1981 359 7200 2003 Error date(): 378171127

 
  "date EET 1981-12-26 01:32:07 am AM 26 Sat December 1 1 01 01 32 26 Saturday 0 12 Dec 12 +0200 RFC2822 Sat, 26 Dec 1981 01:32:07 +0200 07 31 378171127 6 81 1981 359 7200 2003" (date len=173)
  "date EET 1981-12-26 02:32:07 am AM 26 Sat December 2 2 02 02 32 26 Saturday 0 12 Dec 12 +0300 RFC2822 Sat, 26 Dec 1981 02:32:07 +0300 07 31 378171127 6 81 1981 359 10800 2003" (adodb_date len=174)

Error getdate() 378171127
Array ( [seconds] => 7 [minutes] => 32 [hours] => 1 [mday] => 26 [wday] => 6 [mon] => 12 [year] => 1981 [yday] => 359 [weekday] => Saturday [month] => December [0] => 378171127 )
Array ( [seconds] => 7 [minutes] => 32 [hours] => 2 [mday] => 26 [wday] => 6 [mon] => 12 [year] => 1981 [yday] => 359 [weekday] => Saturday [month] => December [0] => 378171127 )

Testing random dates between 100 and 4000

Testing 1963 to 1975, or 378432000 seconds, offset=70650: 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 Tested 5357 dates

Failed :-(

Original: 2063-12-24
Converted: 24-Dec-2063