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.

Access
Interbase
MSSQL
MySQL
MySQL ODBC
MySQL Proxy
Oracle (oci8)
PostgreSQL
PostgreSQL ODBC
DB2
VFP
ADO (for mssql and access)
$ADODB_COUNTRECS=false
Test GetInsertSQL/GetUpdateSQL   Sessions   Paging  

Connecting mysql...


Warning: mysql_pconnect() [function.mysql-pconnect]: Unknown MySQL server host 'mangrove' (2) in /opt/lampp/htdocs/autobackup/adodb/drivers/adodb-mysql.inc.php on line 251
ERROR: MySQL test requires a MySQL server on localhost, userid='admin', password='', database='test'
Unknown MySQL server host 'mangrove' (2)

Tests Completed

Testing adodb_date and adodb_mktime. version=0.08

Testing gregorian <=> julian conversion

-12219408000 -12219321600 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

date() 0 failed
date CST 1970-01-01 08:00:00 am AM 01 Thu January 8 8 08 08 00 1 Thursday 0 01 Jan 1 +0800 RFC822 Thu, 01 Jan 1970 08:00:00 +0800 00 31 0 4 70 1970 0 28800 2003
date CST 1970-01-01 08:00:00 am AM 01 Thu January 8 8 08 08 00 1 Thursday 0 01 Jan 1 +0800 RFC822 Thu, 1 Jan 1970 08:00:00 +0800 00 31 0 4 70 1970 0 28800 2003
07 Feb 1973 21:13:11 +0800 11 28 97938791 3 73 1973 37 28800 2003 Error date(): 97938791
 
  "date CST 1973-02-07 21:13:11 pm PM 07 Wed February 9 21 09 21 13 7 Wednesday 0 02 Feb 2 +0800 RFC822 Wed, 07 Feb 1973 21:13:11 +0800 11 28 97938791 3 73 1973 37 28800 2003" (date len=171)
  "date CST 1973-02-07 21:13:11 pm PM 07 Wed February 9 21 09 21 13 7 Wednesday 0 02 Feb 2 +0800 RFC822 Wed,  7 Feb 1973 21:13:11 +0800 11 28 97938791 3 73 1973 37 28800 2003" (adodb_date len=171)

DT 1974-06-10 01:14:52 am AM 10 Mon June 1 1 01 01 14 10 Monday 0 06 Jun 6 +0900 RFC822 Mon, 10 Jun 1974 01:14:52 +0900 52 30 140026492 1 74 1974 160 32400 2003 Error date(): 140026492
 
  "date CDT 1974-06-10 01:14:52 am AM 10 Mon June 1 1 01 01 14 10 Monday 0 06 Jun 6 +0900 RFC822 Mon, 10 Jun 1974 01:14:52 +0900 52 30 140026492 1 74 1974 160 32400 2003" (date len=166)
  "date CST 1974-06-10 00:14:52 am AM 10 Mon June 12 0 12 00 14 10 Monday 0 06 Jun 6 +0800 RFC822 Mon, 10 Jun 1974 00:14:52 +0800 52 30 140026492 1 74 1974 160 28800 2003" (adodb_date len=167)

DT 1974-06-27 17:20:04 pm PM 27 Thu June 5 17 05 17 20 27 Thursday 0 06 Jun 6 +0900 RFC822 Thu, 27 Jun 1974 17:20:04 +0900 04 30 141553204 4 74 1974 177 32400 2003 Error date(): 141553204
 
  "date CDT 1974-06-27 17:20:04 pm PM 27 Thu June 5 17 05 17 20 27 Thursday 0 06 Jun 6 +0900 RFC822 Thu, 27 Jun 1974 17:20:04 +0900 04 30 141553204 4 74 1974 177 32400 2003" (date len=169)
  "date CST 1974-06-27 16:20:04 pm PM 27 Thu June 4 16 04 16 20 27 Thursday 0 06 Jun 6 +0800 RFC822 Thu, 27 Jun 1974 16:20:04 +0800 04 30 141553204 4 74 1974 177 28800 2003" (adodb_date len=169)

Error getdate() 141553204
Array ( [seconds] => 4 [minutes] => 20 [hours] => 17 [mday] => 27 [wday] => 4 [mon] => 6 [year] => 1974 [yday] => 177 [weekday] => Thursday [month] => June [0] => 141553204 )
Array ( [seconds] => 4 [minutes] => 20 [hours] => 16 [mday] => 27 [wday] => 4 [mon] => 6 [year] => 1974 [yday] => 177 [weekday] => Thursday [month] => June [0] => 141553204 )

DT 1975-08-04 05:50:21 am AM 04 Mon August 5 5 05 05 50 4 Monday 0 08 Aug 8 +0900 RFC822 Mon, 04 Aug 1975 05:50:21 +0900 21 31 176331021 1 75 1975 215 32400 2003 Error date(): 176331021

 
  "date CDT 1975-08-04 05:50:21 am AM 04 Mon August 5 5 05 05 50 4 Monday 0 08 Aug 8 +0900 RFC822 Mon, 04 Aug 1975 05:50:21 +0900 21 31 176331021 1 75 1975 215 32400 2003" (date len=167)
  "date CST 1975-08-04 04:50:21 am AM 04 Mon August 4 4 04 04 50 4 Monday 0 08 Aug 8 +0800 RFC822 Mon,  4 Aug 1975 04:50:21 +0800 21 31 176331021 1 75 1975 215 28800 2003" (adodb_date len=167)

Error getdate() 176331021
Array ( [seconds] => 21 [minutes] => 50 [hours] => 5 [mday] => 4 [wday] => 1 [mon] => 8 [year] => 1975 [yday] => 215 [weekday] => Monday [month] => August [0] => 176331021 )
Array ( [seconds] => 21 [minutes] => 50 [hours] => 4 [mday] => 4 [wday] => 1 [mon] => 8 [year] => 1975 [yday] => 215 [weekday] => Monday [month] => August [0] => 176331021 )

01 Nov 1974 17:15:37 +0800 37 30 152529337 5 74 1974 304 28800 2003 Error date(): 152529337

 
  "date CST 1974-11-01 17:15:37 pm PM 01 Fri November 5 17 05 17 15 1 Friday 0 11 Nov 11 +0800 RFC822 Fri, 01 Nov 1974 17:15:37 +0800 37 30 152529337 5 74 1974 304 28800 2003" (date len=171)
  "date CST 1974-11-01 17:15:37 pm PM 01 Fri November 5 17 05 17 15 1 Friday 0 11 Nov 11 +0800 RFC822 Fri,  1 Nov 1974 17:15:37 +0800 37 30 152529337 5 74 1974 304 28800 2003" (adodb_date len=171)

08 Sep 1976 14:35:39 +0800 39 30 211012539 3 76 1976 251 28800 2003 Error date(): 211012539
 
  "date CST 1976-09-08 14:35:39 pm PM 08 Wed September 2 14 02 14 35 8 Wednesday 1 09 Sep 9 +0800 RFC822 Wed, 08 Sep 1976 14:35:39 +0800 39 30 211012539 3 76 1976 251 28800 2003" (date len=174)
  "date CST 1976-09-08 14:35:39 pm PM 08 Wed September 2 14 02 14 35 8 Wednesday 1 09 Sep 9 +0800 RFC822 Wed,  8 Sep 1976 14:35:39 +0800 39 30 211012539 3 76 1976 251 28800 2003" (adodb_date len=174)

02 Aug 1976 18:23:16 +0800 16 31 207829396 1 76 1976 214 28800 2003 Error date(): 207829396
 
  "date CST 1976-08-02 18:23:16 pm PM 02 Mon August 6 18 06 18 23 2 Monday 1 08 Aug 8 +0800 RFC822 Mon, 02 Aug 1976 18:23:16 +0800 16 31 207829396 1 76 1976 214 28800 2003" (date len=168)
  "date CST 1976-08-02 18:23:16 pm PM 02 Mon August 6 18 06 18 23 2 Monday 1 08 Aug 8 +0800 RFC822 Mon,  2 Aug 1976 18:23:16 +0800 16 31 207829396 1 76 1976 214 28800 2003" (adodb_date len=168)

07 Nov 1974 10:20:56 +0800 56 30 153022856 4 74 1974 310 28800 2003 Error date(): 153022856
 
  "date CST 1974-11-07 10:20:56 am AM 07 Thu November 10 10 10 10 20 7 Thursday 0 11 Nov 11 +0800 RFC822 Thu, 07 Nov 1974 10:20:56 +0800 56 30 153022856 4 74 1974 310 28800 2003" (date len=174)
  "date CST 1974-11-07 10:20:56 am AM 07 Thu November 10 10 10 10 20 7 Thursday 0 11 Nov 11 +0800 RFC822 Thu,  7 Nov 1974 10:20:56 +0800 56 30 153022856 4 74 1974 310 28800 2003" (adodb_date len=174)

08 Mar 1977 21:02:46 +0800 46 31 226674166 2 77 1977 66 28800 2003 Error date(): 226674166
 
  "date CST 1977-03-08 21:02:46 pm PM 08 Tue March 9 21 09 21 02 8 Tuesday 0 03 Mar 3 +0800 RFC822 Tue, 08 Mar 1977 21:02:46 +0800 46 31 226674166 2 77 1977 66 28800 2003" (date len=167)
  "date CST 1977-03-08 21:02:46 pm PM 08 Tue March 9 21 09 21 02 8 Tuesday 0 03 Mar 3 +0800 RFC822 Tue,  8 Mar 1977 21:02:46 +0800 46 31 226674166 2 77 1977 66 28800 2003" (adodb_date len=167)

DT 1974-06-21 09:39:16 am AM 21 Fri June 9 9 09 09 39 21 Friday 0 06 Jun 6 +0900 RFC822 Fri, 21 Jun 1974 09:39:16 +0900 16 30 141007156 5 74 1974 171 32400 2003 Error date(): 141007156
 
  "date CDT 1974-06-21 09:39:16 am AM 21 Fri June 9 9 09 09 39 21 Friday 0 06 Jun 6 +0900 RFC822 Fri, 21 Jun 1974 09:39:16 +0900 16 30 141007156 5 74 1974 171 32400 2003" (date len=166)
  "date CST 1974-06-21 08:39:16 am AM 21 Fri June 8 8 08 08 39 21 Friday 0 06 Jun 6 +0800 RFC822 Fri, 21 Jun 1974 08:39:16 +0800 16 30 141007156 5 74 1974 171 28800 2003" (adodb_date len=166)

Error getdate() 141007156
Array ( [seconds] => 16 [minutes] => 39 [hours] => 9 [mday] => 21 [wday] => 5 [mon] => 6 [year] => 1974 [yday] => 171 [weekday] => Friday [month] => June [0] => 141007156 )
Array ( [seconds] => 16 [minutes] => 39 [hours] => 8 [mday] => 21 [wday] => 5 [mon] => 6 [year] => 1974 [yday] => 171 [weekday] => Friday [month] => June [0] => 141007156 )

05 Aug 1972 07:01:28 +0800 28 31 81817288 6 72 1972 217 28800 2003 Error date(): 81817288

 
  "date CST 1972-08-05 07:01:28 am AM 05 Sat August 7 7 07 07 01 5 Saturday 1 08 Aug 8 +0800 RFC822 Sat, 05 Aug 1972 07:01:28 +0800 28 31 81817288 6 72 1972 217 28800 2003" (date len=168)
  "date CST 1972-08-05 07:01:28 am AM 05 Sat August 7 7 07 07 01 5 Saturday 1 08 Aug 8 +0800 RFC822 Sat,  5 Aug 1972 07:01:28 +0800 28 31 81817288 6 72 1972 217 28800 2003" (adodb_date len=168)

DT 1975-07-17 15:45:18 pm PM 17 Thu July 3 15 03 15 45 17 Thursday 0 07 Jul 7 +0900 RFC822 Thu, 17 Jul 1975 15:45:18 +0900 18 31 174811518 4 75 1975 197 32400 2003 Error date(): 174811518
 
  "date CDT 1975-07-17 15:45:18 pm PM 17 Thu July 3 15 03 15 45 17 Thursday 0 07 Jul 7 +0900 RFC822 Thu, 17 Jul 1975 15:45:18 +0900 18 31 174811518 4 75 1975 197 32400 2003" (date len=169)
  "date CST 1975-07-17 14:45:18 pm PM 17 Thu July 2 14 02 14 45 17 Thursday 0 07 Jul 7 +0800 RFC822 Thu, 17 Jul 1975 14:45:18 +0800 18 31 174811518 4 75 1975 197 28800 2003" (adodb_date len=169)

Error getdate() 174811518
Array ( [seconds] => 18 [minutes] => 45 [hours] => 15 [mday] => 17 [wday] => 4 [mon] => 7 [year] => 1975 [yday] => 197 [weekday] => Thursday [month] => July [0] => 174811518 )
Array ( [seconds] => 18 [minutes] => 45 [hours] => 14 [mday] => 17 [wday] => 4 [mon] => 7 [year] => 1975 [yday] => 197 [weekday] => Thursday [month] => July [0] => 174811518 )

DT 1975-09-11 22:38:25 pm PM 11 Thu September 10 22 10 22 38 11 Thursday 0 09 Sep 9 +0900 RFC822 Thu, 11 Sep 1975 22:38:25 +0900 25 30 179674705 4 75 1975 253 32400 2003 Error date(): 179674705

 
  "date CDT 1975-09-11 22:38:25 pm PM 11 Thu September 10 22 10 22 38 11 Thursday 0 09 Sep 9 +0900 RFC822 Thu, 11 Sep 1975 22:38:25 +0900 25 30 179674705 4 75 1975 253 32400 2003" (date len=175)
  "date CST 1975-09-11 21:38:25 pm PM 11 Thu September 9 21 09 21 38 11 Thursday 0 09 Sep 9 +0800 RFC822 Thu, 11 Sep 1975 21:38:25 +0800 25 30 179674705 4 75 1975 253 28800 2003" (adodb_date len=174)

Error getdate() 179674705
Array ( [seconds] => 25 [minutes] => 38 [hours] => 22 [mday] => 11 [wday] => 4 [mon] => 9 [year] => 1975 [yday] => 253 [weekday] => Thursday [month] => September [0] => 179674705 )
Array ( [seconds] => 25 [minutes] => 38 [hours] => 21 [mday] => 11 [wday] => 4 [mon] => 9 [year] => 1975 [yday] => 253 [weekday] => Thursday [month] => September [0] => 179674705 )

DT 1974-05-13 06:28:34 am AM 13 Mon May 6 6 06 06 28 13 Monday 0 05 May 5 +0900 RFC822 Mon, 13 May 1974 06:28:34 +0900 34 31 137626114 1 74 1974 132 32400 2003 Error date(): 137626114

 
  "date CDT 1974-05-13 06:28:34 am AM 13 Mon May 6 6 06 06 28 13 Monday 0 05 May 5 +0900 RFC822 Mon, 13 May 1974 06:28:34 +0900 34 31 137626114 1 74 1974 132 32400 2003" (date len=165)
  "date CST 1974-05-13 05:28:34 am AM 13 Mon May 5 5 05 05 28 13 Monday 0 05 May 5 +0800 RFC822 Mon, 13 May 1974 05:28:34 +0800 34 31 137626114 1 74 1974 132 28800 2003" (adodb_date len=165)

Error getdate() 137626114
Array ( [seconds] => 34 [minutes] => 28 [hours] => 6 [mday] => 13 [wday] => 1 [mon] => 5 [year] => 1974 [yday] => 132 [weekday] => Monday [month] => May [0] => 137626114 )
Array ( [seconds] => 34 [minutes] => 28 [hours] => 5 [mday] => 13 [wday] => 1 [mon] => 5 [year] => 1974 [yday] => 132 [weekday] => Monday [month] => May [0] => 137626114 )

07 Oct 1976 08:20:15 +0800 15 31 213495615 4 76 1976 280 28800 2003 Error date(): 213495615

 
  "date CST 1976-10-07 08:20:15 am AM 07 Thu October 8 8 08 08 20 7 Thursday 1 10 Oct 10 +0800 RFC822 Thu, 07 Oct 1976 08:20:15 +0800 15 31 213495615 4 76 1976 280 28800 2003" (date len=171)
  "date CST 1976-10-07 08:20:15 am AM 07 Thu October 8 8 08 08 20 7 Thursday 1 10 Oct 10 +0800 RFC822 Thu,  7 Oct 1976 08:20:15 +0800 15 31 213495615 4 76 1976 280 28800 2003" (adodb_date len=171)

DT 1974-04-25 07:32:22 am AM 25 Thu April 7 7 07 07 32 25 Thursday 0 04 Apr 4 +0900 RFC822 Thu, 25 Apr 1974 07:32:22 +0900 22 30 136074742 4 74 1974 114 32400 2003 Error date(): 136074742
 
  "date CDT 1974-04-25 07:32:22 am AM 25 Thu April 7 7 07 07 32 25 Thursday 0 04 Apr 4 +0900 RFC822 Thu, 25 Apr 1974 07:32:22 +0900 22 30 136074742 4 74 1974 114 32400 2003" (date len=169)
  "date CST 1974-04-25 06:32:22 am AM 25 Thu April 6 6 06 06 32 25 Thursday 0 04 Apr 4 +0800 RFC822 Thu, 25 Apr 1974 06:32:22 +0800 22 30 136074742 4 74 1974 114 28800 2003" (adodb_date len=169)

Error getdate() 136074742
Array ( [seconds] => 22 [minutes] => 32 [hours] => 7 [mday] => 25 [wday] => 4 [mon] => 4 [year] => 1974 [yday] => 114 [weekday] => Thursday [month] => April [0] => 136074742 )
Array ( [seconds] => 22 [minutes] => 32 [hours] => 6 [mday] => 25 [wday] => 4 [mon] => 4 [year] => 1974 [yday] => 114 [weekday] => Thursday [month] => April [0] => 136074742 )

05 Apr 1978 16:25:22 +0800 22 30 260612722 3 78 1978 94 28800 2003 Error date(): 260612722

 
  "date CST 1978-04-05 16:25:22 pm PM 05 Wed April 4 16 04 16 25 5 Wednesday 0 04 Apr 4 +0800 RFC822 Wed, 05 Apr 1978 16:25:22 +0800 22 30 260612722 3 78 1978 94 28800 2003" (date len=169)
  "date CST 1978-04-05 16:25:22 pm PM 05 Wed April 4 16 04 16 25 5 Wednesday 0 04 Apr 4 +0800 RFC822 Wed,  5 Apr 1978 16:25:22 +0800 22 30 260612722 3 78 1978 94 28800 2003" (adodb_date len=169)

03 May 1972 21:33:51 +0800 51 31 73748031 3 72 1972 123 28800 2003 Error date(): 73748031
 
  "date CST 1972-05-03 21:33:51 pm PM 03 Wed May 9 21 09 21 33 3 Wednesday 1 05 May 5 +0800 RFC822 Wed, 03 May 1972 21:33:51 +0800 51 31 73748031 3 72 1972 123 28800 2003" (date len=167)
  "date CST 1972-05-03 21:33:51 pm PM 03 Wed May 9 21 09 21 33 3 Wednesday 1 05 May 5 +0800 RFC822 Wed,  3 May 1972 21:33:51 +0800 51 31 73748031 3 72 1972 123 28800 2003" (adodb_date len=167)

DT 1975-04-18 22:01:36 pm PM 18 Fri April 10 22 10 22 01 18 Friday 0 04 Apr 4 +0900 RFC822 Fri, 18 Apr 1975 22:01:36 +0900 36 30 167058096 5 75 1975 107 32400 2003 Error date(): 167058096
 
  "date CDT 1975-04-18 22:01:36 pm PM 18 Fri April 10 22 10 22 01 18 Friday 0 04 Apr 4 +0900 RFC822 Fri, 18 Apr 1975 22:01:36 +0900 36 30 167058096 5 75 1975 107 32400 2003" (date len=169)
  "date CST 1975-04-18 21:01:36 pm PM 18 Fri April 9 21 09 21 01 18 Friday 0 04 Apr 4 +0800 RFC822 Fri, 18 Apr 1975 21:01:36 +0800 36 30 167058096 5 75 1975 107 28800 2003" (adodb_date len=168)

Error getdate() 167058096
Array ( [seconds] => 36 [minutes] => 1 [hours] => 22 [mday] => 18 [wday] => 5 [mon] => 4 [year] => 1975 [yday] => 107 [weekday] => Friday [month] => April [0] => 167058096 )
Array ( [seconds] => 36 [minutes] => 1 [hours] => 21 [mday] => 18 [wday] => 5 [mon] => 4 [year] => 1975 [yday] => 107 [weekday] => Friday [month] => April [0] => 167058096 )

02 Nov 1981 10:39:21 +0800 21 30 373516761 1 81 1981 305 28800 2003 Error date(): 373516761

 
  "date CST 1981-11-02 10:39:21 am AM 02 Mon November 10 10 10 10 39 2 Monday 0 11 Nov 11 +0800 RFC822 Mon, 02 Nov 1981 10:39:21 +0800 21 30 373516761 1 81 1981 305 28800 2003" (date len=172)
  "date CST 1981-11-02 10:39:21 am AM 02 Mon November 10 10 10 10 39 2 Monday 0 11 Nov 11 +0800 RFC822 Mon,  2 Nov 1981 10:39:21 +0800 21 30 373516761 1 81 1981 305 28800 2003" (adodb_date len=172)

DT 1975-07-30 10:03:31 am AM 30 Wed July 10 10 10 10 03 30 Wednesday 0 07 Jul 7 +0900 RFC822 Wed, 30 Jul 1975 10:03:31 +0900 31 31 175914211 3 75 1975 210 32400 2003 Error date(): 175914211
 
  "date CDT 1975-07-30 10:03:31 am AM 30 Wed July 10 10 10 10 03 30 Wednesday 0 07 Jul 7 +0900 RFC822 Wed, 30 Jul 1975 10:03:31 +0900 31 31 175914211 3 75 1975 210 32400 2003" (date len=171)
  "date CST 1975-07-30 09:03:31 am AM 30 Wed July 9 9 09 09 03 30 Wednesday 0 07 Jul 7 +0800 RFC822 Wed, 30 Jul 1975 09:03:31 +0800 31 31 175914211 3 75 1975 210 28800 2003" (adodb_date len=169)

Error getdate() 175914211
Array ( [seconds] => 31 [minutes] => 3 [hours] => 10 [mday] => 30 [wday] => 3 [mon] => 7 [year] => 1975 [yday] => 210 [weekday] => Wednesday [month] => July [0] => 175914211 )
Array ( [seconds] => 31 [minutes] => 3 [hours] => 9 [mday] => 30 [wday] => 3 [mon] => 7 [year] => 1975 [yday] => 210 [weekday] => Wednesday [month] => July [0] => 175914211 )

02 Mar 1976 01:00:54 +0800 54 31 194547654 2 76 1976 61 28800 2003 Error date(): 194547654

 
  "date CST 1976-03-02 01:00:54 am AM 02 Tue March 1 1 01 01 00 2 Tuesday 1 03 Mar 3 +0800 RFC822 Tue, 02 Mar 1976 01:00:54 +0800 54 31 194547654 2 76 1976 61 28800 2003" (date len=166)
  "date CST 1976-03-02 01:00:54 am AM 02 Tue March 1 1 01 01 00 2 Tuesday 1 03 Mar 3 +0800 RFC822 Tue,  2 Mar 1976 01:00:54 +0800 54 31 194547654 2 76 1976 61 28800 2003" (adodb_date len=166)

04 Mar 1975 21:29:38 +0800 38 31 163171778 2 75 1975 62 28800 2003 Error date(): 163171778
 
  "date CST 1975-03-04 21:29:38 pm PM 04 Tue March 9 21 09 21 29 4 Tuesday 0 03 Mar 3 +0800 RFC822 Tue, 04 Mar 1975 21:29:38 +0800 38 31 163171778 2 75 1975 62 28800 2003" (date len=167)
  "date CST 1975-03-04 21:29:38 pm PM 04 Tue March 9 21 09 21 29 4 Tuesday 0 03 Mar 3 +0800 RFC822 Tue,  4 Mar 1975 21:29:38 +0800 38 31 163171778 2 75 1975 62 28800 2003" (adodb_date len=167)

DT 1975-06-12 05:57:29 am AM 12 Thu June 5 5 05 05 57 12 Thursday 0 06 Jun 6 +0900 RFC822 Thu, 12 Jun 1975 05:57:29 +0900 29 30 171752249 4 75 1975 162 32400 2003 Error date(): 171752249
 
  "date CDT 1975-06-12 05:57:29 am AM 12 Thu June 5 5 05 05 57 12 Thursday 0 06 Jun 6 +0900 RFC822 Thu, 12 Jun 1975 05:57:29 +0900 29 30 171752249 4 75 1975 162 32400 2003" (date len=168)
  "date CST 1975-06-12 04:57:29 am AM 12 Thu June 4 4 04 04 57 12 Thursday 0 06 Jun 6 +0800 RFC822 Thu, 12 Jun 1975 04:57:29 +0800 29 30 171752249 4 75 1975 162 28800 2003" (adodb_date len=168)

Error getdate() 171752249
Array ( [seconds] => 29 [minutes] => 57 [hours] => 5 [mday] => 12 [wday] => 4 [mon] => 6 [year] => 1975 [yday] => 162 [weekday] => Thursday [month] => June [0] => 171752249 )
Array ( [seconds] => 29 [minutes] => 57 [hours] => 4 [mday] => 12 [wday] => 4 [mon] => 6 [year] => 1975 [yday] => 162 [weekday] => Thursday [month] => June [0] => 171752249 )

DT 1975-08-11 08:01:56 am AM 11 Mon August 8 8 08 08 01 11 Monday 0 08 Aug 8 +0900 RFC822 Mon, 11 Aug 1975 08:01:56 +0900 56 31 176943716 1 75 1975 222 32400 2003 Error date(): 176943716

 
  "date CDT 1975-08-11 08:01:56 am AM 11 Mon August 8 8 08 08 01 11 Monday 0 08 Aug 8 +0900 RFC822 Mon, 11 Aug 1975 08:01:56 +0900 56 31 176943716 1 75 1975 222 32400 2003" (date len=168)
  "date CST 1975-08-11 07:01:56 am AM 11 Mon August 7 7 07 07 01 11 Monday 0 08 Aug 8 +0800 RFC822 Mon, 11 Aug 1975 07:01:56 +0800 56 31 176943716 1 75 1975 222 28800 2003" (adodb_date len=168)

02 Feb 1976 20:13:36 +0800 36 29 192111216 1 76 1976 32 28800 2003 Error date(): 192111216
 
  "date CST 1976-02-02 20:13:36 pm PM 02 Mon February 8 20 08 20 13 2 Monday 1 02 Feb 2 +0800 RFC822 Mon, 02 Feb 1976 20:13:36 +0800 36 29 192111216 1 76 1976 32 28800 2003" (date len=169)
  "date CST 1976-02-02 20:13:36 pm PM 02 Mon February 8 20 08 20 13 2 Monday 1 02 Feb 2 +0800 RFC822 Mon,  2 Feb 1976 20:13:36 +0800 36 29 192111216 1 76 1976 32 28800 2003" (adodb_date len=169)

08 Jul 1972 06:04:44 +0800 44 31 79394684 6 72 1972 189 28800 2003 Error date(): 79394684
 
  "date CST 1972-07-08 06:04:44 am AM 08 Sat July 6 6 06 06 04 8 Saturday 1 07 Jul 7 +0800 RFC822 Sat, 08 Jul 1972 06:04:44 +0800 44 31 79394684 6 72 1972 189 28800 2003" (date len=166)
  "date CST 1972-07-08 06:04:44 am AM 08 Sat July 6 6 06 06 04 8 Saturday 1 07 Jul 7 +0800 RFC822 Sat,  8 Jul 1972 06:04:44 +0800 44 31 79394684 6 72 1972 189 28800 2003" (adodb_date len=166)

03 Nov 1972 17:12:52 +0800 52 30 89629972 5 72 1972 307 28800 2003 Error date(): 89629972
 
  "date CST 1972-11-03 17:12:52 pm PM 03 Fri November 5 17 05 17 12 3 Friday 1 11 Nov 11 +0800 RFC822 Fri, 03 Nov 1972 17:12:52 +0800 52 30 89629972 5 72 1972 307 28800 2003" (date len=170)
  "date CST 1972-11-03 17:12:52 pm PM 03 Fri November 5 17 05 17 12 3 Friday 1 11 Nov 11 +0800 RFC822 Fri,  3 Nov 1972 17:12:52 +0800 52 30 89629972 5 72 1972 307 28800 2003" (adodb_date len=170)

02 Aug 1976 19:18:49 +0800 49 31 207832729 1 76 1976 214 28800 2003 Error date(): 207832729
 
  "date CST 1976-08-02 19:18:49 pm PM 02 Mon August 7 19 07 19 18 2 Monday 1 08 Aug 8 +0800 RFC822 Mon, 02 Aug 1976 19:18:49 +0800 49 31 207832729 1 76 1976 214 28800 2003" (date len=168)
  "date CST 1976-08-02 19:18:49 pm PM 02 Mon August 7 19 07 19 18 2 Monday 1 08 Aug 8 +0800 RFC822 Mon,  2 Aug 1976 19:18:49 +0800 49 31 207832729 1 76 1976 214 28800 2003" (adodb_date len=168)

DT 1974-04-30 20:58:26 pm PM 30 Tue April 8 20 08 20 58 30 Tuesday 0 04 Apr 4 +0900 RFC822 Tue, 30 Apr 1974 20:58:26 +0900 26 30 136555106 2 74 1974 119 32400 2003 Error date(): 136555106
 
  "date CDT 1974-04-30 20:58:26 pm PM 30 Tue April 8 20 08 20 58 30 Tuesday 0 04 Apr 4 +0900 RFC822 Tue, 30 Apr 1974 20:58:26 +0900 26 30 136555106 2 74 1974 119 32400 2003" (date len=169)
  "date CST 1974-04-30 19:58:26 pm PM 30 Tue April 7 19 07 19 58 30 Tuesday 0 04 Apr 4 +0800 RFC822 Tue, 30 Apr 1974 19:58:26 +0800 26 30 136555106 2 74 1974 119 28800 2003" (adodb_date len=169)

Error getdate() 136555106
Array ( [seconds] => 26 [minutes] => 58 [hours] => 20 [mday] => 30 [wday] => 2 [mon] => 4 [year] => 1974 [yday] => 119 [weekday] => Tuesday [month] => April [0] => 136555106 )
Array ( [seconds] => 26 [minutes] => 58 [hours] => 19 [mday] => 30 [wday] => 2 [mon] => 4 [year] => 1974 [yday] => 119 [weekday] => Tuesday [month] => April [0] => 136555106 )

04 Feb 1979 20:58:00 +0800 00 28 286981080 0 79 1979 34 28800 2003 Error date(): 286981080

 
  "date CST 1979-02-04 20:58:00 pm PM 04 Sun February 8 20 08 20 58 4 Sunday 0 02 Feb 2 +0800 RFC822 Sun, 04 Feb 1979 20:58:00 +0800 00 28 286981080 0 79 1979 34 28800 2003" (date len=169)
  "date CST 1979-02-04 20:58:00 pm PM 04 Sun February 8 20 08 20 58 4 Sunday 0 02 Feb 2 +0800 RFC822 Sun,  4 Feb 1979 20:58:00 +0800 00 28 286981080 0 79 1979 34 28800 2003" (adodb_date len=169)

04 Aug 1977 15:48:05 +0800 05 31 239528885 4 77 1977 215 28800 2003 Error date(): 239528885
 
  "date CST 1977-08-04 15:48:05 pm PM 04 Thu August 3 15 03 15 48 4 Thursday 0 08 Aug 8 +0800 RFC822 Thu, 04 Aug 1977 15:48:05 +0800 05 31 239528885 4 77 1977 215 28800 2003" (date len=170)
  "date CST 1977-08-04 15:48:05 pm PM 04 Thu August 3 15 03 15 48 4 Thursday 0 08 Aug 8 +0800 RFC822 Thu,  4 Aug 1977 15:48:05 +0800 05 31 239528885 4 77 1977 215 28800 2003" (adodb_date len=170)

DT 1975-04-27 18:03:54 pm PM 27 Sun April 6 18 06 18 03 27 Sunday 0 04 Apr 4 +0900 RFC822 Sun, 27 Apr 1975 18:03:54 +0900 54 30 167821434 0 75 1975 116 32400 2003 Error date(): 167821434
 
  "date CDT 1975-04-27 18:03:54 pm PM 27 Sun April 6 18 06 18 03 27 Sunday 0 04 Apr 4 +0900 RFC822 Sun, 27 Apr 1975 18:03:54 +0900 54 30 167821434 0 75 1975 116 32400 2003" (date len=168)
  "date CST 1975-04-27 17:03:54 pm PM 27 Sun April 5 17 05 17 03 27 Sunday 0 04 Apr 4 +0800 RFC822 Sun, 27 Apr 1975 17:03:54 +0800 54 30 167821434 0 75 1975 116 28800 2003" (adodb_date len=168)

Error getdate() 167821434
Array ( [seconds] => 54 [minutes] => 3 [hours] => 18 [mday] => 27 [wday] => 0 [mon] => 4 [year] => 1975 [yday] => 116 [weekday] => Sunday [month] => April [0] => 167821434 )
Array ( [seconds] => 54 [minutes] => 3 [hours] => 17 [mday] => 27 [wday] => 0 [mon] => 4 [year] => 1975 [yday] => 116 [weekday] => Sunday [month] => April [0] => 167821434 )

07 Oct 1977 18:55:39 +0800 39 31 245069739 5 77 1977 279 28800 2003 Error date(): 245069739

 
  "date CST 1977-10-07 18:55:39 pm PM 07 Fri October 6 18 06 18 55 7 Friday 0 10 Oct 10 +0800 RFC822 Fri, 07 Oct 1977 18:55:39 +0800 39 31 245069739 5 77 1977 279 28800 2003" (date len=170)
  "date CST 1977-10-07 18:55:39 pm PM 07 Fri October 6 18 06 18 55 7 Friday 0 10 Oct 10 +0800 RFC822 Fri,  7 Oct 1977 18:55:39 +0800 39 31 245069739 5 77 1977 279 28800 2003" (adodb_date len=170)

04 Oct 1970 11:58:14 +0800 14 31 23860694 0 70 1970 276 28800 2003 Error date(): 23860694
 
  "date CST 1970-10-04 11:58:14 am AM 04 Sun October 11 11 11 11 58 4 Sunday 0 10 Oct 10 +0800 RFC822 Sun, 04 Oct 1970 11:58:14 +0800 14 31 23860694 0 70 1970 276 28800 2003" (date len=170)
  "date CST 1970-10-04 11:58:14 am AM 04 Sun October 11 11 11 11 58 4 Sunday 0 10 Oct 10 +0800 RFC822 Sun,  4 Oct 1970 11:58:14 +0800 14 31 23860694 0 70 1970 276 28800 2003" (adodb_date len=170)

Testing random dates between 100 and 4000

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

Failed :-(

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