-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-25 22:38:42
php  : 2026-08-25 23:38:42
error for %Y %m %x %X, strftime=2026 08 08/25/26 23:38:42, adodb=2026 08 08/25/26 22:38:42
error for %H %M S, strftime=23 38 S, adodb=22 38 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

6:36:54 pm PM 02 Sun August 4 16 04 16 36 2 Sunday 0 08 Aug 8 +0200 RFC2822 Sun, 02 Aug 1981 16:36:54 +0200 54 31 365611014 0 81 1981 213 7200 2003 Error date(): 365611014
 
  "date CEST 1981-08-02 16:36:54 pm PM 02 Sun August 4 16 04 16 36 2 Sunday 0 08 Aug 8 +0200 RFC2822 Sun, 02 Aug 1981 16:36:54 +0200 54 31 365611014 0 81 1981 213 7200 2003" (date len=169)
  "date CEST 1981-08-02 15:36:54 pm PM 02 Sun August 3 15 03 15 36 2 Sunday 0 08 Aug 8 +0100 RFC2822 Sun, 02 Aug 1981 15:36:54 +0100 54 31 365611014 0 81 1981 213 3600 2003" (adodb_date len=169)

Error getdate() 365611014
Array ( [seconds] => 54 [minutes] => 36 [hours] => 16 [mday] => 2 [wday] => 0 [mon] => 8 [year] => 1981 [yday] => 213 [weekday] => Sunday [month] => August [0] => 365611014 )
Array ( [seconds] => 54 [minutes] => 36 [hours] => 15 [mday] => 2 [wday] => 0 [mon] => 8 [year] => 1981 [yday] => 213 [weekday] => Sunday [month] => August [0] => 365611014 )

8:26:49 am AM 07 Sun June 8 8 08 08 26 7 Sunday 0 06 Jun 6 +0200 RFC2822 Sun, 07 Jun 1981 08:26:49 +0200 49 30 360743209 0 81 1981 157 7200 2003 Error date(): 360743209

 
  "date CEST 1981-06-07 08:26:49 am AM 07 Sun June 8 8 08 08 26 7 Sunday 0 06 Jun 6 +0200 RFC2822 Sun, 07 Jun 1981 08:26:49 +0200 49 30 360743209 0 81 1981 157 7200 2003" (date len=166)
  "date CEST 1981-06-07 07:26:49 am AM 07 Sun June 7 7 07 07 26 7 Sunday 0 06 Jun 6 +0100 RFC2822 Sun, 07 Jun 1981 07:26:49 +0100 49 30 360743209 0 81 1981 157 3600 2003" (adodb_date len=166)

Error getdate() 360743209
Array ( [seconds] => 49 [minutes] => 26 [hours] => 8 [mday] => 7 [wday] => 0 [mon] => 6 [year] => 1981 [yday] => 157 [weekday] => Sunday [month] => June [0] => 360743209 )
Array ( [seconds] => 49 [minutes] => 26 [hours] => 7 [mday] => 7 [wday] => 0 [mon] => 6 [year] => 1981 [yday] => 157 [weekday] => Sunday [month] => June [0] => 360743209 )

6:10:54 am AM 17 Sun May 6 6 06 06 10 17 Sunday 0 05 May 5 +0200 RFC2822 Sun, 17 May 1981 06:10:54 +0200 54 31 358920654 0 81 1981 136 7200 2003 Error date(): 358920654

 
  "date CEST 1981-05-17 06:10:54 am AM 17 Sun May 6 6 06 06 10 17 Sunday 0 05 May 5 +0200 RFC2822 Sun, 17 May 1981 06:10:54 +0200 54 31 358920654 0 81 1981 136 7200 2003" (date len=166)
  "date CEST 1981-05-17 05:10:54 am AM 17 Sun May 5 5 05 05 10 17 Sunday 0 05 May 5 +0100 RFC2822 Sun, 17 May 1981 05:10:54 +0100 54 31 358920654 0 81 1981 136 3600 2003" (adodb_date len=166)

Error getdate() 358920654
Array ( [seconds] => 54 [minutes] => 10 [hours] => 6 [mday] => 17 [wday] => 0 [mon] => 5 [year] => 1981 [yday] => 136 [weekday] => Sunday [month] => May [0] => 358920654 )
Array ( [seconds] => 54 [minutes] => 10 [hours] => 5 [mday] => 17 [wday] => 0 [mon] => 5 [year] => 1981 [yday] => 136 [weekday] => Sunday [month] => May [0] => 358920654 )

3:14:22 pm PM 15 Fri May 1 13 01 13 14 15 Friday 0 05 May 5 +0200 RFC2822 Fri, 15 May 1981 13:14:22 +0200 22 31 358773262 5 81 1981 134 7200 2003 Error date(): 358773262

 
  "date CEST 1981-05-15 13:14:22 pm PM 15 Fri May 1 13 01 13 14 15 Friday 0 05 May 5 +0200 RFC2822 Fri, 15 May 1981 13:14:22 +0200 22 31 358773262 5 81 1981 134 7200 2003" (date len=167)
  "date CEST 1981-05-15 12:14:22 pm PM 15 Fri May 12 12 12 12 14 15 Friday 0 05 May 5 +0100 RFC2822 Fri, 15 May 1981 12:14:22 +0100 22 31 358773262 5 81 1981 134 3600 2003" (adodb_date len=168)

Error getdate() 358773262
Array ( [seconds] => 22 [minutes] => 14 [hours] => 13 [mday] => 15 [wday] => 5 [mon] => 5 [year] => 1981 [yday] => 134 [weekday] => Friday [month] => May [0] => 358773262 )
Array ( [seconds] => 22 [minutes] => 14 [hours] => 12 [mday] => 15 [wday] => 5 [mon] => 5 [year] => 1981 [yday] => 134 [weekday] => Friday [month] => May [0] => 358773262 )

5:54:05 pm PM 13 Sun April 3 15 03 15 54 13 Sunday 1 04 Apr 4 +0200 RFC2822 Sun, 13 Apr 1980 15:54:05 +0200 05 30 324482045 0 80 1980 103 7200 2003 Error date(): 324482045

 
  "date CEST 1980-04-13 15:54:05 pm PM 13 Sun April 3 15 03 15 54 13 Sunday 1 04 Apr 4 +0200 RFC2822 Sun, 13 Apr 1980 15:54:05 +0200 05 30 324482045 0 80 1980 103 7200 2003" (date len=169)
  "date CEST 1980-04-13 14:54:05 pm PM 13 Sun April 2 14 02 14 54 13 Sunday 1 04 Apr 4 +0100 RFC2822 Sun, 13 Apr 1980 14:54:05 +0100 05 30 324482045 0 80 1980 103 3600 2003" (adodb_date len=169)

Error getdate() 324482045
Array ( [seconds] => 5 [minutes] => 54 [hours] => 15 [mday] => 13 [wday] => 0 [mon] => 4 [year] => 1980 [yday] => 103 [weekday] => Sunday [month] => April [0] => 324482045 )
Array ( [seconds] => 5 [minutes] => 54 [hours] => 14 [mday] => 13 [wday] => 0 [mon] => 4 [year] => 1980 [yday] => 103 [weekday] => Sunday [month] => April [0] => 324482045 )

3:56:51 am AM 27 Wed August 3 3 03 03 56 27 Wednesday 1 08 Aug 8 +0200 RFC2822 Wed, 27 Aug 1980 03:56:51 +0200 51 31 336189411 3 80 1980 239 7200 2003 Error date(): 336189411

 
  "date CEST 1980-08-27 03:56:51 am AM 27 Wed August 3 3 03 03 56 27 Wednesday 1 08 Aug 8 +0200 RFC2822 Wed, 27 Aug 1980 03:56:51 +0200 51 31 336189411 3 80 1980 239 7200 2003" (date len=172)
  "date CEST 1980-08-27 02:56:51 am AM 27 Wed August 2 2 02 02 56 27 Wednesday 1 08 Aug 8 +0100 RFC2822 Wed, 27 Aug 1980 02:56:51 +0100 51 31 336189411 3 80 1980 239 3600 2003" (adodb_date len=172)

4 00:05:49 am AM 24 Thu September 12 0 12 00 05 24 Thursday 0 09 Sep 9 +0200 RFC2822 Thu, 24 Sep 1981 00:05:49 +0200 49 30 370130749 4 81 1981 266 7200 2003 Error date(): 370130749
 
  "date CEST 1981-09-24 00:05:49 am AM 24 Thu September 12 0 12 00 05 24 Thursday 0 09 Sep 9 +0200 RFC2822 Thu, 24 Sep 1981 00:05:49 +0200 49 30 370130749 4 81 1981 266 7200 2003" (date len=175)
  "date CEST 1981-09-23 23:05:49 pm PM 23 Wed September 11 23 11 23 05 23 Wednesday 0 09 Sep 9 +0100 RFC2822 Wed, 23 Sep 1981 23:05:49 +0100 49 30 370130749 3 81 1981 265 3600 2003" (adodb_date len=177)

Error getdate() 370130749
Array ( [seconds] => 49 [minutes] => 5 [hours] => 0 [mday] => 24 [wday] => 4 [mon] => 9 [year] => 1981 [yday] => 266 [weekday] => Thursday [month] => September [0] => 370130749 )
Array ( [seconds] => 49 [minutes] => 5 [hours] => 23 [mday] => 23 [wday] => 3 [mon] => 9 [year] => 1981 [yday] => 265 [weekday] => Wednesday [month] => September [0] => 370130749 )

2:45:21 pm PM 25 Fri December 10 22 10 22 45 25 Friday 0 12 Dec 12 +0100 RFC2822 Fri, 25 Dec 1981 22:45:21 +0100 21 31 378164721 5 81 1981 358 3600 2003 Error date(): 378164721

 
  "date CET 1981-12-25 22:45:21 pm PM 25 Fri December 10 22 10 22 45 25 Friday 0 12 Dec 12 +0100 RFC2822 Fri, 25 Dec 1981 22:45:21 +0100 21 31 378164721 5 81 1981 358 3600 2003" (date len=173)
  "date CET 1981-12-25 23:45:21 pm PM 25 Fri December 11 23 11 23 45 25 Friday 0 12 Dec 12 +0200 RFC2822 Fri, 25 Dec 1981 23:45:21 +0200 21 31 378164721 5 81 1981 358 7200 2003" (adodb_date len=173)

Error getdate() 378164721
Array ( [seconds] => 21 [minutes] => 45 [hours] => 22 [mday] => 25 [wday] => 5 [mon] => 12 [year] => 1981 [yday] => 358 [weekday] => Friday [month] => December [0] => 378164721 )
Array ( [seconds] => 21 [minutes] => 45 [hours] => 23 [mday] => 25 [wday] => 5 [mon] => 12 [year] => 1981 [yday] => 358 [weekday] => Friday [month] => December [0] => 378164721 )

Testing random dates between 100 and 4000

Testing 1960 to 1972, or 378432000 seconds, offset=83757: 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 Tested 4519 dates

Failed :-(

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