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
07 Nov 1980 20:18:07 +0100 07 30 342472687 5 80 1980 311 3600 2003 Error date(): 342472687
 
  "date CET 1980-11-07 20:18:07 pm PM 07 Fri November 8 20 08 20 18 7 Friday 1 11 Nov 11 +0100 RFC822 Fri, 07 Nov 1980 20:18:07 +0100 07 30 342472687 5 80 1980 311 3600 2003" (date len=170)
  "date CET 1980-11-07 20:18:07 pm PM 07 Fri November 8 20 08 20 18 7 Friday 1 11 Nov 11 +0100 RFC822 Fri,  7 Nov 1980 20:18:07 +0100 07 30 342472687 5 80 1980 311 3600 2003" (adodb_date len=170)

ST 1980-05-24 14:14:40 pm PM 24 Sat May 2 14 02 14 14 24 Saturday 1 05 May 5 +0200 RFC822 Sat, 24 May 1980 14:14:40 +0200 40 31 328018480 6 80 1980 144 7200 2003 Error date(): 328018480
 
  "date CEST 1980-05-24 14:14:40 pm PM 24 Sat May 2 14 02 14 14 24 Saturday 1 05 May 5 +0200 RFC822 Sat, 24 May 1980 14:14:40 +0200 40 31 328018480 6 80 1980 144 7200 2003" (date len=168)
  "date CET 1980-05-24 13:14:40 pm PM 24 Sat May 1 13 01 13 14 24 Saturday 1 05 May 5 +0100 RFC822 Sat, 24 May 1980 13:14:40 +0100 40 31 328018480 6 80 1980 144 3600 2003" (adodb_date len=167)

04 May 1979 12:50:18 +0100 18 31 294666618 5 79 1979 123 3600 2003 Error date(): 294666618
 
  "date CET 1979-05-04 12:50:18 pm PM 04 Fri May 12 12 12 12 50 4 Friday 0 05 May 5 +0100 RFC822 Fri, 04 May 1979 12:50:18 +0100 18 31 294666618 5 79 1979 123 3600 2003" (date len=165)
  "date CET 1979-05-04 12:50:18 pm PM 04 Fri May 12 12 12 12 50 4 Friday 0 05 May 5 +0100 RFC822 Fri,  4 May 1979 12:50:18 +0100 18 31 294666618 5 79 1979 123 3600 2003" (adodb_date len=165)

07 Aug 1975 19:45:10 +0100 10 31 176669110 4 75 1975 218 3600 2003 Error date(): 176669110
 
  "date CET 1975-08-07 19:45:10 pm PM 07 Thu August 7 19 07 19 45 7 Thursday 0 08 Aug 8 +0100 RFC822 Thu, 07 Aug 1975 19:45:10 +0100 10 31 176669110 4 75 1975 218 3600 2003" (date len=169)
  "date CET 1975-08-07 19:45:10 pm PM 07 Thu August 7 19 07 19 45 7 Thursday 0 08 Aug 8 +0100 RFC822 Thu,  7 Aug 1975 19:45:10 +0100 10 31 176669110 4 75 1975 218 3600 2003" (adodb_date len=169)

06 Jul 1978 20:35:42 +0100 42 31 268601742 4 78 1978 186 3600 2003 Error date(): 268601742
 
  "date CET 1978-07-06 20:35:42 pm PM 06 Thu July 8 20 08 20 35 6 Thursday 0 07 Jul 7 +0100 RFC822 Thu, 06 Jul 1978 20:35:42 +0100 42 31 268601742 4 78 1978 186 3600 2003" (date len=167)
  "date CET 1978-07-06 20:35:42 pm PM 06 Thu July 8 20 08 20 35 6 Thursday 0 07 Jul 7 +0100 RFC822 Thu,  6 Jul 1978 20:35:42 +0100 42 31 268601742 4 78 1978 186 3600 2003" (adodb_date len=167)

08 May 1976 00:00:12 +0100 12 31 200358012 6 76 1976 128 3600 2003 Error date(): 200358012
 
  "date CET 1976-05-08 00:00:12 am AM 08 Sat May 12 0 12 00 00 8 Saturday 1 05 May 5 +0100 RFC822 Sat, 08 May 1976 00:00:12 +0100 12 31 200358012 6 76 1976 128 3600 2003" (date len=166)
  "date CET 1976-05-08 00:00:12 am AM 08 Sat May 12 0 12 00 00 8 Saturday 1 05 May 5 +0100 RFC822 Sat,  8 May 1976 00:00:12 +0100 12 31 200358012 6 76 1976 128 3600 2003" (adodb_date len=166)

02 Jan 1978 02:07:14 +0100 14 31 252551234 1 78 1978 1 3600 2003 Error date(): 252551234
 
  "date CET 1978-01-02 02:07:14 am AM 02 Mon January 2 2 02 02 07 2 Monday 0 01 Jan 1 +0100 RFC822 Mon, 02 Jan 1978 02:07:14 +0100 14 31 252551234 1 78 1978 1 3600 2003" (date len=165)
  "date CET 1978-01-02 02:07:14 am AM 02 Mon January 2 2 02 02 07 2 Monday 0 01 Jan 1 +0100 RFC822 Mon,  2 Jan 1978 02:07:14 +0100 14 31 252551234 1 78 1978 1 3600 2003" (adodb_date len=165)

ST 1980-07-06 09:43:03 am AM 06 Sun July 9 9 09 09 43 6 Sunday 1 07 Jul 7 +0200 RFC822 Sun, 06 Jul 1980 09:43:03 +0200 03 31 331717383 0 80 1980 187 7200 2003 Error date(): 331717383
 
  "date CEST 1980-07-06 09:43:03 am AM 06 Sun July 9 9 09 09 43 6 Sunday 1 07 Jul 7 +0200 RFC822 Sun, 06 Jul 1980 09:43:03 +0200 03 31 331717383 0 80 1980 187 7200 2003" (date len=165)
  "date CET 1980-07-06 08:43:03 am AM 06 Sun July 8 8 08 08 43 6 Sunday 1 07 Jul 7 +0100 RFC822 Sun,  6 Jul 1980 08:43:03 +0100 03 31 331717383 0 80 1980 187 3600 2003" (adodb_date len=164)

Error getdate() 331717383
Array ( [seconds] => 3 [minutes] => 43 [hours] => 9 [mday] => 6 [wday] => 0 [mon] => 7 [year] => 1980 [yday] => 187 [weekday] => Sunday [month] => July [0] => 331717383 )
Array ( [seconds] => 3 [minutes] => 43 [hours] => 8 [mday] => 6 [wday] => 0 [mon] => 7 [year] => 1980 [yday] => 187 [weekday] => Sunday [month] => July [0] => 331717383 )

ST 1980-05-11 19:49:55 pm PM 11 Sun May 7 19 07 19 49 11 Sunday 1 05 May 5 +0200 RFC822 Sun, 11 May 1980 19:49:55 +0200 55 31 326915395 0 80 1980 131 7200 2003 Error date(): 326915395

 
  "date CEST 1980-05-11 19:49:55 pm PM 11 Sun May 7 19 07 19 49 11 Sunday 1 05 May 5 +0200 RFC822 Sun, 11 May 1980 19:49:55 +0200 55 31 326915395 0 80 1980 131 7200 2003" (date len=166)
  "date CET 1980-05-11 18:49:55 pm PM 11 Sun May 6 18 06 18 49 11 Sunday 1 05 May 5 +0100 RFC822 Sun, 11 May 1980 18:49:55 +0100 55 31 326915395 0 80 1980 131 3600 2003" (adodb_date len=165)

Error getdate() 326915395
Array ( [seconds] => 55 [minutes] => 49 [hours] => 19 [mday] => 11 [wday] => 0 [mon] => 5 [year] => 1980 [yday] => 131 [weekday] => Sunday [month] => May [0] => 326915395 )
Array ( [seconds] => 55 [minutes] => 49 [hours] => 18 [mday] => 11 [wday] => 0 [mon] => 5 [year] => 1980 [yday] => 131 [weekday] => Sunday [month] => May [0] => 326915395 )

03 May 1974 03:20:09 +0100 09 31 136779609 5 74 1974 122 3600 2003 Error date(): 136779609

 
  "date CET 1974-05-03 03:20:09 am AM 03 Fri May 3 3 03 03 20 3 Friday 0 05 May 5 +0100 RFC822 Fri, 03 May 1974 03:20:09 +0100 09 31 136779609 5 74 1974 122 3600 2003" (date len=163)
  "date CET 1974-05-03 03:20:09 am AM 03 Fri May 3 3 03 03 20 3 Friday 0 05 May 5 +0100 RFC822 Fri,  3 May 1974 03:20:09 +0100 09 31 136779609 5 74 1974 122 3600 2003" (adodb_date len=163)

ST 1980-08-21 20:11:26 pm PM 21 Thu August 8 20 08 20 11 21 Thursday 1 08 Aug 8 +0200 RFC822 Thu, 21 Aug 1980 20:11:26 +0200 26 31 335729486 4 80 1980 233 7200 2003 Error date(): 335729486
 
  "date CEST 1980-08-21 20:11:26 pm PM 21 Thu August 8 20 08 20 11 21 Thursday 1 08 Aug 8 +0200 RFC822 Thu, 21 Aug 1980 20:11:26 +0200 26 31 335729486 4 80 1980 233 7200 2003" (date len=171)
  "date CET 1980-08-21 19:11:26 pm PM 21 Thu August 7 19 07 19 11 21 Thursday 1 08 Aug 8 +0100 RFC822 Thu, 21 Aug 1980 19:11:26 +0100 26 31 335729486 4 80 1980 233 3600 2003" (adodb_date len=170)

Error getdate() 335729486
Array ( [seconds] => 26 [minutes] => 11 [hours] => 20 [mday] => 21 [wday] => 4 [mon] => 8 [year] => 1980 [yday] => 233 [weekday] => Thursday [month] => August [0] => 335729486 )
Array ( [seconds] => 26 [minutes] => 11 [hours] => 19 [mday] => 21 [wday] => 4 [mon] => 8 [year] => 1980 [yday] => 233 [weekday] => Thursday [month] => August [0] => 335729486 )

08 Dec 1974 05:11:18 +0100 18 31 155707878 0 74 1974 341 3600 2003 Error date(): 155707878

 
  "date CET 1974-12-08 05:11:18 am AM 08 Sun December 5 5 05 05 11 8 Sunday 0 12 Dec 12 +0100 RFC822 Sun, 08 Dec 1974 05:11:18 +0100 18 31 155707878 0 74 1974 341 3600 2003" (date len=169)
  "date CET 1974-12-08 05:11:18 am AM 08 Sun December 5 5 05 05 11 8 Sunday 0 12 Dec 12 +0100 RFC822 Sun,  8 Dec 1974 05:11:18 +0100 18 31 155707878 0 74 1974 341 3600 2003" (adodb_date len=169)

03 Jul 1974 04:28:26 +0100 26 31 142054106 3 74 1974 183 3600 2003 Error date(): 142054106
 
  "date CET 1974-07-03 04:28:26 am AM 03 Wed July 4 4 04 04 28 3 Wednesday 0 07 Jul 7 +0100 RFC822 Wed, 03 Jul 1974 04:28:26 +0100 26 31 142054106 3 74 1974 183 3600 2003" (date len=167)
  "date CET 1974-07-03 04:28:26 am AM 03 Wed July 4 4 04 04 28 3 Wednesday 0 07 Jul 7 +0100 RFC822 Wed,  3 Jul 1974 04:28:26 +0100 26 31 142054106 3 74 1974 183 3600 2003" (adodb_date len=167)

06 Sep 1977 12:07:10 +0100 10 30 242392030 2 77 1977 248 3600 2003 Error date(): 242392030
 
  "date CET 1977-09-06 12:07:10 pm PM 06 Tue September 12 12 12 12 07 6 Tuesday 0 09 Sep 9 +0100 RFC822 Tue, 06 Sep 1977 12:07:10 +0100 10 30 242392030 2 77 1977 248 3600 2003" (date len=172)
  "date CET 1977-09-06 12:07:10 pm PM 06 Tue September 12 12 12 12 07 6 Tuesday 0 09 Sep 9 +0100 RFC822 Tue,  6 Sep 1977 12:07:10 +0100 10 30 242392030 2 77 1977 248 3600 2003" (adodb_date len=172)

07 Aug 1972 20:32:47 +0100 47 31 82063967 1 72 1972 219 3600 2003 Error date(): 82063967
 
  "date CET 1972-08-07 20:32:47 pm PM 07 Mon August 8 20 08 20 32 7 Monday 1 08 Aug 8 +0100 RFC822 Mon, 07 Aug 1972 20:32:47 +0100 47 31 82063967 1 72 1972 219 3600 2003" (date len=166)
  "date CET 1972-08-07 20:32:47 pm PM 07 Mon August 8 20 08 20 32 7 Monday 1 08 Aug 8 +0100 RFC822 Mon,  7 Aug 1972 20:32:47 +0100 47 31 82063967 1 72 1972 219 3600 2003" (adodb_date len=166)

03 Jan 1981 18:29:49 +0100 49 31 347390989 6 81 1981 2 3600 2003 Error date(): 347390989
 
  "date CET 1981-01-03 18:29:49 pm PM 03 Sat January 6 18 06 18 29 3 Saturday 0 01 Jan 1 +0100 RFC822 Sat, 03 Jan 1981 18:29:49 +0100 49 31 347390989 6 81 1981 2 3600 2003" (date len=168)
  "date CET 1981-01-03 18:29:49 pm PM 03 Sat January 6 18 06 18 29 3 Saturday 0 01 Jan 1 +0100 RFC822 Sat,  3 Jan 1981 18:29:49 +0100 49 31 347390989 6 81 1981 2 3600 2003" (adodb_date len=168)

09 Mar 1982 20:59:31 +0100 31 31 384551971 2 82 1982 67 3600 2003 Error date(): 384551971
 
  "date CET 1982-03-09 20:59:31 pm PM 09 Tue March 8 20 08 20 59 9 Tuesday 0 03 Mar 3 +0100 RFC822 Tue, 09 Mar 1982 20:59:31 +0100 31 31 384551971 2 82 1982 67 3600 2003" (date len=166)
  "date CET 1982-03-09 20:59:31 pm PM 09 Tue March 8 20 08 20 59 9 Tuesday 0 03 Mar 3 +0100 RFC822 Tue,  9 Mar 1982 20:59:31 +0100 31 31 384551971 2 82 1982 67 3600 2003" (adodb_date len=166)

09 Mar 1977 04:05:01 +0100 01 31 226724701 3 77 1977 67 3600 2003 Error date(): 226724701
 
  "date CET 1977-03-09 04:05:01 am AM 09 Wed March 4 4 04 04 05 9 Wednesday 0 03 Mar 3 +0100 RFC822 Wed, 09 Mar 1977 04:05:01 +0100 01 31 226724701 3 77 1977 67 3600 2003" (date len=167)
  "date CET 1977-03-09 04:05:01 am AM 09 Wed March 4 4 04 04 05 9 Wednesday 0 03 Mar 3 +0100 RFC822 Wed,  9 Mar 1977 04:05:01 +0100 01 31 226724701 3 77 1977 67 3600 2003" (adodb_date len=167)

06 Mar 1974 03:08:49 +0100 49 31 131767729 3 74 1974 64 3600 2003 Error date(): 131767729
 
  "date CET 1974-03-06 03:08:49 am AM 06 Wed March 3 3 03 03 08 6 Wednesday 0 03 Mar 3 +0100 RFC822 Wed, 06 Mar 1974 03:08:49 +0100 49 31 131767729 3 74 1974 64 3600 2003" (date len=167)
  "date CET 1974-03-06 03:08:49 am AM 06 Wed March 3 3 03 03 08 6 Wednesday 0 03 Mar 3 +0100 RFC822 Wed,  6 Mar 1974 03:08:49 +0100 49 31 131767729 3 74 1974 64 3600 2003" (adodb_date len=167)

08 Apr 1971 13:51:00 +0100 00 30 39963060 4 71 1971 97 3600 2003 Error date(): 39963060
 
  "date CET 1971-04-08 13:51:00 pm PM 08 Thu April 1 13 01 13 51 8 Thursday 0 04 Apr 4 +0100 RFC822 Thu, 08 Apr 1971 13:51:00 +0100 00 30 39963060 4 71 1971 97 3600 2003" (date len=166)
  "date CET 1971-04-08 13:51:00 pm PM 08 Thu April 1 13 01 13 51 8 Thursday 0 04 Apr 4 +0100 RFC822 Thu,  8 Apr 1971 13:51:00 +0100 00 30 39963060 4 71 1971 97 3600 2003" (adodb_date len=166)

06 Sep 1976 10:34:29 +0100 29 30 210850469 1 76 1976 249 3600 2003 Error date(): 210850469
 
  "date CET 1976-09-06 10:34:29 am AM 06 Mon September 10 10 10 10 34 6 Monday 1 09 Sep 9 +0100 RFC822 Mon, 06 Sep 1976 10:34:29 +0100 29 30 210850469 1 76 1976 249 3600 2003" (date len=171)
  "date CET 1976-09-06 10:34:29 am AM 06 Mon September 10 10 10 10 34 6 Monday 1 09 Sep 9 +0100 RFC822 Mon,  6 Sep 1976 10:34:29 +0100 29 30 210850469 1 76 1976 249 3600 2003" (adodb_date len=171)

08 Jun 1979 07:54:30 +0100 30 30 297672870 5 79 1979 158 3600 2003 Error date(): 297672870
 
  "date CET 1979-06-08 07:54:30 am AM 08 Fri June 7 7 07 07 54 8 Friday 0 06 Jun 6 +0100 RFC822 Fri, 08 Jun 1979 07:54:30 +0100 30 30 297672870 5 79 1979 158 3600 2003" (date len=164)
  "date CET 1979-06-08 07:54:30 am AM 08 Fri June 7 7 07 07 54 8 Friday 0 06 Jun 6 +0100 RFC822 Fri,  8 Jun 1979 07:54:30 +0100 30 30 297672870 5 79 1979 158 3600 2003" (adodb_date len=164)

ST 1980-09-10 15:32:45 pm PM 10 Wed September 3 15 03 15 32 10 Wednesday 1 09 Sep 9 +0200 RFC822 Wed, 10 Sep 1980 15:32:45 +0200 45 30 337440765 3 80 1980 253 7200 2003 Error date(): 337440765
 
  "date CEST 1980-09-10 15:32:45 pm PM 10 Wed September 3 15 03 15 32 10 Wednesday 1 09 Sep 9 +0200 RFC822 Wed, 10 Sep 1980 15:32:45 +0200 45 30 337440765 3 80 1980 253 7200 2003" (date len=175)
  "date CET 1980-09-10 14:32:45 pm PM 10 Wed September 2 14 02 14 32 10 Wednesday 1 09 Sep 9 +0100 RFC822 Wed, 10 Sep 1980 14:32:45 +0100 45 30 337440765 3 80 1980 253 3600 2003" (adodb_date len=174)

Error getdate() 337440765
Array ( [seconds] => 45 [minutes] => 32 [hours] => 15 [mday] => 10 [wday] => 3 [mon] => 9 [year] => 1980 [yday] => 253 [weekday] => Wednesday [month] => September [0] => 337440765 )
Array ( [seconds] => 45 [minutes] => 32 [hours] => 14 [mday] => 10 [wday] => 3 [mon] => 9 [year] => 1980 [yday] => 253 [weekday] => Wednesday [month] => September [0] => 337440765 )

05 Jun 1977 04:33:25 +0100 25 30 234329605 0 77 1977 155 3600 2003 Error date(): 234329605

 
  "date CET 1977-06-05 04:33:25 am AM 05 Sun June 4 4 04 04 33 5 Sunday 0 06 Jun 6 +0100 RFC822 Sun, 05 Jun 1977 04:33:25 +0100 25 30 234329605 0 77 1977 155 3600 2003" (date len=164)
  "date CET 1977-06-05 04:33:25 am AM 05 Sun June 4 4 04 04 33 5 Sunday 0 06 Jun 6 +0100 RFC822 Sun,  5 Jun 1977 04:33:25 +0100 25 30 234329605 0 77 1977 155 3600 2003" (adodb_date len=164)

ST 1980-07-11 14:34:58 pm PM 11 Fri July 2 14 02 14 34 11 Friday 1 07 Jul 7 +0200 RFC822 Fri, 11 Jul 1980 14:34:58 +0200 58 31 332166898 5 80 1980 192 7200 2003 Error date(): 332166898
 
  "date CEST 1980-07-11 14:34:58 pm PM 11 Fri July 2 14 02 14 34 11 Friday 1 07 Jul 7 +0200 RFC822 Fri, 11 Jul 1980 14:34:58 +0200 58 31 332166898 5 80 1980 192 7200 2003" (date len=167)
  "date CET 1980-07-11 13:34:58 pm PM 11 Fri July 1 13 01 13 34 11 Friday 1 07 Jul 7 +0100 RFC822 Fri, 11 Jul 1980 13:34:58 +0100 58 31 332166898 5 80 1980 192 3600 2003" (adodb_date len=166)

Error getdate() 332166898
Array ( [seconds] => 58 [minutes] => 34 [hours] => 14 [mday] => 11 [wday] => 5 [mon] => 7 [year] => 1980 [yday] => 192 [weekday] => Friday [month] => July [0] => 332166898 )
Array ( [seconds] => 58 [minutes] => 34 [hours] => 13 [mday] => 11 [wday] => 5 [mon] => 7 [year] => 1980 [yday] => 192 [weekday] => Friday [month] => July [0] => 332166898 )

03 Jun 1976 07:20:56 +0100 56 30 202630856 4 76 1976 154 3600 2003 Error date(): 202630856

 
  "date CET 1976-06-03 07:20:56 am AM 03 Thu June 7 7 07 07 20 3 Thursday 1 06 Jun 6 +0100 RFC822 Thu, 03 Jun 1976 07:20:56 +0100 56 30 202630856 4 76 1976 154 3600 2003" (date len=166)
  "date CET 1976-06-03 07:20:56 am AM 03 Thu June 7 7 07 07 20 3 Thursday 1 06 Jun 6 +0100 RFC822 Thu,  3 Jun 1976 07:20:56 +0100 56 30 202630856 4 76 1976 154 3600 2003" (adodb_date len=166)

07 Jan 1979 16:53:59 +0100 59 31 284572439 0 79 1979 6 3600 2003 Error date(): 284572439
 
  "date CET 1979-01-07 16:53:59 pm PM 07 Sun January 4 16 04 16 53 7 Sunday 0 01 Jan 1 +0100 RFC822 Sun, 07 Jan 1979 16:53:59 +0100 59 31 284572439 0 79 1979 6 3600 2003" (date len=166)
  "date CET 1979-01-07 16:53:59 pm PM 07 Sun January 4 16 04 16 53 7 Sunday 0 01 Jan 1 +0100 RFC822 Sun,  7 Jan 1979 16:53:59 +0100 59 31 284572439 0 79 1979 6 3600 2003" (adodb_date len=166)

07 Sep 1977 13:42:11 +0100 11 30 242484131 3 77 1977 249 3600 2003 Error date(): 242484131
 
  "date CET 1977-09-07 13:42:11 pm PM 07 Wed September 1 13 01 13 42 7 Wednesday 0 09 Sep 9 +0100 RFC822 Wed, 07 Sep 1977 13:42:11 +0100 11 30 242484131 3 77 1977 249 3600 2003" (date len=173)
  "date CET 1977-09-07 13:42:11 pm PM 07 Wed September 1 13 01 13 42 7 Wednesday 0 09 Sep 9 +0100 RFC822 Wed,  7 Sep 1977 13:42:11 +0100 11 30 242484131 3 77 1977 249 3600 2003" (adodb_date len=173)

ST 1981-07-12 12:51:28 pm PM 12 Sun July 12 12 12 12 51 12 Sunday 0 07 Jul 7 +0200 RFC822 Sun, 12 Jul 1981 12:51:28 +0200 28 31 363783088 0 81 1981 192 7200 2003 Error date(): 363783088
 
  "date CEST 1981-07-12 12:51:28 pm PM 12 Sun July 12 12 12 12 51 12 Sunday 0 07 Jul 7 +0200 RFC822 Sun, 12 Jul 1981 12:51:28 +0200 28 31 363783088 0 81 1981 192 7200 2003" (date len=168)
  "date CET 1981-07-12 11:51:28 am AM 12 Sun July 11 11 11 11 51 12 Sunday 0 07 Jul 7 +0100 RFC822 Sun, 12 Jul 1981 11:51:28 +0100 28 31 363783088 0 81 1981 192 3600 2003" (adodb_date len=167)

09 Jun 1978 04:34:13 +0100 13 30 266211253 5 78 1978 159 3600 2003 Error date(): 266211253
 
  "date CET 1978-06-09 04:34:13 am AM 09 Fri June 4 4 04 04 34 9 Friday 0 06 Jun 6 +0100 RFC822 Fri, 09 Jun 1978 04:34:13 +0100 13 30 266211253 5 78 1978 159 3600 2003" (date len=164)
  "date CET 1978-06-09 04:34:13 am AM 09 Fri June 4 4 04 04 34 9 Friday 0 06 Jun 6 +0100 RFC822 Fri,  9 Jun 1978 04:34:13 +0100 13 30 266211253 5 78 1978 159 3600 2003" (adodb_date len=164)

04 Jan 1978 09:08:28 +0100 28 31 252749308 3 78 1978 3 3600 2003 Error date(): 252749308
 
  "date CET 1978-01-04 09:08:28 am AM 04 Wed January 9 9 09 09 08 4 Wednesday 0 01 Jan 1 +0100 RFC822 Wed, 04 Jan 1978 09:08:28 +0100 28 31 252749308 3 78 1978 3 3600 2003" (date len=168)
  "date CET 1978-01-04 09:08:28 am AM 04 Wed January 9 9 09 09 08 4 Wednesday 0 01 Jan 1 +0100 RFC822 Wed,  4 Jan 1978 09:08:28 +0100 28 31 252749308 3 78 1978 3 3600 2003" (adodb_date len=168)

04 May 1971 09:27:18 +0100 18 31 42193638 2 71 1971 123 3600 2003 Error date(): 42193638
 
  "date CET 1971-05-04 09:27:18 am AM 04 Tue May 9 9 09 09 27 4 Tuesday 0 05 May 5 +0100 RFC822 Tue, 04 May 1971 09:27:18 +0100 18 31 42193638 2 71 1971 123 3600 2003" (date len=163)
  "date CET 1971-05-04 09:27:18 am AM 04 Tue May 9 9 09 09 27 4 Tuesday 0 05 May 5 +0100 RFC822 Tue,  4 May 1971 09:27:18 +0100 18 31 42193638 2 71 1971 123 3600 2003" (adodb_date len=163)

02 Mar 1982 23:35:38 +0100 38 31 383956538 2 82 1982 60 3600 2003 Error date(): 383956538
 
  "date CET 1982-03-02 23:35:38 pm PM 02 Tue March 11 23 11 23 35 2 Tuesday 0 03 Mar 3 +0100 RFC822 Tue, 02 Mar 1982 23:35:38 +0100 38 31 383956538 2 82 1982 60 3600 2003" (date len=167)
  "date CET 1982-03-02 23:35:38 pm PM 02 Tue March 11 23 11 23 35 2 Tuesday 0 03 Mar 3 +0100 RFC822 Tue,  2 Mar 1982 23:35:38 +0100 38 31 383956538 2 82 1982 60 3600 2003" (adodb_date len=167)

04 Mar 1976 05:09:52 +0100 52 31 194760592 4 76 1976 63 3600 2003 Error date(): 194760592
 
  "date CET 1976-03-04 05:09:52 am AM 04 Thu March 5 5 05 05 09 4 Thursday 1 03 Mar 3 +0100 RFC822 Thu, 04 Mar 1976 05:09:52 +0100 52 31 194760592 4 76 1976 63 3600 2003" (date len=166)
  "date CET 1976-03-04 05:09:52 am AM 04 Thu March 5 5 05 05 09 4 Thursday 1 03 Mar 3 +0100 RFC822 Thu,  4 Mar 1976 05:09:52 +0100 52 31 194760592 4 76 1976 63 3600 2003" (adodb_date len=166)

05 Feb 1978 18:16:10 +0100 10 28 255546970 0 78 1978 35 3600 2003 Error date(): 255546970
 
  "date CET 1978-02-05 18:16:10 pm PM 05 Sun February 6 18 06 18 16 5 Sunday 0 02 Feb 2 +0100 RFC822 Sun, 05 Feb 1978 18:16:10 +0100 10 28 255546970 0 78 1978 35 3600 2003" (date len=168)
  "date CET 1978-02-05 18:16:10 pm PM 05 Sun February 6 18 06 18 16 5 Sunday 0 02 Feb 2 +0100 RFC822 Sun,  5 Feb 1978 18:16:10 +0100 10 28 255546970 0 78 1978 35 3600 2003" (adodb_date len=168)

01 Jul 1976 07:02:22 +0100 22 31 205048942 4 76 1976 182 3600 2003 Error date(): 205048942
 
  "date CET 1976-07-01 07:02:22 am AM 01 Thu July 7 7 07 07 02 1 Thursday 1 07 Jul 7 +0100 RFC822 Thu, 01 Jul 1976 07:02:22 +0100 22 31 205048942 4 76 1976 182 3600 2003" (date len=166)
  "date CET 1976-07-01 07:02:22 am AM 01 Thu July 7 7 07 07 02 1 Thursday 1 07 Jul 7 +0100 RFC822 Thu,  1 Jul 1976 07:02:22 +0100 22 31 205048942 4 76 1976 182 3600 2003" (adodb_date len=166)

09 Oct 1975 11:33:48 +0100 48 31 182082828 4 75 1975 281 3600 2003 Error date(): 182082828
 
  "date CET 1975-10-09 11:33:48 am AM 09 Thu October 11 11 11 11 33 9 Thursday 0 10 Oct 10 +0100 RFC822 Thu, 09 Oct 1975 11:33:48 +0100 48 31 182082828 4 75 1975 281 3600 2003" (date len=172)
  "date CET 1975-10-09 11:33:48 am AM 09 Thu October 11 11 11 11 33 9 Thursday 0 10 Oct 10 +0100 RFC822 Thu,  9 Oct 1975 11:33:48 +0100 48 31 182082828 4 75 1975 281 3600 2003" (adodb_date len=172)

09 Jun 1974 09:04:00 +0100 00 30 139997040 0 74 1974 159 3600 2003 Error date(): 139997040
 
  "date CET 1974-06-09 09:04:00 am AM 09 Sun June 9 9 09 09 04 9 Sunday 0 06 Jun 6 +0100 RFC822 Sun, 09 Jun 1974 09:04:00 +0100 00 30 139997040 0 74 1974 159 3600 2003" (date len=164)
  "date CET 1974-06-09 09:04:00 am AM 09 Sun June 9 9 09 09 04 9 Sunday 0 06 Jun 6 +0100 RFC822 Sun,  9 Jun 1974 09:04:00 +0100 00 30 139997040 0 74 1974 159 3600 2003" (adodb_date len=164)

Testing random dates between 100 and 4000

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

Failed :-(

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