-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-08-28 04:28:19
php  : 2025-08-28 05:28:19
error for %Y %m %x %X, strftime=2025 08 08/28/25 05:28:19, adodb=2025 08 08/28/25 04:28:19
error for %H %M S, strftime=05 28 S, adodb=04 28 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:42:28 am AM 20 Fri May 5 5 05 05 42 20 Friday 0 05 May 5 +0100 RFC2822 Fri, 20 May 1977 05:42:28 +0100 28 31 232951348 5 77 1977 139 3600 2003 Error date(): 232951348
  "date +01 1977-05-20 05:42:28 am AM 20 Fri May 5 5 05 05 42 20 Friday 0 05 May 5 +0100 RFC2822 Fri, 20 May 1977 05:42:28 +0100 28 31 232951348 5 77 1977 139 3600 2003" (date len=165)
  "date +01 1977-05-20 04:42:28 am AM 20 Fri May 4 4 04 04 42 20 Friday 0 05 May 5 +0000 RFC2822 Fri, 20 May 1977 04:42:28 +0000 28 31 232951348 5 77 1977 139 0 2003" (adodb_date len=162)

9:02:55 am AM 30 Thu June 9 9 09 09 02 30 Thursday 0 06 Jun 6 +0100 RFC2822 Thu, 30 Jun 1977 09:02:55 +0100 55 30 236505775 4 77 1977 180 3600 2003 Error date(): 236505775
  "date +01 1977-06-30 09:02:55 am AM 30 Thu June 9 9 09 09 02 30 Thursday 0 06 Jun 6 +0100 RFC2822 Thu, 30 Jun 1977 09:02:55 +0100 55 30 236505775 4 77 1977 180 3600 2003" (date len=168)
  "date +01 1977-06-30 08:02:55 am AM 30 Thu June 8 8 08 08 02 30 Thursday 0 06 Jun 6 +0000 RFC2822 Thu, 30 Jun 1977 08:02:55 +0000 55 30 236505775 4 77 1977 180 0 2003" (adodb_date len=165)

Error getdate() 236505775
Array ( [seconds] => 55 [minutes] => 2 [hours] => 9 [mday] => 30 [wday] => 4 [mon] => 6 [year] => 1977 [yday] => 180 [weekday] => Thursday [month] => June [0] => 236505775 )
Array ( [seconds] => 55 [minutes] => 2 [hours] => 8 [mday] => 30 [wday] => 4 [mon] => 6 [year] => 1977 [yday] => 180 [weekday] => Thursday [month] => June [0] => 236505775 )

2:54:00 pm PM 26 Wed July 10 22 10 22 54 26 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 26 Jul 1978 22:54:00 +0100 00 31 270338040 3 78 1978 206 3600 2003 Error date(): 270338040

  "date +01 1978-07-26 22:54:00 pm PM 26 Wed July 10 22 10 22 54 26 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 26 Jul 1978 22:54:00 +0100 00 31 270338040 3 78 1978 206 3600 2003" (date len=171)
  "date +01 1978-07-26 21:54:00 pm PM 26 Wed July 9 21 09 21 54 26 Wednesday 0 07 Jul 7 +0000 RFC2822 Wed, 26 Jul 1978 21:54:00 +0000 00 31 270338040 3 78 1978 206 0 2003" (adodb_date len=167)

Error getdate() 270338040
Array ( [seconds] => 0 [minutes] => 54 [hours] => 22 [mday] => 26 [wday] => 3 [mon] => 7 [year] => 1978 [yday] => 206 [weekday] => Wednesday [month] => July [0] => 270338040 )
Array ( [seconds] => 0 [minutes] => 54 [hours] => 21 [mday] => 26 [wday] => 3 [mon] => 7 [year] => 1978 [yday] => 206 [weekday] => Wednesday [month] => July [0] => 270338040 )

20:01:05 pm PM 13 Sun June 8 20 08 20 01 13 Sunday 1 06 Jun 6 +0100 RFC2822 Sun, 13 Jun 1976 20:01:05 +0100 05 30 203540465 0 76 1976 164 3600 2003 Error date(): 203540465

  "date +01 1976-06-13 20:01:05 pm PM 13 Sun June 8 20 08 20 01 13 Sunday 1 06 Jun 6 +0100 RFC2822 Sun, 13 Jun 1976 20:01:05 +0100 05 30 203540465 0 76 1976 164 3600 2003" (date len=167)
  "date +01 1976-06-13 19:01:05 pm PM 13 Sun June 7 19 07 19 01 13 Sunday 1 06 Jun 6 +0000 RFC2822 Sun, 13 Jun 1976 19:01:05 +0000 05 30 203540465 0 76 1976 164 0 2003" (adodb_date len=164)

Error getdate() 203540465
Array ( [seconds] => 5 [minutes] => 1 [hours] => 20 [mday] => 13 [wday] => 0 [mon] => 6 [year] => 1976 [yday] => 164 [weekday] => Sunday [month] => June [0] => 203540465 )
Array ( [seconds] => 5 [minutes] => 1 [hours] => 19 [mday] => 13 [wday] => 0 [mon] => 6 [year] => 1976 [yday] => 164 [weekday] => Sunday [month] => June [0] => 203540465 )

2:25:20 am AM 12 Fri August 2 2 02 02 25 12 Friday 0 08 Aug 8 +0100 RFC2822 Fri, 12 Aug 1977 02:25:20 +0100 20 31 240197120 5 77 1977 223 3600 2003 Error date(): 240197120

  "date +01 1977-08-12 02:25:20 am AM 12 Fri August 2 2 02 02 25 12 Friday 0 08 Aug 8 +0100 RFC2822 Fri, 12 Aug 1977 02:25:20 +0100 20 31 240197120 5 77 1977 223 3600 2003" (date len=168)
  "date +01 1977-08-12 01:25:20 am AM 12 Fri August 1 1 01 01 25 12 Friday 0 08 Aug 8 +0000 RFC2822 Fri, 12 Aug 1977 01:25:20 +0000 20 31 240197120 5 77 1977 223 0 2003" (adodb_date len=165)

Error getdate() 240197120
Array ( [seconds] => 20 [minutes] => 25 [hours] => 2 [mday] => 12 [wday] => 5 [mon] => 8 [year] => 1977 [yday] => 223 [weekday] => Friday [month] => August [0] => 240197120 )
Array ( [seconds] => 20 [minutes] => 25 [hours] => 1 [mday] => 12 [wday] => 5 [mon] => 8 [year] => 1977 [yday] => 223 [weekday] => Friday [month] => August [0] => 240197120 )

7:13:28 am AM 10 Wed July 7 7 07 07 13 10 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 10 Jul 1974 07:13:28 +0100 28 31 142668808 3 74 1974 190 3600 2003 Error date(): 142668808

  "date +01 1974-07-10 07:13:28 am AM 10 Wed July 7 7 07 07 13 10 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 10 Jul 1974 07:13:28 +0100 28 31 142668808 3 74 1974 190 3600 2003" (date len=169)
  "date +01 1974-07-10 06:13:28 am AM 10 Wed July 6 6 06 06 13 10 Wednesday 0 07 Jul 7 +0000 RFC2822 Wed, 10 Jul 1974 06:13:28 +0000 28 31 142668808 3 74 1974 190 0 2003" (adodb_date len=166)

8:22:16 pm PM 17 Sun July 6 18 06 18 22 17 Sunday 0 07 Jul 7 +0100 RFC2822 Sun, 17 Jul 1977 18:22:16 +0100 16 31 238008136 0 77 1977 197 3600 2003 Error date(): 238008136
  "date +01 1977-07-17 18:22:16 pm PM 17 Sun July 6 18 06 18 22 17 Sunday 0 07 Jul 7 +0100 RFC2822 Sun, 17 Jul 1977 18:22:16 +0100 16 31 238008136 0 77 1977 197 3600 2003" (date len=167)
  "date +01 1977-07-17 17:22:16 pm PM 17 Sun July 5 17 05 17 22 17 Sunday 0 07 Jul 7 +0000 RFC2822 Sun, 17 Jul 1977 17:22:16 +0000 16 31 238008136 0 77 1977 197 0 2003" (adodb_date len=164)

Error getdate() 238008136
Array ( [seconds] => 16 [minutes] => 22 [hours] => 18 [mday] => 17 [wday] => 0 [mon] => 7 [year] => 1977 [yday] => 197 [weekday] => Sunday [month] => July [0] => 238008136 )
Array ( [seconds] => 16 [minutes] => 22 [hours] => 17 [mday] => 17 [wday] => 0 [mon] => 7 [year] => 1977 [yday] => 197 [weekday] => Sunday [month] => July [0] => 238008136 )

9:08:32 am AM 01 Thu July 9 9 09 09 08 1 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 01 Jul 1976 09:08:32 +0100 32 31 205056512 4 76 1976 182 3600 2003 Error date(): 205056512

  "date +01 1976-07-01 09:08:32 am AM 01 Thu July 9 9 09 09 08 1 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 01 Jul 1976 09:08:32 +0100 32 31 205056512 4 76 1976 182 3600 2003" (date len=167)
  "date +01 1976-07-01 08:08:32 am AM 01 Thu July 8 8 08 08 08 1 Thursday 1 07 Jul 7 +0000 RFC2822 Thu, 01 Jul 1976 08:08:32 +0000 32 31 205056512 4 76 1976 182 0 2003" (adodb_date len=164)

Error getdate() 205056512
Array ( [seconds] => 32 [minutes] => 8 [hours] => 9 [mday] => 1 [wday] => 4 [mon] => 7 [year] => 1976 [yday] => 182 [weekday] => Thursday [month] => July [0] => 205056512 )
Array ( [seconds] => 32 [minutes] => 8 [hours] => 8 [mday] => 1 [wday] => 4 [mon] => 7 [year] => 1976 [yday] => 182 [weekday] => Thursday [month] => July [0] => 205056512 )

9:29:09 am AM 31 Mon May 9 9 09 09 29 31 Monday 1 05 May 5 +0100 RFC2822 Mon, 31 May 1976 09:29:09 +0100 09 31 202379349 1 76 1976 151 3600 2003 Error date(): 202379349

  "date +01 1976-05-31 09:29:09 am AM 31 Mon May 9 9 09 09 29 31 Monday 1 05 May 5 +0100 RFC2822 Mon, 31 May 1976 09:29:09 +0100 09 31 202379349 1 76 1976 151 3600 2003" (date len=165)
  "date +01 1976-05-31 08:29:09 am AM 31 Mon May 8 8 08 08 29 31 Monday 1 05 May 5 +0000 RFC2822 Mon, 31 May 1976 08:29:09 +0000 09 31 202379349 1 76 1976 151 0 2003" (adodb_date len=162)

5:58:03 am AM 13 Sun June 5 5 05 05 58 13 Sunday 1 06 Jun 6 +0100 RFC2822 Sun, 13 Jun 1976 05:58:03 +0100 03 30 203489883 0 76 1976 164 3600 2003 Error date(): 203489883
  "date +01 1976-06-13 05:58:03 am AM 13 Sun June 5 5 05 05 58 13 Sunday 1 06 Jun 6 +0100 RFC2822 Sun, 13 Jun 1976 05:58:03 +0100 03 30 203489883 0 76 1976 164 3600 2003" (date len=166)
  "date +01 1976-06-13 04:58:03 am AM 13 Sun June 4 4 04 04 58 13 Sunday 1 06 Jun 6 +0000 RFC2822 Sun, 13 Jun 1976 04:58:03 +0000 03 30 203489883 0 76 1976 164 0 2003" (adodb_date len=163)

Error getdate() 203489883
Array ( [seconds] => 3 [minutes] => 58 [hours] => 5 [mday] => 13 [wday] => 0 [mon] => 6 [year] => 1976 [yday] => 164 [weekday] => Sunday [month] => June [0] => 203489883 )
Array ( [seconds] => 3 [minutes] => 58 [hours] => 4 [mday] => 13 [wday] => 0 [mon] => 6 [year] => 1976 [yday] => 164 [weekday] => Sunday [month] => June [0] => 203489883 )

4:14:21 pm PM 12 Mon September 2 14 02 14 14 12 Monday 0 09 Sep 9 +0100 RFC2822 Mon, 12 Sep 1977 14:14:21 +0100 21 30 242918061 1 77 1977 254 3600 2003 Error date(): 242918061

  "date +01 1977-09-12 14:14:21 pm PM 12 Mon September 2 14 02 14 14 12 Monday 0 09 Sep 9 +0100 RFC2822 Mon, 12 Sep 1977 14:14:21 +0100 21 30 242918061 1 77 1977 254 3600 2003" (date len=172)
  "date +01 1977-09-12 13:14:21 pm PM 12 Mon September 1 13 01 13 14 12 Monday 0 09 Sep 9 +0000 RFC2822 Mon, 12 Sep 1977 13:14:21 +0000 21 30 242918061 1 77 1977 254 0 2003" (adodb_date len=169)

2:37:41 pm PM 24 Mon June 10 22 10 22 37 24 Monday 0 06 Jun 6 +0100 RFC2822 Mon, 24 Jun 1974 22:37:41 +0100 41 30 141341861 1 74 1974 174 3600 2003 Error date(): 141341861
  "date +01 1974-06-24 22:37:41 pm PM 24 Mon June 10 22 10 22 37 24 Monday 0 06 Jun 6 +0100 RFC2822 Mon, 24 Jun 1974 22:37:41 +0100 41 30 141341861 1 74 1974 174 3600 2003" (date len=168)
  "date +01 1974-06-24 21:37:41 pm PM 24 Mon June 9 21 09 21 37 24 Monday 0 06 Jun 6 +0000 RFC2822 Mon, 24 Jun 1974 21:37:41 +0000 41 30 141341861 1 74 1974 174 0 2003" (adodb_date len=164)

Error getdate() 141341861
Array ( [seconds] => 41 [minutes] => 37 [hours] => 22 [mday] => 24 [wday] => 1 [mon] => 6 [year] => 1974 [yday] => 174 [weekday] => Monday [month] => June [0] => 141341861 )
Array ( [seconds] => 41 [minutes] => 37 [hours] => 21 [mday] => 24 [wday] => 1 [mon] => 6 [year] => 1974 [yday] => 174 [weekday] => Monday [month] => June [0] => 141341861 )

4:32:23 am AM 22 Thu July 4 4 04 04 32 22 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 22 Jul 1976 04:32:23 +0100 23 31 206854343 4 76 1976 203 3600 2003 Error date(): 206854343

  "date +01 1976-07-22 04:32:23 am AM 22 Thu July 4 4 04 04 32 22 Thursday 1 07 Jul 7 +0100 RFC2822 Thu, 22 Jul 1976 04:32:23 +0100 23 31 206854343 4 76 1976 203 3600 2003" (date len=168)
  "date +01 1976-07-22 03:32:23 am AM 22 Thu July 3 3 03 03 32 22 Thursday 1 07 Jul 7 +0000 RFC2822 Thu, 22 Jul 1976 03:32:23 +0000 23 31 206854343 4 76 1976 203 0 2003" (adodb_date len=165)

2:54:45 am AM 08 Thu August 2 2 02 02 54 8 Thursday 0 08 Aug 8 +0100 RFC2822 Thu, 08 Aug 1974 02:54:45 +0100 45 31 145158885 4 74 1974 219 3600 2003 Error date(): 145158885
  "date +01 1974-08-08 02:54:45 am AM 08 Thu August 2 2 02 02 54 8 Thursday 0 08 Aug 8 +0100 RFC2822 Thu, 08 Aug 1974 02:54:45 +0100 45 31 145158885 4 74 1974 219 3600 2003" (date len=169)
  "date +01 1974-08-08 01:54:45 am AM 08 Thu August 1 1 01 01 54 8 Thursday 0 08 Aug 8 +0000 RFC2822 Thu, 08 Aug 1974 01:54:45 +0000 45 31 145158885 4 74 1974 219 0 2003" (adodb_date len=166)

Error getdate() 145158885
Array ( [seconds] => 45 [minutes] => 54 [hours] => 2 [mday] => 8 [wday] => 4 [mon] => 8 [year] => 1974 [yday] => 219 [weekday] => Thursday [month] => August [0] => 145158885 )
Array ( [seconds] => 45 [minutes] => 54 [hours] => 1 [mday] => 8 [wday] => 4 [mon] => 8 [year] => 1974 [yday] => 219 [weekday] => Thursday [month] => August [0] => 145158885 )

8:35:21 am AM 06 Wed July 8 8 08 08 35 6 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 06 Jul 1977 08:35:21 +0100 21 31 237022521 3 77 1977 186 3600 2003 Error date(): 237022521

  "date +01 1977-07-06 08:35:21 am AM 06 Wed July 8 8 08 08 35 6 Wednesday 0 07 Jul 7 +0100 RFC2822 Wed, 06 Jul 1977 08:35:21 +0100 21 31 237022521 3 77 1977 186 3600 2003" (date len=168)
  "date +01 1977-07-06 07:35:21 am AM 06 Wed July 7 7 07 07 35 6 Wednesday 0 07 Jul 7 +0000 RFC2822 Wed, 06 Jul 1977 07:35:21 +0000 21 31 237022521 3 77 1977 186 0 2003" (adodb_date len=165)

Error getdate() 237022521
Array ( [seconds] => 21 [minutes] => 35 [hours] => 8 [mday] => 6 [wday] => 3 [mon] => 7 [year] => 1977 [yday] => 186 [weekday] => Wednesday [month] => July [0] => 237022521 )
Array ( [seconds] => 21 [minutes] => 35 [hours] => 7 [mday] => 6 [wday] => 3 [mon] => 7 [year] => 1977 [yday] => 186 [weekday] => Wednesday [month] => July [0] => 237022521 )

7:32:08 pm PM 30 Sun June 5 17 05 17 32 30 Sunday 0 06 Jun 6 +0100 RFC2822 Sun, 30 Jun 1974 17:32:08 +0100 08 30 141841928 0 74 1974 180 3600 2003 Error date(): 141841928

  "date +01 1974-06-30 17:32:08 pm PM 30 Sun June 5 17 05 17 32 30 Sunday 0 06 Jun 6 +0100 RFC2822 Sun, 30 Jun 1974 17:32:08 +0100 08 30 141841928 0 74 1974 180 3600 2003" (date len=167)
  "date +01 1974-06-30 16:32:08 pm PM 30 Sun June 4 16 04 16 32 30 Sunday 0 06 Jun 6 +0000 RFC2822 Sun, 30 Jun 1974 16:32:08 +0000 08 30 141841928 0 74 1974 180 0 2003" (adodb_date len=164)

Error getdate() 141841928
Array ( [seconds] => 8 [minutes] => 32 [hours] => 17 [mday] => 30 [wday] => 0 [mon] => 6 [year] => 1974 [yday] => 180 [weekday] => Sunday [month] => June [0] => 141841928 )
Array ( [seconds] => 8 [minutes] => 32 [hours] => 16 [mday] => 30 [wday] => 0 [mon] => 6 [year] => 1974 [yday] => 180 [weekday] => Sunday [month] => June [0] => 141841928 )

Testing random dates between 100 and 4000

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

Failed :-(

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