-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.6.30-7+deb.sury.org~xenial+1

adodb: 2026-08-23 23:20:19
php  : 2026-08-24 00:20:19
error for %Y %m %x %X, strftime=2026 08 08/24/26 00:20:19, adodb=2026 08 08/23/26 23:20:19
error for %A %d %B %Y, strftime=Monday 24 August 2026, adodb=Sunday 23 August 2026
error for %H %M S, strftime=00 20 S, adodb=23 20 S

Testing gregorian <=> julian conversion

-12219382800 -12219296400 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

1:56:36 am AM 02 Wed July 1 1 01 01 56 2 Wednesday 1 07 Jul 7 +0200 RFC2822 Wed, 02 Jul 1980 01:56:36 +0200 36 31 331343796 3 80 1980 183 7200 2003 Error date(): 331343796
 
  "date CEST 1980-07-02 01:56:36 am AM 02 Wed July 1 1 01 01 56 2 Wednesday 1 07 Jul 7 +0200 RFC2822 Wed, 02 Jul 1980 01:56:36 +0200 36 31 331343796 3 80 1980 183 7200 2003" (date len=169)
  "date CEST 1980-07-02 00:56:36 am AM 02 Wed July 12 0 12 00 56 2 Wednesday 1 07 Jul 7 +0100 RFC2822 Wed, 02 Jul 1980 00:56:36 +0100 36 31 331343796 3 80 1980 183 3600 2003" (adodb_date len=170)

Error getdate() 331343796
Array ( [seconds] => 36 [minutes] => 56 [hours] => 1 [mday] => 2 [wday] => 3 [mon] => 7 [year] => 1980 [yday] => 183 [weekday] => Wednesday [month] => July [0] => 331343796 )
Array ( [seconds] => 36 [minutes] => 56 [hours] => 0 [mday] => 2 [wday] => 3 [mon] => 7 [year] => 1980 [yday] => 183 [weekday] => Wednesday [month] => July [0] => 331343796 )

0:24:45 pm PM 23 Wed December 8 20 08 20 24 23 Wednesday 0 12 Dec 12 +0100 RFC2822 Wed, 23 Dec 1981 20:24:45 +0100 45 31 377983485 3 81 1981 356 3600 2003 Error date(): 377983485

 
  "date CET 1981-12-23 20:24:45 pm PM 23 Wed December 8 20 08 20 24 23 Wednesday 0 12 Dec 12 +0100 RFC2822 Wed, 23 Dec 1981 20:24:45 +0100 45 31 377983485 3 81 1981 356 3600 2003" (date len=175)
  "date CET 1981-12-23 21:24:45 pm PM 23 Wed December 9 21 09 21 24 23 Wednesday 0 12 Dec 12 +0200 RFC2822 Wed, 23 Dec 1981 21:24:45 +0200 45 31 377983485 3 81 1981 356 7200 2003" (adodb_date len=175)

Error getdate() 377983485
Array ( [seconds] => 45 [minutes] => 24 [hours] => 20 [mday] => 23 [wday] => 3 [mon] => 12 [year] => 1981 [yday] => 356 [weekday] => Wednesday [month] => December [0] => 377983485 )
Array ( [seconds] => 45 [minutes] => 24 [hours] => 21 [mday] => 23 [wday] => 3 [mon] => 12 [year] => 1981 [yday] => 356 [weekday] => Wednesday [month] => December [0] => 377983485 )

3:19:29 pm PM 04 Mon May 11 23 11 23 19 4 Monday 0 05 May 5 +0200 RFC2822 Mon, 04 May 1981 23:19:29 +0200 29 31 357859169 1 81 1981 123 7200 2003 Error date(): 357859169

 
  "date CEST 1981-05-04 23:19:29 pm PM 04 Mon May 11 23 11 23 19 4 Monday 0 05 May 5 +0200 RFC2822 Mon, 04 May 1981 23:19:29 +0200 29 31 357859169 1 81 1981 123 7200 2003" (date len=167)
  "date CEST 1981-05-04 22:19:29 pm PM 04 Mon May 10 22 10 22 19 4 Monday 0 05 May 5 +0100 RFC2822 Mon, 04 May 1981 22:19:29 +0100 29 31 357859169 1 81 1981 123 3600 2003" (adodb_date len=167)

Error getdate() 357859169
Array ( [seconds] => 29 [minutes] => 19 [hours] => 23 [mday] => 4 [wday] => 1 [mon] => 5 [year] => 1981 [yday] => 123 [weekday] => Monday [month] => May [0] => 357859169 )
Array ( [seconds] => 29 [minutes] => 19 [hours] => 22 [mday] => 4 [wday] => 1 [mon] => 5 [year] => 1981 [yday] => 123 [weekday] => Monday [month] => May [0] => 357859169 )

2:18:19 pm PM 28 Sat November 12 12 12 12 18 28 Saturday 0 11 Nov 11 +0100 RFC2822 Sat, 28 Nov 1981 12:18:19 +0100 19 30 375794299 6 81 1981 331 3600 2003 Error date(): 375794299

 
  "date CET 1981-11-28 12:18:19 pm PM 28 Sat November 12 12 12 12 18 28 Saturday 0 11 Nov 11 +0100 RFC2822 Sat, 28 Nov 1981 12:18:19 +0100 19 30 375794299 6 81 1981 331 3600 2003" (date len=175)
  "date CET 1981-11-28 13:18:19 pm PM 28 Sat November 1 13 01 13 18 28 Saturday 0 11 Nov 11 +0200 RFC2822 Sat, 28 Nov 1981 13:18:19 +0200 19 30 375794299 6 81 1981 331 7200 2003" (adodb_date len=174)

Error getdate() 375794299
Array ( [seconds] => 19 [minutes] => 18 [hours] => 12 [mday] => 28 [wday] => 6 [mon] => 11 [year] => 1981 [yday] => 331 [weekday] => Saturday [month] => November [0] => 375794299 )
Array ( [seconds] => 19 [minutes] => 18 [hours] => 13 [mday] => 28 [wday] => 6 [mon] => 11 [year] => 1981 [yday] => 331 [weekday] => Saturday [month] => November [0] => 375794299 )

2:26:25 pm PM 20 Sat June 12 12 12 12 26 20 Saturday 0 06 Jun 6 +0200 RFC2822 Sat, 20 Jun 1981 12:26:25 +0200 25 30 361880785 6 81 1981 170 7200 2003 Error date(): 361880785

 
  "date CEST 1981-06-20 12:26:25 pm PM 20 Sat June 12 12 12 12 26 20 Saturday 0 06 Jun 6 +0200 RFC2822 Sat, 20 Jun 1981 12:26:25 +0200 25 30 361880785 6 81 1981 170 7200 2003" (date len=171)
  "date CEST 1981-06-20 11:26:25 am AM 20 Sat June 11 11 11 11 26 20 Saturday 0 06 Jun 6 +0100 RFC2822 Sat, 20 Jun 1981 11:26:25 +0100 25 30 361880785 6 81 1981 170 3600 2003" (adodb_date len=171)

Error getdate() 361880785
Array ( [seconds] => 25 [minutes] => 26 [hours] => 12 [mday] => 20 [wday] => 6 [mon] => 6 [year] => 1981 [yday] => 170 [weekday] => Saturday [month] => June [0] => 361880785 )
Array ( [seconds] => 25 [minutes] => 26 [hours] => 11 [mday] => 20 [wday] => 6 [mon] => 6 [year] => 1981 [yday] => 170 [weekday] => Saturday [month] => June [0] => 361880785 )

1:04:20 am AM 22 Wed July 11 11 11 11 04 22 Wednesday 0 07 Jul 7 +0200 RFC2822 Wed, 22 Jul 1981 11:04:20 +0200 20 31 364640660 3 81 1981 202 7200 2003 Error date(): 364640660

 
  "date CEST 1981-07-22 11:04:20 am AM 22 Wed July 11 11 11 11 04 22 Wednesday 0 07 Jul 7 +0200 RFC2822 Wed, 22 Jul 1981 11:04:20 +0200 20 31 364640660 3 81 1981 202 7200 2003" (date len=172)
  "date CEST 1981-07-22 10:04:20 am AM 22 Wed July 10 10 10 10 04 22 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 22 Jul 1981 10:04:20 +0100 20 31 364640660 3 81 1981 202 3600 2003" (adodb_date len=172)

Error getdate() 364640660
Array ( [seconds] => 20 [minutes] => 4 [hours] => 11 [mday] => 22 [wday] => 3 [mon] => 7 [year] => 1981 [yday] => 202 [weekday] => Wednesday [month] => July [0] => 364640660 )
Array ( [seconds] => 20 [minutes] => 4 [hours] => 10 [mday] => 22 [wday] => 3 [mon] => 7 [year] => 1981 [yday] => 202 [weekday] => Wednesday [month] => July [0] => 364640660 )

4:47:32 pm PM 01 Fri May 2 14 02 14 47 1 Friday 0 05 May 5 +0200 RFC2822 Fri, 01 May 1981 14:47:32 +0200 32 31 357569252 5 81 1981 120 7200 2003 Error date(): 357569252

 
  "date CEST 1981-05-01 14:47:32 pm PM 01 Fri May 2 14 02 14 47 1 Friday 0 05 May 5 +0200 RFC2822 Fri, 01 May 1981 14:47:32 +0200 32 31 357569252 5 81 1981 120 7200 2003" (date len=166)
  "date CEST 1981-05-01 13:47:32 pm PM 01 Fri May 1 13 01 13 47 1 Friday 0 05 May 5 +0100 RFC2822 Fri, 01 May 1981 13:47:32 +0100 32 31 357569252 5 81 1981 120 3600 2003" (adodb_date len=166)

Error getdate() 357569252
Array ( [seconds] => 32 [minutes] => 47 [hours] => 14 [mday] => 1 [wday] => 5 [mon] => 5 [year] => 1981 [yday] => 120 [weekday] => Friday [month] => May [0] => 357569252 )
Array ( [seconds] => 32 [minutes] => 47 [hours] => 13 [mday] => 1 [wday] => 5 [mon] => 5 [year] => 1981 [yday] => 120 [weekday] => Friday [month] => May [0] => 357569252 )

7:59:54 pm PM 12 Wed May 5 17 05 17 59 12 Wednesday 0 05 May 5 +0200 RFC2822 Wed, 12 May 1982 17:59:54 +0200 54 31 390067194 3 82 1982 131 7200 2003 Error date(): 390067194

 
  "date CEST 1982-05-12 17:59:54 pm PM 12 Wed May 5 17 05 17 59 12 Wednesday 0 05 May 5 +0200 RFC2822 Wed, 12 May 1982 17:59:54 +0200 54 31 390067194 3 82 1982 131 7200 2003" (date len=170)
  "date CEST 1982-05-12 16:59:54 pm PM 12 Wed May 4 16 04 16 59 12 Wednesday 0 05 May 5 +0100 RFC2822 Wed, 12 May 1982 16:59:54 +0100 54 31 390067194 3 82 1982 131 3600 2003" (adodb_date len=170)

Error getdate() 390067194
Array ( [seconds] => 54 [minutes] => 59 [hours] => 17 [mday] => 12 [wday] => 3 [mon] => 5 [year] => 1982 [yday] => 131 [weekday] => Wednesday [month] => May [0] => 390067194 )
Array ( [seconds] => 54 [minutes] => 59 [hours] => 16 [mday] => 12 [wday] => 3 [mon] => 5 [year] => 1982 [yday] => 131 [weekday] => Wednesday [month] => May [0] => 390067194 )

1:43:07 am AM 24 Fri April 11 11 11 11 43 24 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 24 Apr 1981 11:43:07 +0200 07 30 356953387 5 81 1981 113 7200 2003 Error date(): 356953387

 
  "date CEST 1981-04-24 11:43:07 am AM 24 Fri April 11 11 11 11 43 24 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 24 Apr 1981 11:43:07 +0200 07 30 356953387 5 81 1981 113 7200 2003" (date len=170)
  "date CEST 1981-04-24 10:43:07 am AM 24 Fri April 10 10 10 10 43 24 Friday 0 04 Apr 4 +0100 RFC2822 Fri, 24 Apr 1981 10:43:07 +0100 07 30 356953387 5 81 1981 113 3600 2003" (adodb_date len=170)

Error getdate() 356953387
Array ( [seconds] => 7 [minutes] => 43 [hours] => 11 [mday] => 24 [wday] => 5 [mon] => 4 [year] => 1981 [yday] => 113 [weekday] => Friday [month] => April [0] => 356953387 )
Array ( [seconds] => 7 [minutes] => 43 [hours] => 10 [mday] => 24 [wday] => 5 [mon] => 4 [year] => 1981 [yday] => 113 [weekday] => Friday [month] => April [0] => 356953387 )

1:24:19 am AM 08 Thu May 11 11 11 11 24 8 Thursday 1 05 May 5 +0200 RFC2822 Thu, 08 May 1980 11:24:19 +0200 19 31 326625859 4 80 1980 128 7200 2003 Error date(): 326625859

 
  "date CEST 1980-05-08 11:24:19 am AM 08 Thu May 11 11 11 11 24 8 Thursday 1 05 May 5 +0200 RFC2822 Thu, 08 May 1980 11:24:19 +0200 19 31 326625859 4 80 1980 128 7200 2003" (date len=169)
  "date CEST 1980-05-08 10:24:19 am AM 08 Thu May 10 10 10 10 24 8 Thursday 1 05 May 5 +0100 RFC2822 Thu, 08 May 1980 10:24:19 +0100 19 31 326625859 4 80 1980 128 3600 2003" (adodb_date len=169)

Error getdate() 326625859
Array ( [seconds] => 19 [minutes] => 24 [hours] => 11 [mday] => 8 [wday] => 4 [mon] => 5 [year] => 1980 [yday] => 128 [weekday] => Thursday [month] => May [0] => 326625859 )
Array ( [seconds] => 19 [minutes] => 24 [hours] => 10 [mday] => 8 [wday] => 4 [mon] => 5 [year] => 1980 [yday] => 128 [weekday] => Thursday [month] => May [0] => 326625859 )

7:07:02 pm PM 17 Fri April 5 17 05 17 07 17 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 17 Apr 1981 17:07:02 +0200 02 30 356368022 5 81 1981 106 7200 2003 Error date(): 356368022

 
  "date CEST 1981-04-17 17:07:02 pm PM 17 Fri April 5 17 05 17 07 17 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 17 Apr 1981 17:07:02 +0200 02 30 356368022 5 81 1981 106 7200 2003" (date len=169)
  "date CEST 1981-04-17 16:07:02 pm PM 17 Fri April 4 16 04 16 07 17 Friday 0 04 Apr 4 +0100 RFC2822 Fri, 17 Apr 1981 16:07:02 +0100 02 30 356368022 5 81 1981 106 3600 2003" (adodb_date len=169)

1:04:52 pm PM 11 Wed June 9 21 09 21 04 11 Wednesday 1 06 Jun 6 +0200 RFC2822 Wed, 11 Jun 1980 21:04:52 +0200 52 30 329598292 3 80 1980 162 7200 2003 Error date(): 329598292
 
  "date CEST 1980-06-11 21:04:52 pm PM 11 Wed June 9 21 09 21 04 11 Wednesday 1 06 Jun 6 +0200 RFC2822 Wed, 11 Jun 1980 21:04:52 +0200 52 30 329598292 3 80 1980 162 7200 2003" (date len=171)
  "date CEST 1980-06-11 20:04:52 pm PM 11 Wed June 8 20 08 20 04 11 Wednesday 1 06 Jun 6 +0100 RFC2822 Wed, 11 Jun 1980 20:04:52 +0100 52 30 329598292 3 80 1980 162 3600 2003" (adodb_date len=171)

Error getdate() 329598292
Array ( [seconds] => 52 [minutes] => 4 [hours] => 21 [mday] => 11 [wday] => 3 [mon] => 6 [year] => 1980 [yday] => 162 [weekday] => Wednesday [month] => June [0] => 329598292 )
Array ( [seconds] => 52 [minutes] => 4 [hours] => 20 [mday] => 11 [wday] => 3 [mon] => 6 [year] => 1980 [yday] => 162 [weekday] => Wednesday [month] => June [0] => 329598292 )

Testing random dates between 100 and 4000

Testing 1962 to 1974, or 378432000 seconds, offset=74294: 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 Tested 5094 dates

Failed :-(

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