-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=7.4.33

adodb: 2025-12-08 20:39:14
php  : 2025-12-08 21:39:14
error for %Y %m %x %X, strftime=2025 12 12/08/25 21:39:14, adodb=2025 12 12/08/25 20:39:14
error for %H %M S, strftime=21 39 S, adodb=20 39 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

8:16:52 am AM 01 Tue June 8 8 08 08 16 1 Tuesday 1 06 Jun 6 +0100 RFC2822 Tue, 01 Jun 1976 08:16:52 +0100 52 30 202461412 2 76 1976 152 3600 2003 Error date(): 202461412
  "date +01 1976-06-01 08:16:52 am AM 01 Tue June 8 8 08 08 16 1 Tuesday 1 06 Jun 6 +0100 RFC2822 Tue, 01 Jun 1976 08:16:52 +0100 52 30 202461412 2 76 1976 152 3600 2003" (date len=166)
  "date +01 1976-06-01 07:16:52 am AM 01 Tue June 7 7 07 07 16 1 Tuesday 1 06 Jun 6 +0000 RFC2822 Tue, 01 Jun 1976 07:16:52 +0000 52 30 202461412 2 76 1976 152 0 2003" (adodb_date len=163)

Error getdate() 202461412
Array ( [seconds] => 52 [minutes] => 16 [hours] => 8 [mday] => 1 [wday] => 2 [mon] => 6 [year] => 1976 [yday] => 152 [weekday] => Tuesday [month] => June [0] => 202461412 )
Array ( [seconds] => 52 [minutes] => 16 [hours] => 7 [mday] => 1 [wday] => 2 [mon] => 6 [year] => 1976 [yday] => 152 [weekday] => Tuesday [month] => June [0] => 202461412 )

1:58:44 pm PM 23 Sun July 9 21 09 21 58 23 Sunday 0 07 Jul 7 +0100 RFC2822 Sun, 23 Jul 1978 21:58:44 +0100 44 31 270075524 0 78 1978 203 3600 2003 Error date(): 270075524

  "date +01 1978-07-23 21:58:44 pm PM 23 Sun July 9 21 09 21 58 23 Sunday 0 07 Jul 7 +0100 RFC2822 Sun, 23 Jul 1978 21:58:44 +0100 44 31 270075524 0 78 1978 203 3600 2003" (date len=167)
  "date +01 1978-07-23 20:58:44 pm PM 23 Sun July 8 20 08 20 58 23 Sunday 0 07 Jul 7 +0000 RFC2822 Sun, 23 Jul 1978 20:58:44 +0000 44 31 270075524 0 78 1978 203 0 2003" (adodb_date len=164)

Error getdate() 270075524
Array ( [seconds] => 44 [minutes] => 58 [hours] => 21 [mday] => 23 [wday] => 0 [mon] => 7 [year] => 1978 [yday] => 203 [weekday] => Sunday [month] => July [0] => 270075524 )
Array ( [seconds] => 44 [minutes] => 58 [hours] => 20 [mday] => 23 [wday] => 0 [mon] => 7 [year] => 1978 [yday] => 203 [weekday] => Sunday [month] => July [0] => 270075524 )

1:38:19 am AM 27 Thu May 11 11 11 11 38 27 Thursday 1 05 May 5 +0100 RFC2822 Thu, 27 May 1976 11:38:19 +0100 19 31 202041499 4 76 1976 147 3600 2003 Error date(): 202041499

  "date +01 1976-05-27 11:38:19 am AM 27 Thu May 11 11 11 11 38 27 Thursday 1 05 May 5 +0100 RFC2822 Thu, 27 May 1976 11:38:19 +0100 19 31 202041499 4 76 1976 147 3600 2003" (date len=169)
  "date +01 1976-05-27 10:38:19 am AM 27 Thu May 10 10 10 10 38 27 Thursday 1 05 May 5 +0000 RFC2822 Thu, 27 May 1976 10:38:19 +0000 19 31 202041499 4 76 1976 147 0 2003" (adodb_date len=166)

Error getdate() 202041499
Array ( [seconds] => 19 [minutes] => 38 [hours] => 11 [mday] => 27 [wday] => 4 [mon] => 5 [year] => 1976 [yday] => 147 [weekday] => Thursday [month] => May [0] => 202041499 )
Array ( [seconds] => 19 [minutes] => 38 [hours] => 10 [mday] => 27 [wday] => 4 [mon] => 5 [year] => 1976 [yday] => 147 [weekday] => Thursday [month] => May [0] => 202041499 )

3:33:06 pm PM 22 Sat May 1 13 01 13 33 22 Saturday 1 05 May 5 +0100 RFC2822 Sat, 22 May 1976 13:33:06 +0100 06 31 201616386 6 76 1976 142 3600 2003 Error date(): 201616386

  "date +01 1976-05-22 13:33:06 pm PM 22 Sat May 1 13 01 13 33 22 Saturday 1 05 May 5 +0100 RFC2822 Sat, 22 May 1976 13:33:06 +0100 06 31 201616386 6 76 1976 142 3600 2003" (date len=168)
  "date +01 1976-05-22 12:33:06 pm PM 22 Sat May 12 12 12 12 33 22 Saturday 1 05 May 5 +0000 RFC2822 Sat, 22 May 1976 12:33:06 +0000 06 31 201616386 6 76 1976 142 0 2003" (adodb_date len=166)

Error getdate() 201616386
Array ( [seconds] => 6 [minutes] => 33 [hours] => 13 [mday] => 22 [wday] => 6 [mon] => 5 [year] => 1976 [yday] => 142 [weekday] => Saturday [month] => May [0] => 201616386 )
Array ( [seconds] => 6 [minutes] => 33 [hours] => 12 [mday] => 22 [wday] => 6 [mon] => 5 [year] => 1976 [yday] => 142 [weekday] => Saturday [month] => May [0] => 201616386 )

6:03:27 pm PM 31 Wed July 4 16 04 16 03 31 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 31 Jul 1974 16:03:27 +0100 27 31 144515007 3 74 1974 211 3600 2003 Error date(): 144515007

  "date +01 1974-07-31 16:03:27 pm PM 31 Wed July 4 16 04 16 03 31 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 31 Jul 1974 16:03:27 +0100 27 31 144515007 3 74 1974 211 3600 2003" (date len=170)
  "date +01 1974-07-31 15:03:27 pm PM 31 Wed July 3 15 03 15 03 31 Wednesday 0 07 Jul 7 +0000 RFC2822 Wed, 31 Jul 1974 15:03:27 +0000 27 31 144515007 3 74 1974 211 0 2003" (adodb_date len=167)

Error getdate() 144515007
Array ( [seconds] => 27 [minutes] => 3 [hours] => 16 [mday] => 31 [wday] => 3 [mon] => 7 [year] => 1974 [yday] => 211 [weekday] => Wednesday [month] => July [0] => 144515007 )
Array ( [seconds] => 27 [minutes] => 3 [hours] => 15 [mday] => 31 [wday] => 3 [mon] => 7 [year] => 1974 [yday] => 211 [weekday] => Wednesday [month] => July [0] => 144515007 )

7:27:50 am AM 13 Tue September 7 7 07 07 27 13 Tuesday 0 09 Sep 9 +0100 RFC2822 Tue, 13 Sep 1977 07:27:50 +0100 50 30 242980070 2 77 1977 255 3600 2003 Error date(): 242980070

  "date +01 1977-09-13 07:27:50 am AM 13 Tue September 7 7 07 07 27 13 Tuesday 0 09 Sep 9 +0100 RFC2822 Tue, 13 Sep 1977 07:27:50 +0100 50 30 242980070 2 77 1977 255 3600 2003" (date len=172)
  "date +01 1977-09-13 06:27:50 am AM 13 Tue September 6 6 06 06 27 13 Tuesday 0 09 Sep 9 +0000 RFC2822 Tue, 13 Sep 1977 06:27:50 +0000 50 30 242980070 2 77 1977 255 0 2003" (adodb_date len=169)

Error getdate() 242980070
Array ( [seconds] => 50 [minutes] => 27 [hours] => 7 [mday] => 13 [wday] => 2 [mon] => 9 [year] => 1977 [yday] => 255 [weekday] => Tuesday [month] => September [0] => 242980070 )
Array ( [seconds] => 50 [minutes] => 27 [hours] => 6 [mday] => 13 [wday] => 2 [mon] => 9 [year] => 1977 [yday] => 255 [weekday] => Tuesday [month] => September [0] => 242980070 )

3:42:09 pm PM 16 Wed June 1 13 01 13 42 16 Wednesday 1 06 Jun 6 +0100 RFC2822 Wed, 16 Jun 1976 13:42:09 +0100 09 30 203776929 3 76 1976 167 3600 2003 Error date(): 203776929

  "date +01 1976-06-16 13:42:09 pm PM 16 Wed June 1 13 01 13 42 16 Wednesday 1 06 Jun 6 +0100 RFC2822 Wed, 16 Jun 1976 13:42:09 +0100 09 30 203776929 3 76 1976 167 3600 2003" (date len=170)
  "date +01 1976-06-16 12:42:09 pm PM 16 Wed June 12 12 12 12 42 16 Wednesday 1 06 Jun 6 +0000 RFC2822 Wed, 16 Jun 1976 12:42:09 +0000 09 30 203776929 3 76 1976 167 0 2003" (adodb_date len=168)

Error getdate() 203776929
Array ( [seconds] => 9 [minutes] => 42 [hours] => 13 [mday] => 16 [wday] => 3 [mon] => 6 [year] => 1976 [yday] => 167 [weekday] => Wednesday [month] => June [0] => 203776929 )
Array ( [seconds] => 9 [minutes] => 42 [hours] => 12 [mday] => 16 [wday] => 3 [mon] => 6 [year] => 1976 [yday] => 167 [weekday] => Wednesday [month] => June [0] => 203776929 )

20:26:23 pm PM 17 Sat September 8 20 08 20 26 17 Saturday 0 09 Sep 9 +0100 RFC2822 Sat, 17 Sep 1977 20:26:23 +0100 23 30 243372383 6 77 1977 259 3600 2003 Error date(): 243372383

  "date +01 1977-09-17 20:26:23 pm PM 17 Sat September 8 20 08 20 26 17 Saturday 0 09 Sep 9 +0100 RFC2822 Sat, 17 Sep 1977 20:26:23 +0100 23 30 243372383 6 77 1977 259 3600 2003" (date len=174)
  "date +01 1977-09-17 19:26:23 pm PM 17 Sat September 7 19 07 19 26 17 Saturday 0 09 Sep 9 +0000 RFC2822 Sat, 17 Sep 1977 19:26:23 +0000 23 30 243372383 6 77 1977 259 0 2003" (adodb_date len=171)

Error getdate() 243372383
Array ( [seconds] => 23 [minutes] => 26 [hours] => 20 [mday] => 17 [wday] => 6 [mon] => 9 [year] => 1977 [yday] => 259 [weekday] => Saturday [month] => September [0] => 243372383 )
Array ( [seconds] => 23 [minutes] => 26 [hours] => 19 [mday] => 17 [wday] => 6 [mon] => 9 [year] => 1977 [yday] => 259 [weekday] => Saturday [month] => September [0] => 243372383 )

1:49:54 am AM 09 Wed June 1 1 01 01 49 9 Wednesday 1 06 Jun 6 +0100 RFC2822 Wed, 09 Jun 1976 01:49:54 +0100 54 30 203129394 3 76 1976 160 3600 2003 Error date(): 203129394

  "date +01 1976-06-09 01:49:54 am AM 09 Wed June 1 1 01 01 49 9 Wednesday 1 06 Jun 6 +0100 RFC2822 Wed, 09 Jun 1976 01:49:54 +0100 54 30 203129394 3 76 1976 160 3600 2003" (date len=168)
  "date +01 1976-06-09 00:49:54 am AM 09 Wed June 12 0 12 00 49 9 Wednesday 1 06 Jun 6 +0000 RFC2822 Wed, 09 Jun 1976 00:49:54 +0000 54 30 203129394 3 76 1976 160 0 2003" (adodb_date len=166)

Error getdate() 203129394
Array ( [seconds] => 54 [minutes] => 49 [hours] => 1 [mday] => 9 [wday] => 3 [mon] => 6 [year] => 1976 [yday] => 160 [weekday] => Wednesday [month] => June [0] => 203129394 )
Array ( [seconds] => 54 [minutes] => 49 [hours] => 0 [mday] => 9 [wday] => 3 [mon] => 6 [year] => 1976 [yday] => 160 [weekday] => Wednesday [month] => June [0] => 203129394 )

20:38:31 pm PM 19 Thu May 8 20 08 20 38 19 Thursday 0 05 May 5 +0100 RFC2822 Thu, 19 May 1977 20:38:31 +0100 31 31 232918711 4 77 1977 138 3600 2003 Error date(): 232918711

  "date +01 1977-05-19 20:38:31 pm PM 19 Thu May 8 20 08 20 38 19 Thursday 0 05 May 5 +0100 RFC2822 Thu, 19 May 1977 20:38:31 +0100 31 31 232918711 4 77 1977 138 3600 2003" (date len=168)
  "date +01 1977-05-19 19:38:31 pm PM 19 Thu May 7 19 07 19 38 19 Thursday 0 05 May 5 +0000 RFC2822 Thu, 19 May 1977 19:38:31 +0000 31 31 232918711 4 77 1977 138 0 2003" (adodb_date len=165)

Error getdate() 232918711
Array ( [seconds] => 31 [minutes] => 38 [hours] => 20 [mday] => 19 [wday] => 4 [mon] => 5 [year] => 1977 [yday] => 138 [weekday] => Thursday [month] => May [0] => 232918711 )
Array ( [seconds] => 31 [minutes] => 38 [hours] => 19 [mday] => 19 [wday] => 4 [mon] => 5 [year] => 1977 [yday] => 138 [weekday] => Thursday [month] => May [0] => 232918711 )

9:08:29 pm PM 04 Sun August 7 19 07 19 08 4 Sunday 0 08 Aug 8 +0100 RFC2822 Sun, 04 Aug 1974 19:08:29 +0100 29 31 144871709 0 74 1974 215 3600 2003 Error date(): 144871709

  "date +01 1974-08-04 19:08:29 pm PM 04 Sun August 7 19 07 19 08 4 Sunday 0 08 Aug 8 +0100 RFC2822 Sun, 04 Aug 1974 19:08:29 +0100 29 31 144871709 0 74 1974 215 3600 2003" (date len=168)
  "date +01 1974-08-04 18:08:29 pm PM 04 Sun August 6 18 06 18 08 4 Sunday 0 08 Aug 8 +0000 RFC2822 Sun, 04 Aug 1974 18:08:29 +0000 29 31 144871709 0 74 1974 215 0 2003" (adodb_date len=165)

Error getdate() 144871709
Array ( [seconds] => 29 [minutes] => 8 [hours] => 19 [mday] => 4 [wday] => 0 [mon] => 8 [year] => 1974 [yday] => 215 [weekday] => Sunday [month] => August [0] => 144871709 )
Array ( [seconds] => 29 [minutes] => 8 [hours] => 18 [mday] => 4 [wday] => 0 [mon] => 8 [year] => 1974 [yday] => 215 [weekday] => Sunday [month] => August [0] => 144871709 )

9:04:33 pm PM 14 Sat May 7 19 07 19 04 14 Saturday 0 05 May 5 +0100 RFC2822 Sat, 14 May 1977 19:04:33 +0100 33 31 232481073 6 77 1977 133 3600 2003 Error date(): 232481073

  "date +01 1977-05-14 19:04:33 pm PM 14 Sat May 7 19 07 19 04 14 Saturday 0 05 May 5 +0100 RFC2822 Sat, 14 May 1977 19:04:33 +0100 33 31 232481073 6 77 1977 133 3600 2003" (date len=168)
  "date +01 1977-05-14 18:04:33 pm PM 14 Sat May 6 18 06 18 04 14 Saturday 0 05 May 5 +0000 RFC2822 Sat, 14 May 1977 18:04:33 +0000 33 31 232481073 6 77 1977 133 0 2003" (adodb_date len=165)

Error getdate() 232481073
Array ( [seconds] => 33 [minutes] => 4 [hours] => 19 [mday] => 14 [wday] => 6 [mon] => 5 [year] => 1977 [yday] => 133 [weekday] => Saturday [month] => May [0] => 232481073 )
Array ( [seconds] => 33 [minutes] => 4 [hours] => 18 [mday] => 14 [wday] => 6 [mon] => 5 [year] => 1977 [yday] => 133 [weekday] => Saturday [month] => May [0] => 232481073 )

Testing random dates between 100 and 4000

Testing 1967 to 1979, or 378432000 seconds, offset=89724: 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 Tested 4218 dates

Failed :-(

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