-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.3.13

adodb: 2025-08-06 22:37:34
php  : 2025-08-06 23:37:34
error for %Y %m %x %X, strftime=2025 08 08/06/25 23:37:34, adodb=2025 08 08/06/25 22:37:34
error for %H %M S, strftime=23 37 S, adodb=22 37 S

Testing gregorian <=> julian conversion

-12219386400 -12219300000 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

9:22:08 pm PM 10 Mon September 7 19 07 19 22 10 Monday 0 09 Sep 9 +0300 RFC2822 Mon, 10 Sep 1979 19:22:08 +0300 08 30 305828528 1 79 1979 252 10800 2003 Error date(): 305828528
 
  "date EEST 1979-09-10 19:22:08 pm PM 10 Mon September 7 19 07 19 22 10 Monday 0 09 Sep 9 +0300 RFC2822 Mon, 10 Sep 1979 19:22:08 +0300 08 30 305828528 1 79 1979 252 10800 2003" (date len=174)
  "date EEST 1979-09-10 18:22:08 pm PM 10 Mon September 6 18 06 18 22 10 Monday 0 09 Sep 9 +0200 RFC2822 Mon, 10 Sep 1979 18:22:08 +0200 08 30 305828528 1 79 1979 252 7200 2003" (adodb_date len=173)

Error getdate() 305828528
Array ( [seconds] => 8 [minutes] => 22 [hours] => 19 [mday] => 10 [wday] => 1 [mon] => 9 [year] => 1979 [yday] => 252 [weekday] => Monday [month] => September [0] => 305828528 )
Array ( [seconds] => 8 [minutes] => 22 [hours] => 18 [mday] => 10 [wday] => 1 [mon] => 9 [year] => 1979 [yday] => 252 [weekday] => Monday [month] => September [0] => 305828528 )

5:15:11 pm PM 03 Fri August 3 15 03 15 15 3 Friday 0 08 Aug 8 +0300 RFC2822 Fri, 03 Aug 1979 15:15:11 +0300 11 31 302530511 5 79 1979 214 10800 2003 Error date(): 302530511

 
  "date EEST 1979-08-03 15:15:11 pm PM 03 Fri August 3 15 03 15 15 3 Friday 0 08 Aug 8 +0300 RFC2822 Fri, 03 Aug 1979 15:15:11 +0300 11 31 302530511 5 79 1979 214 10800 2003" (date len=170)
  "date EEST 1979-08-03 14:15:11 pm PM 03 Fri August 2 14 02 14 15 3 Friday 0 08 Aug 8 +0200 RFC2822 Fri, 03 Aug 1979 14:15:11 +0200 11 31 302530511 5 79 1979 214 7200 2003" (adodb_date len=169)

1:21:37 pm PM 11 Wed July 9 21 09 21 21 11 Wednesday 0 07 Jul 7 +0300 RFC2822 Wed, 11 Jul 1979 21:21:37 +0300 37 31 300565297 3 79 1979 191 10800 2003 Error date(): 300565297
 
  "date EEST 1979-07-11 21:21:37 pm PM 11 Wed July 9 21 09 21 21 11 Wednesday 0 07 Jul 7 +0300 RFC2822 Wed, 11 Jul 1979 21:21:37 +0300 37 31 300565297 3 79 1979 191 10800 2003" (date len=172)
  "date EEST 1979-07-11 20:21:37 pm PM 11 Wed July 8 20 08 20 21 11 Wednesday 0 07 Jul 7 +0200 RFC2822 Wed, 11 Jul 1979 20:21:37 +0200 37 31 300565297 3 79 1979 191 7200 2003" (adodb_date len=171)

3:57:55 pm PM 25 Fri April 11 23 11 23 57 25 Friday 1 04 Apr 4 +0300 RFC2822 Fri, 25 Apr 1980 23:57:55 +0300 55 30 325544275 5 80 1980 115 10800 2003 Error date(): 325544275
 
  "date EEST 1980-04-25 23:57:55 pm PM 25 Fri April 11 23 11 23 57 25 Friday 1 04 Apr 4 +0300 RFC2822 Fri, 25 Apr 1980 23:57:55 +0300 55 30 325544275 5 80 1980 115 10800 2003" (date len=171)
  "date EEST 1980-04-25 22:57:55 pm PM 25 Fri April 10 22 10 22 57 25 Friday 1 04 Apr 4 +0200 RFC2822 Fri, 25 Apr 1980 22:57:55 +0200 55 30 325544275 5 80 1980 115 7200 2003" (adodb_date len=170)

Error getdate() 325544275
Array ( [seconds] => 55 [minutes] => 57 [hours] => 23 [mday] => 25 [wday] => 5 [mon] => 4 [year] => 1980 [yday] => 115 [weekday] => Friday [month] => April [0] => 325544275 )
Array ( [seconds] => 55 [minutes] => 57 [hours] => 22 [mday] => 25 [wday] => 5 [mon] => 4 [year] => 1980 [yday] => 115 [weekday] => Friday [month] => April [0] => 325544275 )

5:36:56 pm PM 26 Sat May 3 15 03 15 36 26 Saturday 0 05 May 5 +0300 RFC2822 Sat, 26 May 1979 15:36:56 +0300 56 31 296570216 6 79 1979 145 10800 2003 Error date(): 296570216

 
  "date EEST 1979-05-26 15:36:56 pm PM 26 Sat May 3 15 03 15 36 26 Saturday 0 05 May 5 +0300 RFC2822 Sat, 26 May 1979 15:36:56 +0300 56 31 296570216 6 79 1979 145 10800 2003" (date len=170)
  "date EEST 1979-05-26 14:36:56 pm PM 26 Sat May 2 14 02 14 36 26 Saturday 0 05 May 5 +0200 RFC2822 Sat, 26 May 1979 14:36:56 +0200 56 31 296570216 6 79 1979 145 7200 2003" (adodb_date len=169)

Error getdate() 296570216
Array ( [seconds] => 56 [minutes] => 36 [hours] => 15 [mday] => 26 [wday] => 6 [mon] => 5 [year] => 1979 [yday] => 145 [weekday] => Saturday [month] => May [0] => 296570216 )
Array ( [seconds] => 56 [minutes] => 36 [hours] => 14 [mday] => 26 [wday] => 6 [mon] => 5 [year] => 1979 [yday] => 145 [weekday] => Saturday [month] => May [0] => 296570216 )

10:55:42 am AM 20 Fri June 10 10 10 10 55 20 Friday 1 06 Jun 6 +0300 RFC2822 Fri, 20 Jun 1980 10:55:42 +0300 42 30 330335742 5 80 1980 171 10800 2003 Error date(): 330335742

 
  "date EEST 1980-06-20 10:55:42 am AM 20 Fri June 10 10 10 10 55 20 Friday 1 06 Jun 6 +0300 RFC2822 Fri, 20 Jun 1980 10:55:42 +0300 42 30 330335742 5 80 1980 171 10800 2003" (date len=170)
  "date EEST 1980-06-20 09:55:42 am AM 20 Fri June 9 9 09 09 55 20 Friday 1 06 Jun 6 +0200 RFC2822 Fri, 20 Jun 1980 09:55:42 +0200 42 30 330335742 5 80 1980 171 7200 2003" (adodb_date len=167)

Error getdate() 330335742
Array ( [seconds] => 42 [minutes] => 55 [hours] => 10 [mday] => 20 [wday] => 5 [mon] => 6 [year] => 1980 [yday] => 171 [weekday] => Friday [month] => June [0] => 330335742 )
Array ( [seconds] => 42 [minutes] => 55 [hours] => 9 [mday] => 20 [wday] => 5 [mon] => 6 [year] => 1980 [yday] => 171 [weekday] => Friday [month] => June [0] => 330335742 )

4:00:29 pm PM 29 Fri June 2 14 02 14 00 29 Friday 0 06 Jun 6 +0300 RFC2822 Fri, 29 Jun 1979 14:00:29 +0300 29 30 299502029 5 79 1979 179 10800 2003 Error date(): 299502029

 
  "date EEST 1979-06-29 14:00:29 pm PM 29 Fri June 2 14 02 14 00 29 Friday 0 06 Jun 6 +0300 RFC2822 Fri, 29 Jun 1979 14:00:29 +0300 29 30 299502029 5 79 1979 179 10800 2003" (date len=169)
  "date EEST 1979-06-29 13:00:29 pm PM 29 Fri June 1 13 01 13 00 29 Friday 0 06 Jun 6 +0200 RFC2822 Fri, 29 Jun 1979 13:00:29 +0200 29 30 299502029 5 79 1979 179 7200 2003" (adodb_date len=168)

Error getdate() 299502029
Array ( [seconds] => 29 [minutes] => 0 [hours] => 14 [mday] => 29 [wday] => 5 [mon] => 6 [year] => 1979 [yday] => 179 [weekday] => Friday [month] => June [0] => 299502029 )
Array ( [seconds] => 29 [minutes] => 0 [hours] => 13 [mday] => 29 [wday] => 5 [mon] => 6 [year] => 1979 [yday] => 179 [weekday] => Friday [month] => June [0] => 299502029 )

7:12:16 am AM 16 Mon July 7 7 07 07 12 16 Monday 0 07 Jul 7 +0300 RFC2822 Mon, 16 Jul 1979 07:12:16 +0300 16 31 300946336 1 79 1979 196 10800 2003 Error date(): 300946336

 
  "date EEST 1979-07-16 07:12:16 am AM 16 Mon July 7 7 07 07 12 16 Monday 0 07 Jul 7 +0300 RFC2822 Mon, 16 Jul 1979 07:12:16 +0300 16 31 300946336 1 79 1979 196 10800 2003" (date len=168)
  "date EEST 1979-07-16 06:12:16 am AM 16 Mon July 6 6 06 06 12 16 Monday 0 07 Jul 7 +0200 RFC2822 Mon, 16 Jul 1979 06:12:16 +0200 16 31 300946336 1 79 1979 196 7200 2003" (adodb_date len=167)

8:27:59 am AM 15 Thu July 8 8 08 08 27 15 Thursday 0 07 Jul 7 +0300 RFC2822 Thu, 15 Jul 1982 08:27:59 +0300 59 31 395558879 4 82 1982 195 10800 2003 Error date(): 395558879
 
  "date EEST 1982-07-15 08:27:59 am AM 15 Thu July 8 8 08 08 27 15 Thursday 0 07 Jul 7 +0300 RFC2822 Thu, 15 Jul 1982 08:27:59 +0300 59 31 395558879 4 82 1982 195 10800 2003" (date len=170)
  "date EEST 1982-07-15 07:27:59 am AM 15 Thu July 7 7 07 07 27 15 Thursday 0 07 Jul 7 +0200 RFC2822 Thu, 15 Jul 1982 07:27:59 +0200 59 31 395558879 4 82 1982 195 7200 2003" (adodb_date len=169)

Error getdate() 395558879
Array ( [seconds] => 59 [minutes] => 27 [hours] => 8 [mday] => 15 [wday] => 4 [mon] => 7 [year] => 1982 [yday] => 195 [weekday] => Thursday [month] => July [0] => 395558879 )
Array ( [seconds] => 59 [minutes] => 27 [hours] => 7 [mday] => 15 [wday] => 4 [mon] => 7 [year] => 1982 [yday] => 195 [weekday] => Thursday [month] => July [0] => 395558879 )

9 00:34:19 am AM 19 Thu July 12 0 12 00 34 19 Thursday 0 07 Jul 7 +0300 RFC2822 Thu, 19 Jul 1979 00:34:19 +0300 19 31 301181659 4 79 1979 199 10800 2003 Error date(): 301181659

 
  "date EEST 1979-07-19 00:34:19 am AM 19 Thu July 12 0 12 00 34 19 Thursday 0 07 Jul 7 +0300 RFC2822 Thu, 19 Jul 1979 00:34:19 +0300 19 31 301181659 4 79 1979 199 10800 2003" (date len=171)
  "date EEST 1979-07-18 23:34:19 pm PM 18 Wed July 11 23 11 23 34 18 Wednesday 0 07 Jul 7 +0200 RFC2822 Wed, 18 Jul 1979 23:34:19 +0200 19 31 301181659 3 79 1979 198 7200 2003" (adodb_date len=172)

Error getdate() 301181659
Array ( [seconds] => 19 [minutes] => 34 [hours] => 0 [mday] => 19 [wday] => 4 [mon] => 7 [year] => 1979 [yday] => 199 [weekday] => Thursday [month] => July [0] => 301181659 )
Array ( [seconds] => 19 [minutes] => 34 [hours] => 23 [mday] => 18 [wday] => 3 [mon] => 7 [year] => 1979 [yday] => 198 [weekday] => Wednesday [month] => July [0] => 301181659 )

2:04:05 pm PM 28 Wed April 10 22 10 22 04 28 Wednesday 0 04 Apr 4 +0300 RFC2822 Wed, 28 Apr 1982 22:04:05 +0300 05 30 388868645 3 82 1982 117 10800 2003 Error date(): 388868645

 
  "date EEST 1982-04-28 22:04:05 pm PM 28 Wed April 10 22 10 22 04 28 Wednesday 0 04 Apr 4 +0300 RFC2822 Wed, 28 Apr 1982 22:04:05 +0300 05 30 388868645 3 82 1982 117 10800 2003" (date len=174)
  "date EEST 1982-04-28 21:04:05 pm PM 28 Wed April 9 21 09 21 04 28 Wednesday 0 04 Apr 4 +0200 RFC2822 Wed, 28 Apr 1982 21:04:05 +0200 05 30 388868645 3 82 1982 117 7200 2003" (adodb_date len=172)

Error getdate() 388868645
Array ( [seconds] => 5 [minutes] => 4 [hours] => 22 [mday] => 28 [wday] => 3 [mon] => 4 [year] => 1982 [yday] => 117 [weekday] => Wednesday [month] => April [0] => 388868645 )
Array ( [seconds] => 5 [minutes] => 4 [hours] => 21 [mday] => 28 [wday] => 3 [mon] => 4 [year] => 1982 [yday] => 117 [weekday] => Wednesday [month] => April [0] => 388868645 )

3:26:57 am AM 28 Mon May 3 3 03 03 26 28 Monday 0 05 May 5 +0300 RFC2822 Mon, 28 May 1979 03:26:57 +0300 57 31 296699217 1 79 1979 147 10800 2003 Error date(): 296699217

 
  "date EEST 1979-05-28 03:26:57 am AM 28 Mon May 3 3 03 03 26 28 Monday 0 05 May 5 +0300 RFC2822 Mon, 28 May 1979 03:26:57 +0300 57 31 296699217 1 79 1979 147 10800 2003" (date len=167)
  "date EEST 1979-05-28 02:26:57 am AM 28 Mon May 2 2 02 02 26 28 Monday 0 05 May 5 +0200 RFC2822 Mon, 28 May 1979 02:26:57 +0200 57 31 296699217 1 79 1979 147 7200 2003" (adodb_date len=166)

Error getdate() 296699217
Array ( [seconds] => 57 [minutes] => 26 [hours] => 3 [mday] => 28 [wday] => 1 [mon] => 5 [year] => 1979 [yday] => 147 [weekday] => Monday [month] => May [0] => 296699217 )
Array ( [seconds] => 57 [minutes] => 26 [hours] => 2 [mday] => 28 [wday] => 1 [mon] => 5 [year] => 1979 [yday] => 147 [weekday] => Monday [month] => May [0] => 296699217 )

Testing random dates between 100 and 4000

Testing 1962 to 1974, or 378432000 seconds, offset=68367: 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 Tested 5536 dates

Failed :-(

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