ADODB Test

This script tests the following databases: Interbase, Oracle, Visual FoxPro, Microsoft Access (ODBC and ADO), MySQL, MSSQL (ODBC, native, ADO). There is also support for Sybase, PostgreSQL.

For the latest version of ADODB, visit php.weblogs.com.

Test GetInsertSQL/GetUpdateSQL   Sessions   Paging   Perf Monitor

Access
Interbase
MSSQL
MySQL
MySQL ODBC
SQLite
MySQL Proxy
Oracle (oci8)
PostgreSQL
PostgreSQL ODBC
DB2
VFP
ADO (for mssql and access)
$ADODB_COUNTRECS=false
No SQL Logging

Connecting mysql...

ERROR: MySQL test requires a MySQL server on localhost, userid='admin', password='', database='test'
Access denied for user 'root'@'localhost' (using password: NO)

Tests Completed

Testing adodb_date and adodb_mktime. version=0.12

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

Testing date formating

date() 0 failed
date CET 1970-01-01 01:00:00 am AM 01 Thu January 1 1 01 01 00 1 Thursday 0 01 Jan 1 +0100 RFC822 Thu, 01 Jan 1970 01:00:00 +0100 00 31 0 4 70 1970 0 3600 2003
date CET 1970-01-01 01:00:00 am AM 01 Thu January 1 1 01 01 00 1 Thursday 0 01 Jan 1 +0100 RFC822 Thu, 1 Jan 1970 01:00:00 +0100 00 31 0 4 70 1970 0 3600 2003
09 Jun 1978 08:39:43 +0100 43 30 266225983 5 78 1978 159 3600 2003 Error date(): 266225983
 
  "date CET 1978-06-09 08:39:43 am AM 09 Fri June 8 8 08 08 39 9 Friday 0 06 Jun 6 +0100 RFC822 Fri, 09 Jun 1978 08:39:43 +0100 43 30 266225983 5 78 1978 159 3600 2003" (date len=164)
  "date CET 1978-06-09 08:39:43 am AM 09 Fri June 8 8 08 08 39 9 Friday 0 06 Jun 6 +0100 RFC822 Fri,  9 Jun 1978 08:39:43 +0100 43 30 266225983 5 78 1978 159 3600 2003" (adodb_date len=164)

07 Nov 1971 00:04:08 +0100 08 30 58316648 0 71 1971 310 3600 2003 Error date(): 58316648
 
  "date CET 1971-11-07 00:04:08 am AM 07 Sun November 12 0 12 00 04 7 Sunday 0 11 Nov 11 +0100 RFC822 Sun, 07 Nov 1971 00:04:08 +0100 08 30 58316648 0 71 1971 310 3600 2003" (date len=169)
  "date CET 1971-11-07 00:04:08 am AM 07 Sun November 12 0 12 00 04 7 Sunday 0 11 Nov 11 +0100 RFC822 Sun,  7 Nov 1971 00:04:08 +0100 08 30 58316648 0 71 1971 310 3600 2003" (adodb_date len=169)

04 Jan 1976 19:06:24 +0100 24 31 189626784 0 76 1976 3 3600 2003 Error date(): 189626784
 
  "date CET 1976-01-04 19:06:24 pm PM 04 Sun January 7 19 07 19 06 4 Sunday 1 01 Jan 1 +0100 RFC822 Sun, 04 Jan 1976 19:06:24 +0100 24 31 189626784 0 76 1976 3 3600 2003" (date len=166)
  "date CET 1976-01-04 19:06:24 pm PM 04 Sun January 7 19 07 19 06 4 Sunday 1 01 Jan 1 +0100 RFC822 Sun,  4 Jan 1976 19:06:24 +0100 24 31 189626784 0 76 1976 3 3600 2003" (adodb_date len=166)

04 Aug 1974 01:19:27 +0100 27 31 144807567 0 74 1974 215 3600 2003 Error date(): 144807567
 
  "date CET 1974-08-04 01:19:27 am AM 04 Sun August 1 1 01 01 19 4 Sunday 0 08 Aug 8 +0100 RFC822 Sun, 04 Aug 1974 01:19:27 +0100 27 31 144807567 0 74 1974 215 3600 2003" (date len=166)
  "date CET 1974-08-04 01:19:27 am AM 04 Sun August 1 1 01 01 19 4 Sunday 0 08 Aug 8 +0100 RFC822 Sun,  4 Aug 1974 01:19:27 +0100 27 31 144807567 0 74 1974 215 3600 2003" (adodb_date len=166)

ST 1982-04-15 18:30:58 pm PM 15 Thu April 6 18 06 18 30 15 Thursday 0 04 Apr 4 +0200 RFC822 Thu, 15 Apr 1982 18:30:58 +0200 58 30 387736258 4 82 1982 104 7200 2003 Error date(): 387736258
 
  "date CEST 1982-04-15 18:30:58 pm PM 15 Thu April 6 18 06 18 30 15 Thursday 0 04 Apr 4 +0200 RFC822 Thu, 15 Apr 1982 18:30:58 +0200 58 30 387736258 4 82 1982 104 7200 2003" (date len=170)
  "date CET 1982-04-15 17:30:58 pm PM 15 Thu April 5 17 05 17 30 15 Thursday 0 04 Apr 4 +0100 RFC822 Thu, 15 Apr 1982 17:30:58 +0100 58 30 387736258 4 82 1982 104 3600 2003" (adodb_date len=169)

Error getdate() 387736258
Array ( [seconds] => 58 [minutes] => 30 [hours] => 18 [mday] => 15 [wday] => 4 [mon] => 4 [year] => 1982 [yday] => 104 [weekday] => Thursday [month] => April [0] => 387736258 )
Array ( [seconds] => 58 [minutes] => 30 [hours] => 17 [mday] => 15 [wday] => 4 [mon] => 4 [year] => 1982 [yday] => 104 [weekday] => Thursday [month] => April [0] => 387736258 )

04 Apr 1974 06:08:31 +0100 31 30 134284111 4 74 1974 93 3600 2003 Error date(): 134284111

 
  "date CET 1974-04-04 06:08:31 am AM 04 Thu April 6 6 06 06 08 4 Thursday 0 04 Apr 4 +0100 RFC822 Thu, 04 Apr 1974 06:08:31 +0100 31 30 134284111 4 74 1974 93 3600 2003" (date len=166)
  "date CET 1974-04-04 06:08:31 am AM 04 Thu April 6 6 06 06 08 4 Thursday 0 04 Apr 4 +0100 RFC822 Thu,  4 Apr 1974 06:08:31 +0100 31 30 134284111 4 74 1974 93 3600 2003" (adodb_date len=166)

01 Mar 1976 12:18:37 +0100 37 31 194527117 1 76 1976 60 3600 2003 Error date(): 194527117
 
  "date CET 1976-03-01 12:18:37 pm PM 01 Mon March 12 12 12 12 18 1 Monday 1 03 Mar 3 +0100 RFC822 Mon, 01 Mar 1976 12:18:37 +0100 37 31 194527117 1 76 1976 60 3600 2003" (date len=166)
  "date CET 1976-03-01 12:18:37 pm PM 01 Mon March 12 12 12 12 18 1 Monday 1 03 Mar 3 +0100 RFC822 Mon,  1 Mar 1976 12:18:37 +0100 37 31 194527117 1 76 1976 60 3600 2003" (adodb_date len=166)

08 Jun 1975 01:41:17 +0100 17 30 171420077 0 75 1975 158 3600 2003 Error date(): 171420077
 
  "date CET 1975-06-08 01:41:17 am AM 08 Sun June 1 1 01 01 41 8 Sunday 0 06 Jun 6 +0100 RFC822 Sun, 08 Jun 1975 01:41:17 +0100 17 30 171420077 0 75 1975 158 3600 2003" (date len=164)
  "date CET 1975-06-08 01:41:17 am AM 08 Sun June 1 1 01 01 41 8 Sunday 0 06 Jun 6 +0100 RFC822 Sun,  8 Jun 1975 01:41:17 +0100 17 30 171420077 0 75 1975 158 3600 2003" (adodb_date len=164)

02 Mar 1978 10:19:43 +0100 43 31 257678383 4 78 1978 60 3600 2003 Error date(): 257678383
 
  "date CET 1978-03-02 10:19:43 am AM 02 Thu March 10 10 10 10 19 2 Thursday 0 03 Mar 3 +0100 RFC822 Thu, 02 Mar 1978 10:19:43 +0100 43 31 257678383 4 78 1978 60 3600 2003" (date len=168)
  "date CET 1978-03-02 10:19:43 am AM 02 Thu March 10 10 10 10 19 2 Thursday 0 03 Mar 3 +0100 RFC822 Thu,  2 Mar 1978 10:19:43 +0100 43 31 257678383 4 78 1978 60 3600 2003" (adodb_date len=168)

06 Oct 1974 07:07:57 +0100 57 31 150271677 0 74 1974 278 3600 2003 Error date(): 150271677
 
  "date CET 1974-10-06 07:07:57 am AM 06 Sun October 7 7 07 07 07 6 Sunday 0 10 Oct 10 +0100 RFC822 Sun, 06 Oct 1974 07:07:57 +0100 57 31 150271677 0 74 1974 278 3600 2003" (date len=168)
  "date CET 1974-10-06 07:07:57 am AM 06 Sun October 7 7 07 07 07 6 Sunday 0 10 Oct 10 +0100 RFC822 Sun,  6 Oct 1974 07:07:57 +0100 57 31 150271677 0 74 1974 278 3600 2003" (adodb_date len=168)

03 Oct 1972 21:15:04 +0100 04 31 86991304 2 72 1972 276 3600 2003 Error date(): 86991304
 
  "date CET 1972-10-03 21:15:04 pm PM 03 Tue October 9 21 09 21 15 3 Tuesday 1 10 Oct 10 +0100 RFC822 Tue, 03 Oct 1972 21:15:04 +0100 04 31 86991304 2 72 1972 276 3600 2003" (date len=169)
  "date CET 1972-10-03 21:15:04 pm PM 03 Tue October 9 21 09 21 15 3 Tuesday 1 10 Oct 10 +0100 RFC822 Tue,  3 Oct 1972 21:15:04 +0100 04 31 86991304 2 72 1972 276 3600 2003" (adodb_date len=169)

07 Jul 1978 22:15:43 +0100 43 31 268694143 5 78 1978 187 3600 2003 Error date(): 268694143
 
  "date CET 1978-07-07 22:15:43 pm PM 07 Fri July 10 22 10 22 15 7 Friday 0 07 Jul 7 +0100 RFC822 Fri, 07 Jul 1978 22:15:43 +0100 43 31 268694143 5 78 1978 187 3600 2003" (date len=166)
  "date CET 1978-07-07 22:15:43 pm PM 07 Fri July 10 22 10 22 15 7 Friday 0 07 Jul 7 +0100 RFC822 Fri,  7 Jul 1978 22:15:43 +0100 43 31 268694143 5 78 1978 187 3600 2003" (adodb_date len=166)

09 Mar 1974 14:47:16 +0100 16 31 132068836 6 74 1974 67 3600 2003 Error date(): 132068836
 
  "date CET 1974-03-09 14:47:16 pm PM 09 Sat March 2 14 02 14 47 9 Saturday 0 03 Mar 3 +0100 RFC822 Sat, 09 Mar 1974 14:47:16 +0100 16 31 132068836 6 74 1974 67 3600 2003" (date len=167)
  "date CET 1974-03-09 14:47:16 pm PM 09 Sat March 2 14 02 14 47 9 Saturday 0 03 Mar 3 +0100 RFC822 Sat,  9 Mar 1974 14:47:16 +0100 16 31 132068836 6 74 1974 67 3600 2003" (adodb_date len=167)

03 May 1977 09:18:46 +0100 46 31 231495526 2 77 1977 122 3600 2003 Error date(): 231495526
 
  "date CET 1977-05-03 09:18:46 am AM 03 Tue May 9 9 09 09 18 3 Tuesday 0 05 May 5 +0100 RFC822 Tue, 03 May 1977 09:18:46 +0100 46 31 231495526 2 77 1977 122 3600 2003" (date len=164)
  "date CET 1977-05-03 09:18:46 am AM 03 Tue May 9 9 09 09 18 3 Tuesday 0 05 May 5 +0100 RFC822 Tue,  3 May 1977 09:18:46 +0100 46 31 231495526 2 77 1977 122 3600 2003" (adodb_date len=164)

07 Jul 1976 22:12:52 +0100 52 31 205621972 3 76 1976 188 3600 2003 Error date(): 205621972
 
  "date CET 1976-07-07 22:12:52 pm PM 07 Wed July 10 22 10 22 12 7 Wednesday 1 07 Jul 7 +0100 RFC822 Wed, 07 Jul 1976 22:12:52 +0100 52 31 205621972 3 76 1976 188 3600 2003" (date len=169)
  "date CET 1976-07-07 22:12:52 pm PM 07 Wed July 10 22 10 22 12 7 Wednesday 1 07 Jul 7 +0100 RFC822 Wed,  7 Jul 1976 22:12:52 +0100 52 31 205621972 3 76 1976 188 3600 2003" (adodb_date len=169)

04 Nov 1977 12:29:14 +0100 14 30 247490954 5 77 1977 307 3600 2003 Error date(): 247490954
 
  "date CET 1977-11-04 12:29:14 pm PM 04 Fri November 12 12 12 12 29 4 Friday 0 11 Nov 11 +0100 RFC822 Fri, 04 Nov 1977 12:29:14 +0100 14 30 247490954 5 77 1977 307 3600 2003" (date len=171)
  "date CET 1977-11-04 12:29:14 pm PM 04 Fri November 12 12 12 12 29 4 Friday 0 11 Nov 11 +0100 RFC822 Fri,  4 Nov 1977 12:29:14 +0100 14 30 247490954 5 77 1977 307 3600 2003" (adodb_date len=171)

06 Feb 1975 09:35:31 +0100 31 28 160907731 4 75 1975 36 3600 2003 Error date(): 160907731
 
  "date CET 1975-02-06 09:35:31 am AM 06 Thu February 9 9 09 09 35 6 Thursday 0 02 Feb 2 +0100 RFC822 Thu, 06 Feb 1975 09:35:31 +0100 31 28 160907731 4 75 1975 36 3600 2003" (date len=169)
  "date CET 1975-02-06 09:35:31 am AM 06 Thu February 9 9 09 09 35 6 Thursday 0 02 Feb 2 +0100 RFC822 Thu,  6 Feb 1975 09:35:31 +0100 31 28 160907731 4 75 1975 36 3600 2003" (adodb_date len=169)

04 Dec 1978 11:42:27 +0100 27 31 281616147 1 78 1978 337 3600 2003 Error date(): 281616147
 
  "date CET 1978-12-04 11:42:27 am AM 04 Mon December 11 11 11 11 42 4 Monday 0 12 Dec 12 +0100 RFC822 Mon, 04 Dec 1978 11:42:27 +0100 27 31 281616147 1 78 1978 337 3600 2003" (date len=171)
  "date CET 1978-12-04 11:42:27 am AM 04 Mon December 11 11 11 11 42 4 Monday 0 12 Dec 12 +0100 RFC822 Mon,  4 Dec 1978 11:42:27 +0100 27 31 281616147 1 78 1978 337 3600 2003" (adodb_date len=171)

09 Mar 1977 23:20:47 +0100 47 31 226794047 3 77 1977 67 3600 2003 Error date(): 226794047
 
  "date CET 1977-03-09 23:20:47 pm PM 09 Wed March 11 23 11 23 20 9 Wednesday 0 03 Mar 3 +0100 RFC822 Wed, 09 Mar 1977 23:20:47 +0100 47 31 226794047 3 77 1977 67 3600 2003" (date len=169)
  "date CET 1977-03-09 23:20:47 pm PM 09 Wed March 11 23 11 23 20 9 Wednesday 0 03 Mar 3 +0100 RFC822 Wed,  9 Mar 1977 23:20:47 +0100 47 31 226794047 3 77 1977 67 3600 2003" (adodb_date len=169)

03 Jun 1978 16:39:22 +0100 22 30 265736362 6 78 1978 153 3600 2003 Error date(): 265736362
 
  "date CET 1978-06-03 16:39:22 pm PM 03 Sat June 4 16 04 16 39 3 Saturday 0 06 Jun 6 +0100 RFC822 Sat, 03 Jun 1978 16:39:22 +0100 22 30 265736362 6 78 1978 153 3600 2003" (date len=167)
  "date CET 1978-06-03 16:39:22 pm PM 03 Sat June 4 16 04 16 39 3 Saturday 0 06 Jun 6 +0100 RFC822 Sat,  3 Jun 1978 16:39:22 +0100 22 30 265736362 6 78 1978 153 3600 2003" (adodb_date len=167)

ST 1980-05-26 06:04:41 am AM 26 Mon May 6 6 06 06 04 26 Monday 1 05 May 5 +0200 RFC822 Mon, 26 May 1980 06:04:41 +0200 41 31 328161881 1 80 1980 146 7200 2003 Error date(): 328161881
 
  "date CEST 1980-05-26 06:04:41 am AM 26 Mon May 6 6 06 06 04 26 Monday 1 05 May 5 +0200 RFC822 Mon, 26 May 1980 06:04:41 +0200 41 31 328161881 1 80 1980 146 7200 2003" (date len=165)
  "date CET 1980-05-26 05:04:41 am AM 26 Mon May 5 5 05 05 04 26 Monday 1 05 May 5 +0100 RFC822 Mon, 26 May 1980 05:04:41 +0100 41 31 328161881 1 80 1980 146 3600 2003" (adodb_date len=164)

Error getdate() 328161881
Array ( [seconds] => 41 [minutes] => 4 [hours] => 6 [mday] => 26 [wday] => 1 [mon] => 5 [year] => 1980 [yday] => 146 [weekday] => Monday [month] => May [0] => 328161881 )
Array ( [seconds] => 41 [minutes] => 4 [hours] => 5 [mday] => 26 [wday] => 1 [mon] => 5 [year] => 1980 [yday] => 146 [weekday] => Monday [month] => May [0] => 328161881 )

ST 1980-08-16 07:43:19 am AM 16 Sat August 7 7 07 07 43 16 Saturday 1 08 Aug 8 +0200 RFC822 Sat, 16 Aug 1980 07:43:19 +0200 19 31 335252599 6 80 1980 228 7200 2003 Error date(): 335252599

 
  "date CEST 1980-08-16 07:43:19 am AM 16 Sat August 7 7 07 07 43 16 Saturday 1 08 Aug 8 +0200 RFC822 Sat, 16 Aug 1980 07:43:19 +0200 19 31 335252599 6 80 1980 228 7200 2003" (date len=170)
  "date CET 1980-08-16 06:43:19 am AM 16 Sat August 6 6 06 06 43 16 Saturday 1 08 Aug 8 +0100 RFC822 Sat, 16 Aug 1980 06:43:19 +0100 19 31 335252599 6 80 1980 228 3600 2003" (adodb_date len=169)

Error getdate() 335252599
Array ( [seconds] => 19 [minutes] => 43 [hours] => 7 [mday] => 16 [wday] => 6 [mon] => 8 [year] => 1980 [yday] => 228 [weekday] => Saturday [month] => August [0] => 335252599 )
Array ( [seconds] => 19 [minutes] => 43 [hours] => 6 [mday] => 16 [wday] => 6 [mon] => 8 [year] => 1980 [yday] => 228 [weekday] => Saturday [month] => August [0] => 335252599 )

09 Jan 1973 20:57:45 +0100 45 31 95457465 2 73 1973 8 3600 2003 Error date(): 95457465

 
  "date CET 1973-01-09 20:57:45 pm PM 09 Tue January 8 20 08 20 57 9 Tuesday 0 01 Jan 1 +0100 RFC822 Tue, 09 Jan 1973 20:57:45 +0100 45 31 95457465 2 73 1973 8 3600 2003" (date len=166)
  "date CET 1973-01-09 20:57:45 pm PM 09 Tue January 8 20 08 20 57 9 Tuesday 0 01 Jan 1 +0100 RFC822 Tue,  9 Jan 1973 20:57:45 +0100 45 31 95457465 2 73 1973 8 3600 2003" (adodb_date len=166)

ST 1980-08-07 08:57:13 am AM 07 Thu August 8 8 08 08 57 7 Thursday 1 08 Aug 8 +0200 RFC822 Thu, 07 Aug 1980 08:57:13 +0200 13 31 334479433 4 80 1980 219 7200 2003 Error date(): 334479433
 
  "date CEST 1980-08-07 08:57:13 am AM 07 Thu August 8 8 08 08 57 7 Thursday 1 08 Aug 8 +0200 RFC822 Thu, 07 Aug 1980 08:57:13 +0200 13 31 334479433 4 80 1980 219 7200 2003" (date len=169)
  "date CET 1980-08-07 07:57:13 am AM 07 Thu August 7 7 07 07 57 7 Thursday 1 08 Aug 8 +0100 RFC822 Thu,  7 Aug 1980 07:57:13 +0100 13 31 334479433 4 80 1980 219 3600 2003" (adodb_date len=168)

07 Feb 1975 18:32:11 +0100 11 28 161026331 5 75 1975 37 3600 2003 Error date(): 161026331
 
  "date CET 1975-02-07 18:32:11 pm PM 07 Fri February 6 18 06 18 32 7 Friday 0 02 Feb 2 +0100 RFC822 Fri, 07 Feb 1975 18:32:11 +0100 11 28 161026331 5 75 1975 37 3600 2003" (date len=168)
  "date CET 1975-02-07 18:32:11 pm PM 07 Fri February 6 18 06 18 32 7 Friday 0 02 Feb 2 +0100 RFC822 Fri,  7 Feb 1975 18:32:11 +0100 11 28 161026331 5 75 1975 37 3600 2003" (adodb_date len=168)

09 Aug 1972 08:24:56 +0100 56 31 82193096 3 72 1972 221 3600 2003 Error date(): 82193096
 
  "date CET 1972-08-09 08:24:56 am AM 09 Wed August 8 8 08 08 24 9 Wednesday 1 08 Aug 8 +0100 RFC822 Wed, 09 Aug 1972 08:24:56 +0100 56 31 82193096 3 72 1972 221 3600 2003" (date len=168)
  "date CET 1972-08-09 08:24:56 am AM 09 Wed August 8 8 08 08 24 9 Wednesday 1 08 Aug 8 +0100 RFC822 Wed,  9 Aug 1972 08:24:56 +0100 56 31 82193096 3 72 1972 221 3600 2003" (adodb_date len=168)

09 Apr 1978 00:29:17 +0100 17 30 260926157 0 78 1978 98 3600 2003 Error date(): 260926157
 
  "date CET 1978-04-09 00:29:17 am AM 09 Sun April 12 0 12 00 29 9 Sunday 0 04 Apr 4 +0100 RFC822 Sun, 09 Apr 1978 00:29:17 +0100 17 30 260926157 0 78 1978 98 3600 2003" (date len=165)
  "date CET 1978-04-09 00:29:17 am AM 09 Sun April 12 0 12 00 29 9 Sunday 0 04 Apr 4 +0100 RFC822 Sun,  9 Apr 1978 00:29:17 +0100 17 30 260926157 0 78 1978 98 3600 2003" (adodb_date len=165)

09 Oct 1971 12:25:47 +0100 47 31 55855547 6 71 1971 281 3600 2003 Error date(): 55855547
 
  "date CET 1971-10-09 12:25:47 pm PM 09 Sat October 12 12 12 12 25 9 Saturday 0 10 Oct 10 +0100 RFC822 Sat, 09 Oct 1971 12:25:47 +0100 47 31 55855547 6 71 1971 281 3600 2003" (date len=171)
  "date CET 1971-10-09 12:25:47 pm PM 09 Sat October 12 12 12 12 25 9 Saturday 0 10 Oct 10 +0100 RFC822 Sat,  9 Oct 1971 12:25:47 +0100 47 31 55855547 6 71 1971 281 3600 2003" (adodb_date len=171)

07 Mar 1974 07:36:47 +0100 47 31 131870207 4 74 1974 65 3600 2003 Error date(): 131870207
 
  "date CET 1974-03-07 07:36:47 am AM 07 Thu March 7 7 07 07 36 7 Thursday 0 03 Mar 3 +0100 RFC822 Thu, 07 Mar 1974 07:36:47 +0100 47 31 131870207 4 74 1974 65 3600 2003" (date len=166)
  "date CET 1974-03-07 07:36:47 am AM 07 Thu March 7 7 07 07 36 7 Thursday 0 03 Mar 3 +0100 RFC822 Thu,  7 Mar 1974 07:36:47 +0100 47 31 131870207 4 74 1974 65 3600 2003" (adodb_date len=166)

01 Mar 1976 13:25:29 +0100 29 31 194531129 1 76 1976 60 3600 2003 Error date(): 194531129
 
  "date CET 1976-03-01 13:25:29 pm PM 01 Mon March 1 13 01 13 25 1 Monday 1 03 Mar 3 +0100 RFC822 Mon, 01 Mar 1976 13:25:29 +0100 29 31 194531129 1 76 1976 60 3600 2003" (date len=165)
  "date CET 1976-03-01 13:25:29 pm PM 01 Mon March 1 13 01 13 25 1 Monday 1 03 Mar 3 +0100 RFC822 Mon,  1 Mar 1976 13:25:29 +0100 29 31 194531129 1 76 1976 60 3600 2003" (adodb_date len=165)

ST 1980-05-22 06:07:11 am AM 22 Thu May 6 6 06 06 07 22 Thursday 1 05 May 5 +0200 RFC822 Thu, 22 May 1980 06:07:11 +0200 11 31 327816431 4 80 1980 142 7200 2003 Error date(): 327816431
 
  "date CEST 1980-05-22 06:07:11 am AM 22 Thu May 6 6 06 06 07 22 Thursday 1 05 May 5 +0200 RFC822 Thu, 22 May 1980 06:07:11 +0200 11 31 327816431 4 80 1980 142 7200 2003" (date len=167)
  "date CET 1980-05-22 05:07:11 am AM 22 Thu May 5 5 05 05 07 22 Thursday 1 05 May 5 +0100 RFC822 Thu, 22 May 1980 05:07:11 +0100 11 31 327816431 4 80 1980 142 3600 2003" (adodb_date len=166)

Error getdate() 327816431
Array ( [seconds] => 11 [minutes] => 7 [hours] => 6 [mday] => 22 [wday] => 4 [mon] => 5 [year] => 1980 [yday] => 142 [weekday] => Thursday [month] => May [0] => 327816431 )
Array ( [seconds] => 11 [minutes] => 7 [hours] => 5 [mday] => 22 [wday] => 4 [mon] => 5 [year] => 1980 [yday] => 142 [weekday] => Thursday [month] => May [0] => 327816431 )

08 Sep 1977 16:03:44 +0100 44 30 242579024 4 77 1977 250 3600 2003 Error date(): 242579024

 
  "date CET 1977-09-08 16:03:44 pm PM 08 Thu September 4 16 04 16 03 8 Thursday 0 09 Sep 9 +0100 RFC822 Thu, 08 Sep 1977 16:03:44 +0100 44 30 242579024 4 77 1977 250 3600 2003" (date len=172)
  "date CET 1977-09-08 16:03:44 pm PM 08 Thu September 4 16 04 16 03 8 Thursday 0 09 Sep 9 +0100 RFC822 Thu,  8 Sep 1977 16:03:44 +0100 44 30 242579024 4 77 1977 250 3600 2003" (adodb_date len=172)

ST 1980-09-15 20:32:44 pm PM 15 Mon September 8 20 08 20 32 15 Monday 1 09 Sep 9 +0200 RFC822 Mon, 15 Sep 1980 20:32:44 +0200 44 30 337890764 1 80 1980 258 7200 2003 Error date(): 337890764
 
  "date CEST 1980-09-15 20:32:44 pm PM 15 Mon September 8 20 08 20 32 15 Monday 1 09 Sep 9 +0200 RFC822 Mon, 15 Sep 1980 20:32:44 +0200 44 30 337890764 1 80 1980 258 7200 2003" (date len=172)
  "date CET 1980-09-15 19:32:44 pm PM 15 Mon September 7 19 07 19 32 15 Monday 1 09 Sep 9 +0100 RFC822 Mon, 15 Sep 1980 19:32:44 +0100 44 30 337890764 1 80 1980 258 3600 2003" (adodb_date len=171)

Error getdate() 337890764
Array ( [seconds] => 44 [minutes] => 32 [hours] => 20 [mday] => 15 [wday] => 1 [mon] => 9 [year] => 1980 [yday] => 258 [weekday] => Monday [month] => September [0] => 337890764 )
Array ( [seconds] => 44 [minutes] => 32 [hours] => 19 [mday] => 15 [wday] => 1 [mon] => 9 [year] => 1980 [yday] => 258 [weekday] => Monday [month] => September [0] => 337890764 )

Testing random dates between 100 and 4000

Testing 1965 to 1977, or 378432000 seconds, offset=68324: 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976

Failed :-(

ADODB Database Library (c) 2000-2004 John Lim. All rights reserved. Released under BSD and LGPL.