-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.35 PHP=5.6.40-81+ubuntu20.04.1+deb.sury.org+1

adodb: 2025-08-06 07:18:53
php  : 2025-08-06 08:18:53
error for %Y %m %x %X, strftime=2025 08 08/06/25 08:18:53, adodb=2025 08 08/06/25 07:18:53
error for %H %M S, strftime=08 18 S, adodb=07 18 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

5:34:45 pm PM 28 Tue December 3 15 03 15 34 28 Tuesday 0 12 Dec 12 +0100 RFC2822 Tue, 28 Dec 1982 15:34:45 +0100 45 31 409934085 2 82 1982 361 3600 2003 Error date(): 409934085
 
  "date CET 1982-12-28 15:34:45 pm PM 28 Tue December 3 15 03 15 34 28 Tuesday 0 12 Dec 12 +0100 RFC2822 Tue, 28 Dec 1982 15:34:45 +0100 45 31 409934085 2 82 1982 361 3600 2003" (date len=173)
  "date CET 1982-12-28 16:34:45 pm PM 28 Tue December 4 16 04 16 34 28 Tuesday 0 12 Dec 12 +0200 RFC2822 Tue, 28 Dec 1982 16:34:45 +0200 45 31 409934085 2 82 1982 361 7200 2003" (adodb_date len=173)

Error getdate() 409934085
Array ( [seconds] => 45 [minutes] => 34 [hours] => 15 [mday] => 28 [wday] => 2 [mon] => 12 [year] => 1982 [yday] => 361 [weekday] => Tuesday [month] => December [0] => 409934085 )
Array ( [seconds] => 45 [minutes] => 34 [hours] => 16 [mday] => 28 [wday] => 2 [mon] => 12 [year] => 1982 [yday] => 361 [weekday] => Tuesday [month] => December [0] => 409934085 )

10:53:04 am AM 03 Sat April 10 10 10 10 53 3 Saturday 0 04 Apr 4 +0200 RFC2822 Sat, 03 Apr 1982 10:53:04 +0200 04 30 386671984 6 82 1982 92 7200 2003 Error date(): 386671984

 
  "date CEST 1982-04-03 10:53:04 am AM 03 Sat April 10 10 10 10 53 3 Saturday 0 04 Apr 4 +0200 RFC2822 Sat, 03 Apr 1982 10:53:04 +0200 04 30 386671984 6 82 1982 92 7200 2003" (date len=170)
  "date CEST 1982-04-03 09:53:04 am AM 03 Sat April 9 9 09 09 53 3 Saturday 0 04 Apr 4 +0100 RFC2822 Sat, 03 Apr 1982 09:53:04 +0100 04 30 386671984 6 82 1982 92 3600 2003" (adodb_date len=168)

Error getdate() 386671984
Array ( [seconds] => 4 [minutes] => 53 [hours] => 10 [mday] => 3 [wday] => 6 [mon] => 4 [year] => 1982 [yday] => 92 [weekday] => Saturday [month] => April [0] => 386671984 )
Array ( [seconds] => 4 [minutes] => 53 [hours] => 9 [mday] => 3 [wday] => 6 [mon] => 4 [year] => 1982 [yday] => 92 [weekday] => Saturday [month] => April [0] => 386671984 )

7 00:35:10 am AM 27 Mon April 12 0 12 00 35 27 Monday 0 04 Apr 4 +0200 RFC2822 Mon, 27 Apr 1981 00:35:10 +0200 10 30 357172510 1 81 1981 116 7200 2003 Error date(): 357172510

 
  "date CEST 1981-04-27 00:35:10 am AM 27 Mon April 12 0 12 00 35 27 Monday 0 04 Apr 4 +0200 RFC2822 Mon, 27 Apr 1981 00:35:10 +0200 10 30 357172510 1 81 1981 116 7200 2003" (date len=169)
  "date CEST 1981-04-26 23:35:10 pm PM 26 Sun April 11 23 11 23 35 26 Sunday 0 04 Apr 4 +0100 RFC2822 Sun, 26 Apr 1981 23:35:10 +0100 10 30 357172510 0 81 1981 115 3600 2003" (adodb_date len=170)

Error getdate() 357172510
Array ( [seconds] => 10 [minutes] => 35 [hours] => 0 [mday] => 27 [wday] => 1 [mon] => 4 [year] => 1981 [yday] => 116 [weekday] => Monday [month] => April [0] => 357172510 )
Array ( [seconds] => 10 [minutes] => 35 [hours] => 23 [mday] => 26 [wday] => 0 [mon] => 4 [year] => 1981 [yday] => 115 [weekday] => Sunday [month] => April [0] => 357172510 )

6:04:36 am AM 29 Mon June 6 6 06 06 04 29 Monday 0 06 Jun 6 +0200 RFC2822 Mon, 29 Jun 1981 06:04:36 +0200 36 30 362635476 1 81 1981 179 7200 2003 Error date(): 362635476

 
  "date CEST 1981-06-29 06:04:36 am AM 29 Mon June 6 6 06 06 04 29 Monday 0 06 Jun 6 +0200 RFC2822 Mon, 29 Jun 1981 06:04:36 +0200 36 30 362635476 1 81 1981 179 7200 2003" (date len=167)
  "date CEST 1981-06-29 05:04:36 am AM 29 Mon June 5 5 05 05 04 29 Monday 0 06 Jun 6 +0100 RFC2822 Mon, 29 Jun 1981 05:04:36 +0100 36 30 362635476 1 81 1981 179 3600 2003" (adodb_date len=167)

8:03:45 am AM 16 Thu April 8 8 08 08 03 16 Thursday 0 04 Apr 4 +0200 RFC2822 Thu, 16 Apr 1981 08:03:45 +0200 45 30 356249025 4 81 1981 105 7200 2003 Error date(): 356249025
 
  "date CEST 1981-04-16 08:03:45 am AM 16 Thu April 8 8 08 08 03 16 Thursday 0 04 Apr 4 +0200 RFC2822 Thu, 16 Apr 1981 08:03:45 +0200 45 30 356249025 4 81 1981 105 7200 2003" (date len=170)
  "date CEST 1981-04-16 07:03:45 am AM 16 Thu April 7 7 07 07 03 16 Thursday 0 04 Apr 4 +0100 RFC2822 Thu, 16 Apr 1981 07:03:45 +0100 45 30 356249025 4 81 1981 105 3600 2003" (adodb_date len=170)

Error getdate() 356249025
Array ( [seconds] => 45 [minutes] => 3 [hours] => 8 [mday] => 16 [wday] => 4 [mon] => 4 [year] => 1981 [yday] => 105 [weekday] => Thursday [month] => April [0] => 356249025 )
Array ( [seconds] => 45 [minutes] => 3 [hours] => 7 [mday] => 16 [wday] => 4 [mon] => 4 [year] => 1981 [yday] => 105 [weekday] => Thursday [month] => April [0] => 356249025 )

3:47:47 pm PM 27 Fri August 11 23 11 23 47 27 Friday 0 08 Aug 8 +0200 RFC2822 Fri, 27 Aug 1982 23:47:47 +0200 47 31 399332867 5 82 1982 238 7200 2003 Error date(): 399332867

 
  "date CEST 1982-08-27 23:47:47 pm PM 27 Fri August 11 23 11 23 47 27 Friday 0 08 Aug 8 +0200 RFC2822 Fri, 27 Aug 1982 23:47:47 +0200 47 31 399332867 5 82 1982 238 7200 2003" (date len=171)
  "date CEST 1982-08-27 22:47:47 pm PM 27 Fri August 10 22 10 22 47 27 Friday 0 08 Aug 8 +0100 RFC2822 Fri, 27 Aug 1982 22:47:47 +0100 47 31 399332867 5 82 1982 238 3600 2003" (adodb_date len=171)

Error getdate() 399332867
Array ( [seconds] => 47 [minutes] => 47 [hours] => 23 [mday] => 27 [wday] => 5 [mon] => 8 [year] => 1982 [yday] => 238 [weekday] => Friday [month] => August [0] => 399332867 )
Array ( [seconds] => 47 [minutes] => 47 [hours] => 22 [mday] => 27 [wday] => 5 [mon] => 8 [year] => 1982 [yday] => 238 [weekday] => Friday [month] => August [0] => 399332867 )

7:17:55 am AM 10 Wed June 7 7 07 07 17 10 Wednesday 0 06 Jun 6 +0200 RFC2822 Wed, 10 Jun 1981 07:17:55 +0200 55 30 360998275 3 81 1981 160 7200 2003 Error date(): 360998275

 
  "date CEST 1981-06-10 07:17:55 am AM 10 Wed June 7 7 07 07 17 10 Wednesday 0 06 Jun 6 +0200 RFC2822 Wed, 10 Jun 1981 07:17:55 +0200 55 30 360998275 3 81 1981 160 7200 2003" (date len=170)
  "date CEST 1981-06-10 06:17:55 am AM 10 Wed June 6 6 06 06 17 10 Wednesday 0 06 Jun 6 +0100 RFC2822 Wed, 10 Jun 1981 06:17:55 +0100 55 30 360998275 3 81 1981 160 3600 2003" (adodb_date len=170)

Error getdate() 360998275
Array ( [seconds] => 55 [minutes] => 17 [hours] => 7 [mday] => 10 [wday] => 3 [mon] => 6 [year] => 1981 [yday] => 160 [weekday] => Wednesday [month] => June [0] => 360998275 )
Array ( [seconds] => 55 [minutes] => 17 [hours] => 6 [mday] => 10 [wday] => 3 [mon] => 6 [year] => 1981 [yday] => 160 [weekday] => Wednesday [month] => June [0] => 360998275 )

8:54:56 am AM 24 Fri April 8 8 08 08 54 24 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 24 Apr 1981 08:54:56 +0200 56 30 356943296 5 81 1981 113 7200 2003 Error date(): 356943296

 
  "date CEST 1981-04-24 08:54:56 am AM 24 Fri April 8 8 08 08 54 24 Friday 0 04 Apr 4 +0200 RFC2822 Fri, 24 Apr 1981 08:54:56 +0200 56 30 356943296 5 81 1981 113 7200 2003" (date len=168)
  "date CEST 1981-04-24 07:54:56 am AM 24 Fri April 7 7 07 07 54 24 Friday 0 04 Apr 4 +0100 RFC2822 Fri, 24 Apr 1981 07:54:56 +0100 56 30 356943296 5 81 1981 113 3600 2003" (adodb_date len=168)

Error getdate() 356943296
Array ( [seconds] => 56 [minutes] => 54 [hours] => 8 [mday] => 24 [wday] => 5 [mon] => 4 [year] => 1981 [yday] => 113 [weekday] => Friday [month] => April [0] => 356943296 )
Array ( [seconds] => 56 [minutes] => 54 [hours] => 7 [mday] => 24 [wday] => 5 [mon] => 4 [year] => 1981 [yday] => 113 [weekday] => Friday [month] => April [0] => 356943296 )

3:39:35 pm PM 20 Mon June 1 13 01 13 39 20 Monday 0 06 Jun 6 +0200 RFC2822 Mon, 20 Jun 1983 13:39:35 +0200 35 30 424957175 1 83 1983 170 7200 2003 Error date(): 424957175

 
  "date CEST 1983-06-20 13:39:35 pm PM 20 Mon June 1 13 01 13 39 20 Monday 0 06 Jun 6 +0200 RFC2822 Mon, 20 Jun 1983 13:39:35 +0200 35 30 424957175 1 83 1983 170 7200 2003" (date len=168)
  "date CEST 1983-06-20 12:39:35 pm PM 20 Mon June 12 12 12 12 39 20 Monday 0 06 Jun 6 +0100 RFC2822 Mon, 20 Jun 1983 12:39:35 +0100 35 30 424957175 1 83 1983 170 3600 2003" (adodb_date len=169)

Error getdate() 424957175
Array ( [seconds] => 35 [minutes] => 39 [hours] => 13 [mday] => 20 [wday] => 1 [mon] => 6 [year] => 1983 [yday] => 170 [weekday] => Monday [month] => June [0] => 424957175 )
Array ( [seconds] => 35 [minutes] => 39 [hours] => 12 [mday] => 20 [wday] => 1 [mon] => 6 [year] => 1983 [yday] => 170 [weekday] => Monday [month] => June [0] => 424957175 )

8:22:24 pm PM 05 Sun June 6 18 06 18 22 5 Sunday 0 06 Jun 6 +0200 RFC2822 Sun, 05 Jun 1983 18:22:24 +0200 24 30 423678144 0 83 1983 155 7200 2003 Error date(): 423678144

 
  "date CEST 1983-06-05 18:22:24 pm PM 05 Sun June 6 18 06 18 22 5 Sunday 0 06 Jun 6 +0200 RFC2822 Sun, 05 Jun 1983 18:22:24 +0200 24 30 423678144 0 83 1983 155 7200 2003" (date len=167)
  "date CEST 1983-06-05 17:22:24 pm PM 05 Sun June 5 17 05 17 22 5 Sunday 0 06 Jun 6 +0100 RFC2822 Sun, 05 Jun 1983 17:22:24 +0100 24 30 423678144 0 83 1983 155 3600 2003" (adodb_date len=167)

Error getdate() 423678144
Array ( [seconds] => 24 [minutes] => 22 [hours] => 18 [mday] => 5 [wday] => 0 [mon] => 6 [year] => 1983 [yday] => 155 [weekday] => Sunday [month] => June [0] => 423678144 )
Array ( [seconds] => 24 [minutes] => 22 [hours] => 17 [mday] => 5 [wday] => 0 [mon] => 6 [year] => 1983 [yday] => 155 [weekday] => Sunday [month] => June [0] => 423678144 )

2:11:57 pm PM 31 Thu July 10 22 10 22 11 31 Thursday 1 07 Jul 7 +0200 RFC2822 Thu, 31 Jul 1980 22:11:57 +0200 57 31 333922317 4 80 1980 212 7200 2003 Error date(): 333922317

 
  "date CEST 1980-07-31 22:11:57 pm PM 31 Thu July 10 22 10 22 11 31 Thursday 1 07 Jul 7 +0200 RFC2822 Thu, 31 Jul 1980 22:11:57 +0200 57 31 333922317 4 80 1980 212 7200 2003" (date len=171)
  "date CEST 1980-07-31 21:11:57 pm PM 31 Thu July 9 21 09 21 11 31 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 31 Jul 1980 21:11:57 +0100 57 31 333922317 4 80 1980 212 3600 2003" (adodb_date len=170)

Error getdate() 333922317
Array ( [seconds] => 57 [minutes] => 11 [hours] => 22 [mday] => 31 [wday] => 4 [mon] => 7 [year] => 1980 [yday] => 212 [weekday] => Thursday [month] => July [0] => 333922317 )
Array ( [seconds] => 57 [minutes] => 11 [hours] => 21 [mday] => 31 [wday] => 4 [mon] => 7 [year] => 1980 [yday] => 212 [weekday] => Thursday [month] => July [0] => 333922317 )

Testing random dates between 100 and 4000

Testing 1969 to 1981, or 378432000 seconds, offset=95432: 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 Tested 3966 dates

Failed :-(

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