-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-03-17 12:17:07
php  : 2025-03-17 11:17:07
error for %Y %m %x %X, strftime=2025 03 03/17/25 11:17:07, adodb=2025 03 03/17/25 12:17:07
error for %H %M S, strftime=11 17 S, adodb=12 17 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:26:07 am AM 24 Mon July 5 5 05 05 26 24 Monday 0 07 Jul 7 +0100 RFC2822 Mon, 24 Jul 1978 05:26:07 +0100 07 31 270102367 1 78 1978 204 3600 2003 Error date(): 270102367
  "date +01 1978-07-24 05:26:07 am AM 24 Mon July 5 5 05 05 26 24 Monday 0 07 Jul 7 +0100 RFC2822 Mon, 24 Jul 1978 05:26:07 +0100 07 31 270102367 1 78 1978 204 3600 2003" (date len=166)
  "date +01 1978-07-24 04:26:07 am AM 24 Mon July 4 4 04 04 26 24 Monday 0 07 Jul 7 +0000 RFC2822 Mon, 24 Jul 1978 04:26:07 +0000 07 31 270102367 1 78 1978 204 0 2003" (adodb_date len=163)

Error getdate() 270102367
Array ( [seconds] => 7 [minutes] => 26 [hours] => 5 [mday] => 24 [wday] => 1 [mon] => 7 [year] => 1978 [yday] => 204 [weekday] => Monday [month] => July [0] => 270102367 )
Array ( [seconds] => 7 [minutes] => 26 [hours] => 4 [mday] => 24 [wday] => 1 [mon] => 7 [year] => 1978 [yday] => 204 [weekday] => Monday [month] => July [0] => 270102367 )

3:40:04 pm PM 22 Thu August 11 23 11 23 40 22 Thursday 0 08 Aug 8 +0100 RFC2822 Thu, 22 Aug 1974 23:40:04 +0100 04 31 146443204 4 74 1974 233 3600 2003 Error date(): 146443204

  "date +01 1974-08-22 23:40:04 pm PM 22 Thu August 11 23 11 23 40 22 Thursday 0 08 Aug 8 +0100 RFC2822 Thu, 22 Aug 1974 23:40:04 +0100 04 31 146443204 4 74 1974 233 3600 2003" (date len=172)
  "date +01 1974-08-22 22:40:04 pm PM 22 Thu August 10 22 10 22 40 22 Thursday 0 08 Aug 8 +0000 RFC2822 Thu, 22 Aug 1974 22:40:04 +0000 04 31 146443204 4 74 1974 233 0 2003" (adodb_date len=169)

Error getdate() 146443204
Array ( [seconds] => 4 [minutes] => 40 [hours] => 23 [mday] => 22 [wday] => 4 [mon] => 8 [year] => 1974 [yday] => 233 [weekday] => Thursday [month] => August [0] => 146443204 )
Array ( [seconds] => 4 [minutes] => 40 [hours] => 22 [mday] => 22 [wday] => 4 [mon] => 8 [year] => 1974 [yday] => 233 [weekday] => Thursday [month] => August [0] => 146443204 )

20:56:03 pm PM 19 Tue July 8 20 08 20 56 19 Tuesday 0 07 Jul 7 +0100 RFC2822 Tue, 19 Jul 1977 20:56:03 +0100 03 31 238190163 2 77 1977 199 3600 2003 Error date(): 238190163

  "date +01 1977-07-19 20:56:03 pm PM 19 Tue July 8 20 08 20 56 19 Tuesday 0 07 Jul 7 +0100 RFC2822 Tue, 19 Jul 1977 20:56:03 +0100 03 31 238190163 2 77 1977 199 3600 2003" (date len=168)
  "date +01 1977-07-19 19:56:03 pm PM 19 Tue July 7 19 07 19 56 19 Tuesday 0 07 Jul 7 +0000 RFC2822 Tue, 19 Jul 1977 19:56:03 +0000 03 31 238190163 2 77 1977 199 0 2003" (adodb_date len=165)

Error getdate() 238190163
Array ( [seconds] => 3 [minutes] => 56 [hours] => 20 [mday] => 19 [wday] => 2 [mon] => 7 [year] => 1977 [yday] => 199 [weekday] => Tuesday [month] => July [0] => 238190163 )
Array ( [seconds] => 3 [minutes] => 56 [hours] => 19 [mday] => 19 [wday] => 2 [mon] => 7 [year] => 1977 [yday] => 199 [weekday] => Tuesday [month] => July [0] => 238190163 )

5:57:30 am AM 19 Tue July 5 5 05 05 57 19 Tuesday 0 07 Jul 7 +0100 RFC2822 Tue, 19 Jul 1977 05:57:30 +0100 30 31 238136250 2 77 1977 199 3600 2003 Error date(): 238136250

  "date +01 1977-07-19 05:57:30 am AM 19 Tue July 5 5 05 05 57 19 Tuesday 0 07 Jul 7 +0100 RFC2822 Tue, 19 Jul 1977 05:57:30 +0100 30 31 238136250 2 77 1977 199 3600 2003" (date len=167)
  "date +01 1977-07-19 04:57:30 am AM 19 Tue July 4 4 04 04 57 19 Tuesday 0 07 Jul 7 +0000 RFC2822 Tue, 19 Jul 1977 04:57:30 +0000 30 31 238136250 2 77 1977 199 0 2003" (adodb_date len=164)

Error getdate() 238136250
Array ( [seconds] => 30 [minutes] => 57 [hours] => 5 [mday] => 19 [wday] => 2 [mon] => 7 [year] => 1977 [yday] => 199 [weekday] => Tuesday [month] => July [0] => 238136250 )
Array ( [seconds] => 30 [minutes] => 57 [hours] => 4 [mday] => 19 [wday] => 2 [mon] => 7 [year] => 1977 [yday] => 199 [weekday] => Tuesday [month] => July [0] => 238136250 )

4:33:46 am AM 01 Thu September 4 4 04 04 33 1 Thursday 0 09 Sep 9 +0100 RFC2822 Thu, 01 Sep 1977 04:33:46 +0100 46 30 241932826 4 77 1977 243 3600 2003 Error date(): 241932826

  "date +01 1977-09-01 04:33:46 am AM 01 Thu September 4 4 04 04 33 1 Thursday 0 09 Sep 9 +0100 RFC2822 Thu, 01 Sep 1977 04:33:46 +0100 46 30 241932826 4 77 1977 243 3600 2003" (date len=172)
  "date +01 1977-09-01 03:33:46 am AM 01 Thu September 3 3 03 03 33 1 Thursday 0 09 Sep 9 +0000 RFC2822 Thu, 01 Sep 1977 03:33:46 +0000 46 30 241932826 4 77 1977 243 0 2003" (adodb_date len=169)

9:32:30 am AM 26 Wed June 9 9 09 09 32 26 Wednesday 0 06 Jun 6 +0100 RFC2822 Wed, 26 Jun 1974 09:32:30 +0100 30 30 141467550 3 74 1974 176 3600 2003 Error date(): 141467550
  "date +01 1974-06-26 09:32:30 am AM 26 Wed June 9 9 09 09 32 26 Wednesday 0 06 Jun 6 +0100 RFC2822 Wed, 26 Jun 1974 09:32:30 +0100 30 30 141467550 3 74 1974 176 3600 2003" (date len=169)
  "date +01 1974-06-26 08:32:30 am AM 26 Wed June 8 8 08 08 32 26 Wednesday 0 06 Jun 6 +0000 RFC2822 Wed, 26 Jun 1974 08:32:30 +0000 30 30 141467550 3 74 1974 176 0 2003" (adodb_date len=166)

Error getdate() 141467550
Array ( [seconds] => 30 [minutes] => 32 [hours] => 9 [mday] => 26 [wday] => 3 [mon] => 6 [year] => 1974 [yday] => 176 [weekday] => Wednesday [month] => June [0] => 141467550 )
Array ( [seconds] => 30 [minutes] => 32 [hours] => 8 [mday] => 26 [wday] => 3 [mon] => 6 [year] => 1974 [yday] => 176 [weekday] => Wednesday [month] => June [0] => 141467550 )

1:19:52 pm PM 04 Sat June 9 21 09 21 19 4 Saturday 0 06 Jun 6 +0100 RFC2822 Sat, 04 Jun 1977 21:19:52 +0100 52 30 234303592 6 77 1977 154 3600 2003 Error date(): 234303592

  "date +01 1977-06-04 21:19:52 pm PM 04 Sat June 9 21 09 21 19 4 Saturday 0 06 Jun 6 +0100 RFC2822 Sat, 04 Jun 1977 21:19:52 +0100 52 30 234303592 6 77 1977 154 3600 2003" (date len=168)
  "date +01 1977-06-04 20:19:52 pm PM 04 Sat June 8 20 08 20 19 4 Saturday 0 06 Jun 6 +0000 RFC2822 Sat, 04 Jun 1977 20:19:52 +0000 52 30 234303592 6 77 1977 154 0 2003" (adodb_date len=165)

Error getdate() 234303592
Array ( [seconds] => 52 [minutes] => 19 [hours] => 21 [mday] => 4 [wday] => 6 [mon] => 6 [year] => 1977 [yday] => 154 [weekday] => Saturday [month] => June [0] => 234303592 )
Array ( [seconds] => 52 [minutes] => 19 [hours] => 20 [mday] => 4 [wday] => 6 [mon] => 6 [year] => 1977 [yday] => 154 [weekday] => Saturday [month] => June [0] => 234303592 )

5:44:58 pm PM 22 Thu July 3 15 03 15 44 22 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 22 Jul 1976 15:44:58 +0100 58 31 206894698 4 76 1976 203 3600 2003 Error date(): 206894698

  "date +01 1976-07-22 15:44:58 pm PM 22 Thu July 3 15 03 15 44 22 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 22 Jul 1976 15:44:58 +0100 58 31 206894698 4 76 1976 203 3600 2003" (date len=169)
  "date +01 1976-07-22 14:44:58 pm PM 22 Thu July 2 14 02 14 44 22 Thursday 1 07 Jul 7 +0000 RFC2822 Thu, 22 Jul 1976 14:44:58 +0000 58 31 206894698 4 76 1976 203 0 2003" (adodb_date len=166)

Error getdate() 206894698
Array ( [seconds] => 58 [minutes] => 44 [hours] => 15 [mday] => 22 [wday] => 4 [mon] => 7 [year] => 1976 [yday] => 203 [weekday] => Thursday [month] => July [0] => 206894698 )
Array ( [seconds] => 58 [minutes] => 44 [hours] => 14 [mday] => 22 [wday] => 4 [mon] => 7 [year] => 1976 [yday] => 203 [weekday] => Thursday [month] => July [0] => 206894698 )

1:47:51 pm PM 17 Sat September 9 21 09 21 47 17 Saturday 0 09 Sep 9 +0100 RFC2822 Sat, 17 Sep 1977 21:47:51 +0100 51 30 243377271 6 77 1977 259 3600 2003 Error date(): 243377271

  "date +01 1977-09-17 21:47:51 pm PM 17 Sat September 9 21 09 21 47 17 Saturday 0 09 Sep 9 +0100 RFC2822 Sat, 17 Sep 1977 21:47:51 +0100 51 30 243377271 6 77 1977 259 3600 2003" (date len=174)
  "date +01 1977-09-17 20:47:51 pm PM 17 Sat September 8 20 08 20 47 17 Saturday 0 09 Sep 9 +0000 RFC2822 Sat, 17 Sep 1977 20:47:51 +0000 51 30 243377271 6 77 1977 259 0 2003" (adodb_date len=171)

Error getdate() 243377271
Array ( [seconds] => 51 [minutes] => 47 [hours] => 21 [mday] => 17 [wday] => 6 [mon] => 9 [year] => 1977 [yday] => 259 [weekday] => Saturday [month] => September [0] => 243377271 )
Array ( [seconds] => 51 [minutes] => 47 [hours] => 20 [mday] => 17 [wday] => 6 [mon] => 9 [year] => 1977 [yday] => 259 [weekday] => Saturday [month] => September [0] => 243377271 )

Testing random dates between 100 and 4000

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

Failed :-(

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