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
DT 1975-06-06 02:20:27 am AM 06 Fri June 2 2 02 02 20 6 Friday 0 06 Jun 6 +0900 RFC822 Fri, 06 Jun 1975 02:20:27 +0900 27 30 171220827 5 75 1975 156 32400 2003 Error date(): 171220827
 
  "date CDT 1975-06-06 02:20:27 am AM 06 Fri June 2 2 02 02 20 6 Friday 0 06 Jun 6 +0900 RFC822 Fri, 06 Jun 1975 02:20:27 +0900 27 30 171220827 5 75 1975 156 32400 2003" (date len=165)
  "date CST 1975-06-06 01:20:27 am AM 06 Fri June 1 1 01 01 20 6 Friday 0 06 Jun 6 +0800 RFC822 Fri,  6 Jun 1975 01:20:27 +0800 27 30 171220827 5 75 1975 156 28800 2003" (adodb_date len=165)

Error getdate() 171220827
Array ( [seconds] => 27 [minutes] => 20 [hours] => 2 [mday] => 6 [wday] => 5 [mon] => 6 [year] => 1975 [yday] => 156 [weekday] => Friday [month] => June [0] => 171220827 )
Array ( [seconds] => 27 [minutes] => 20 [hours] => 1 [mday] => 6 [wday] => 5 [mon] => 6 [year] => 1975 [yday] => 156 [weekday] => Friday [month] => June [0] => 171220827 )

01 Jun 1977 05:46:11 +0800 11 30 233963171 3 77 1977 151 28800 2003 Error date(): 233963171

 
  "date CST 1977-06-01 05:46:11 am AM 01 Wed June 5 5 05 05 46 1 Wednesday 0 06 Jun 6 +0800 RFC822 Wed, 01 Jun 1977 05:46:11 +0800 11 30 233963171 3 77 1977 151 28800 2003" (date len=168)
  "date CST 1977-06-01 05:46:11 am AM 01 Wed June 5 5 05 05 46 1 Wednesday 0 06 Jun 6 +0800 RFC822 Wed,  1 Jun 1977 05:46:11 +0800 11 30 233963171 3 77 1977 151 28800 2003" (adodb_date len=168)

03 Dec 1975 09:24:44 +0800 44 31 186801884 3 75 1975 336 28800 2003 Error date(): 186801884
 
  "date CST 1975-12-03 09:24:44 am AM 03 Wed December 9 9 09 09 24 3 Wednesday 0 12 Dec 12 +0800 RFC822 Wed, 03 Dec 1975 09:24:44 +0800 44 31 186801884 3 75 1975 336 28800 2003" (date len=173)
  "date CST 1975-12-03 09:24:44 am AM 03 Wed December 9 9 09 09 24 3 Wednesday 0 12 Dec 12 +0800 RFC822 Wed,  3 Dec 1975 09:24:44 +0800 44 31 186801884 3 75 1975 336 28800 2003" (adodb_date len=173)

09 Jul 1982 18:02:46 +0800 46 31 395056966 5 82 1982 189 28800 2003 Error date(): 395056966
 
  "date CST 1982-07-09 18:02:46 pm PM 09 Fri July 6 18 06 18 02 9 Friday 0 07 Jul 7 +0800 RFC822 Fri, 09 Jul 1982 18:02:46 +0800 46 31 395056966 5 82 1982 189 28800 2003" (date len=166)
  "date CST 1982-07-09 18:02:46 pm PM 09 Fri July 6 18 06 18 02 9 Friday 0 07 Jul 7 +0800 RFC822 Fri,  9 Jul 1982 18:02:46 +0800 46 31 395056966 5 82 1982 189 28800 2003" (adodb_date len=166)

DT 1975-07-19 01:18:19 am AM 19 Sat July 1 1 01 01 18 19 Saturday 0 07 Jul 7 +0900 RFC822 Sat, 19 Jul 1975 01:18:19 +0900 19 31 174932299 6 75 1975 199 32400 2003 Error date(): 174932299
 
  "date CDT 1975-07-19 01:18:19 am AM 19 Sat July 1 1 01 01 18 19 Saturday 0 07 Jul 7 +0900 RFC822 Sat, 19 Jul 1975 01:18:19 +0900 19 31 174932299 6 75 1975 199 32400 2003" (date len=168)
  "date CST 1975-07-19 00:18:19 am AM 19 Sat July 12 0 12 00 18 19 Saturday 0 07 Jul 7 +0800 RFC822 Sat, 19 Jul 1975 00:18:19 +0800 19 31 174932299 6 75 1975 199 28800 2003" (adodb_date len=169)

Error getdate() 174932299
Array ( [seconds] => 19 [minutes] => 18 [hours] => 1 [mday] => 19 [wday] => 6 [mon] => 7 [year] => 1975 [yday] => 199 [weekday] => Saturday [month] => July [0] => 174932299 )
Array ( [seconds] => 19 [minutes] => 18 [hours] => 0 [mday] => 19 [wday] => 6 [mon] => 7 [year] => 1975 [yday] => 199 [weekday] => Saturday [month] => July [0] => 174932299 )

05 Jun 1977 12:36:57 +0800 57 30 234333417 0 77 1977 155 28800 2003 Error date(): 234333417

 
  "date CST 1977-06-05 12:36:57 pm PM 05 Sun June 12 12 12 12 36 5 Sunday 0 06 Jun 6 +0800 RFC822 Sun, 05 Jun 1977 12:36:57 +0800 57 30 234333417 0 77 1977 155 28800 2003" (date len=167)
  "date CST 1977-06-05 12:36:57 pm PM 05 Sun June 12 12 12 12 36 5 Sunday 0 06 Jun 6 +0800 RFC822 Sun,  5 Jun 1977 12:36:57 +0800 57 30 234333417 0 77 1977 155 28800 2003" (adodb_date len=167)

05 Dec 1975 11:38:09 +0800 09 31 186982689 5 75 1975 338 28800 2003 Error date(): 186982689
 
  "date CST 1975-12-05 11:38:09 am AM 05 Fri December 11 11 11 11 38 5 Friday 0 12 Dec 12 +0800 RFC822 Fri, 05 Dec 1975 11:38:09 +0800 09 31 186982689 5 75 1975 338 28800 2003" (date len=172)
  "date CST 1975-12-05 11:38:09 am AM 05 Fri December 11 11 11 11 38 5 Friday 0 12 Dec 12 +0800 RFC822 Fri,  5 Dec 1975 11:38:09 +0800 09 31 186982689 5 75 1975 338 28800 2003" (adodb_date len=172)

03 Aug 1977 16:07:58 +0800 58 31 239443678 3 77 1977 214 28800 2003 Error date(): 239443678
 
  "date CST 1977-08-03 16:07:58 pm PM 03 Wed August 4 16 04 16 07 3 Wednesday 0 08 Aug 8 +0800 RFC822 Wed, 03 Aug 1977 16:07:58 +0800 58 31 239443678 3 77 1977 214 28800 2003" (date len=171)
  "date CST 1977-08-03 16:07:58 pm PM 03 Wed August 4 16 04 16 07 3 Wednesday 0 08 Aug 8 +0800 RFC822 Wed,  3 Aug 1977 16:07:58 +0800 58 31 239443678 3 77 1977 214 28800 2003" (adodb_date len=171)

06 Jun 1980 15:52:51 +0800 51 30 329125971 5 80 1980 157 28800 2003 Error date(): 329125971
 
  "date CST 1980-06-06 15:52:51 pm PM 06 Fri June 3 15 03 15 52 6 Friday 1 06 Jun 6 +0800 RFC822 Fri, 06 Jun 1980 15:52:51 +0800 51 30 329125971 5 80 1980 157 28800 2003" (date len=166)
  "date CST 1980-06-06 15:52:51 pm PM 06 Fri June 3 15 03 15 52 6 Friday 1 06 Jun 6 +0800 RFC822 Fri,  6 Jun 1980 15:52:51 +0800 51 30 329125971 5 80 1980 157 28800 2003" (adodb_date len=166)

03 May 1976 12:02:24 +0800 24 31 199944144 1 76 1976 123 28800 2003 Error date(): 199944144
 
  "date CST 1976-05-03 12:02:24 pm PM 03 Mon May 12 12 12 12 02 3 Monday 1 05 May 5 +0800 RFC822 Mon, 03 May 1976 12:02:24 +0800 24 31 199944144 1 76 1976 123 28800 2003" (date len=166)
  "date CST 1976-05-03 12:02:24 pm PM 03 Mon May 12 12 12 12 02 3 Monday 1 05 May 5 +0800 RFC822 Mon,  3 May 1976 12:02:24 +0800 24 31 199944144 1 76 1976 123 28800 2003" (adodb_date len=166)

09 Nov 1978 04:22:01 +0800 01 30 279404521 4 78 1978 312 28800 2003 Error date(): 279404521
 
  "date CST 1978-11-09 04:22:01 am AM 09 Thu November 4 4 04 04 22 9 Thursday 0 11 Nov 11 +0800 RFC822 Thu, 09 Nov 1978 04:22:01 +0800 01 30 279404521 4 78 1978 312 28800 2003" (date len=172)
  "date CST 1978-11-09 04:22:01 am AM 09 Thu November 4 4 04 04 22 9 Thursday 0 11 Nov 11 +0800 RFC822 Thu,  9 Nov 1978 04:22:01 +0800 01 30 279404521 4 78 1978 312 28800 2003" (adodb_date len=172)

DT 1974-07-26 09:48:53 am AM 26 Fri July 9 9 09 09 48 26 Friday 0 07 Jul 7 +0900 RFC822 Fri, 26 Jul 1974 09:48:53 +0900 53 31 144031733 5 74 1974 206 32400 2003 Error date(): 144031733
 
  "date CDT 1974-07-26 09:48:53 am AM 26 Fri July 9 9 09 09 48 26 Friday 0 07 Jul 7 +0900 RFC822 Fri, 26 Jul 1974 09:48:53 +0900 53 31 144031733 5 74 1974 206 32400 2003" (date len=166)
  "date CST 1974-07-26 08:48:53 am AM 26 Fri July 8 8 08 08 48 26 Friday 0 07 Jul 7 +0800 RFC822 Fri, 26 Jul 1974 08:48:53 +0800 53 31 144031733 5 74 1974 206 28800 2003" (adodb_date len=166)

Error getdate() 144031733
Array ( [seconds] => 53 [minutes] => 48 [hours] => 9 [mday] => 26 [wday] => 5 [mon] => 7 [year] => 1974 [yday] => 206 [weekday] => Friday [month] => July [0] => 144031733 )
Array ( [seconds] => 53 [minutes] => 48 [hours] => 8 [mday] => 26 [wday] => 5 [mon] => 7 [year] => 1974 [yday] => 206 [weekday] => Friday [month] => July [0] => 144031733 )

02 Mar 1978 13:08:20 +0800 20 31 257663300 4 78 1978 60 28800 2003 Error date(): 257663300

 
  "date CST 1978-03-02 13:08:20 pm PM 02 Thu March 1 13 01 13 08 2 Thursday 0 03 Mar 3 +0800 RFC822 Thu, 02 Mar 1978 13:08:20 +0800 20 31 257663300 4 78 1978 60 28800 2003" (date len=168)
  "date CST 1978-03-02 13:08:20 pm PM 02 Thu March 1 13 01 13 08 2 Thursday 0 03 Mar 3 +0800 RFC822 Thu,  2 Mar 1978 13:08:20 +0800 20 31 257663300 4 78 1978 60 28800 2003" (adodb_date len=168)

08 Sep 1981 00:34:05 +0800 05 30 368728445 2 81 1981 250 28800 2003 Error date(): 368728445
 
  "date CST 1981-09-08 00:34:05 am AM 08 Tue September 12 0 12 00 34 8 Tuesday 0 09 Sep 9 +0800 RFC822 Tue, 08 Sep 1981 00:34:05 +0800 05 30 368728445 2 81 1981 250 28800 2003" (date len=172)
  "date CST 1981-09-08 00:34:05 am AM 08 Tue September 12 0 12 00 34 8 Tuesday 0 09 Sep 9 +0800 RFC822 Tue,  8 Sep 1981 00:34:05 +0800 05 30 368728445 2 81 1981 250 28800 2003" (adodb_date len=172)

04 Aug 1973 01:43:14 +0800 14 31 113247794 6 73 1973 215 28800 2003 Error date(): 113247794
 
  "date CST 1973-08-04 01:43:14 am AM 04 Sat August 1 1 01 01 43 4 Saturday 0 08 Aug 8 +0800 RFC822 Sat, 04 Aug 1973 01:43:14 +0800 14 31 113247794 6 73 1973 215 28800 2003" (date len=169)
  "date CST 1973-08-04 01:43:14 am AM 04 Sat August 1 1 01 01 43 4 Saturday 0 08 Aug 8 +0800 RFC822 Sat,  4 Aug 1973 01:43:14 +0800 14 31 113247794 6 73 1973 215 28800 2003" (adodb_date len=169)

DT 1975-08-12 07:53:43 am AM 12 Tue August 7 7 07 07 53 12 Tuesday 0 08 Aug 8 +0900 RFC822 Tue, 12 Aug 1975 07:53:43 +0900 43 31 177029623 2 75 1975 223 32400 2003 Error date(): 177029623
 
  "date CDT 1975-08-12 07:53:43 am AM 12 Tue August 7 7 07 07 53 12 Tuesday 0 08 Aug 8 +0900 RFC822 Tue, 12 Aug 1975 07:53:43 +0900 43 31 177029623 2 75 1975 223 32400 2003" (date len=169)
  "date CST 1975-08-12 06:53:43 am AM 12 Tue August 6 6 06 06 53 12 Tuesday 0 08 Aug 8 +0800 RFC822 Tue, 12 Aug 1975 06:53:43 +0800 43 31 177029623 2 75 1975 223 28800 2003" (adodb_date len=169)

Error getdate() 177029623
Array ( [seconds] => 43 [minutes] => 53 [hours] => 7 [mday] => 12 [wday] => 2 [mon] => 8 [year] => 1975 [yday] => 223 [weekday] => Tuesday [month] => August [0] => 177029623 )
Array ( [seconds] => 43 [minutes] => 53 [hours] => 6 [mday] => 12 [wday] => 2 [mon] => 8 [year] => 1975 [yday] => 223 [weekday] => Tuesday [month] => August [0] => 177029623 )

02 May 1973 03:21:22 +0800 22 31 105132082 3 73 1973 121 28800 2003 Error date(): 105132082

 
  "date CST 1973-05-02 03:21:22 am AM 02 Wed May 3 3 03 03 21 2 Wednesday 0 05 May 5 +0800 RFC822 Wed, 02 May 1973 03:21:22 +0800 22 31 105132082 3 73 1973 121 28800 2003" (date len=167)
  "date CST 1973-05-02 03:21:22 am AM 02 Wed May 3 3 03 03 21 2 Wednesday 0 05 May 5 +0800 RFC822 Wed,  2 May 1973 03:21:22 +0800 22 31 105132082 3 73 1973 121 28800 2003" (adodb_date len=167)

05 Dec 1972 12:20:11 +0800 11 31 92377211 2 72 1972 339 28800 2003 Error date(): 92377211
 
  "date CST 1972-12-05 12:20:11 pm PM 05 Tue December 12 12 12 12 20 5 Tuesday 1 12 Dec 12 +0800 RFC822 Tue, 05 Dec 1972 12:20:11 +0800 11 31 92377211 2 72 1972 339 28800 2003" (date len=172)
  "date CST 1972-12-05 12:20:11 pm PM 05 Tue December 12 12 12 12 20 5 Tuesday 1 12 Dec 12 +0800 RFC822 Tue,  5 Dec 1972 12:20:11 +0800 11 31 92377211 2 72 1972 339 28800 2003" (adodb_date len=172)

03 Apr 1977 19:01:06 +0800 06 30 228913266 0 77 1977 92 28800 2003 Error date(): 228913266
 
  "date CST 1977-04-03 19:01:06 pm PM 03 Sun April 7 19 07 19 01 3 Sunday 0 04 Apr 4 +0800 RFC822 Sun, 03 Apr 1977 19:01:06 +0800 06 30 228913266 0 77 1977 92 28800 2003" (date len=166)
  "date CST 1977-04-03 19:01:06 pm PM 03 Sun April 7 19 07 19 01 3 Sunday 0 04 Apr 4 +0800 RFC822 Sun,  3 Apr 1977 19:01:06 +0800 06 30 228913266 0 77 1977 92 28800 2003" (adodb_date len=166)

DT 1979-09-22 22:19:04 pm PM 22 Sat September 10 22 10 22 19 22 Saturday 0 09 Sep 9 +0900 RFC822 Sat, 22 Sep 1979 22:19:04 +0900 04 30 306854344 6 79 1979 264 32400 2003 Error date(): 306854344
 
  "date CDT 1979-09-22 22:19:04 pm PM 22 Sat September 10 22 10 22 19 22 Saturday 0 09 Sep 9 +0900 RFC822 Sat, 22 Sep 1979 22:19:04 +0900 04 30 306854344 6 79 1979 264 32400 2003" (date len=175)
  "date CST 1979-09-22 21:19:04 pm PM 22 Sat September 9 21 09 21 19 22 Saturday 0 09 Sep 9 +0800 RFC822 Sat, 22 Sep 1979 21:19:04 +0800 04 30 306854344 6 79 1979 264 28800 2003" (adodb_date len=174)

07 Oct 1978 13:20:04 +0800 04 31 276585604 6 78 1978 279 28800 2003 Error date(): 276585604
 
  "date CST 1978-10-07 13:20:04 pm PM 07 Sat October 1 13 01 13 20 7 Saturday 0 10 Oct 10 +0800 RFC822 Sat, 07 Oct 1978 13:20:04 +0800 04 31 276585604 6 78 1978 279 28800 2003" (date len=172)
  "date CST 1978-10-07 13:20:04 pm PM 07 Sat October 1 13 01 13 20 7 Saturday 0 10 Oct 10 +0800 RFC822 Sat,  7 Oct 1978 13:20:04 +0800 04 31 276585604 6 78 1978 279 28800 2003" (adodb_date len=172)

DT 1975-06-10 22:48:41 pm PM 10 Tue June 10 22 10 22 48 10 Tuesday 0 06 Jun 6 +0900 RFC822 Tue, 10 Jun 1975 22:48:41 +0900 41 30 171640121 2 75 1975 160 32400 2003 Error date(): 171640121
 
  "date CDT 1975-06-10 22:48:41 pm PM 10 Tue June 10 22 10 22 48 10 Tuesday 0 06 Jun 6 +0900 RFC822 Tue, 10 Jun 1975 22:48:41 +0900 41 30 171640121 2 75 1975 160 32400 2003" (date len=169)
  "date CST 1975-06-10 21:48:41 pm PM 10 Tue June 9 21 09 21 48 10 Tuesday 0 06 Jun 6 +0800 RFC822 Tue, 10 Jun 1975 21:48:41 +0800 41 30 171640121 2 75 1975 160 28800 2003" (adodb_date len=168)

Error getdate() 171640121
Array ( [seconds] => 41 [minutes] => 48 [hours] => 22 [mday] => 10 [wday] => 2 [mon] => 6 [year] => 1975 [yday] => 160 [weekday] => Tuesday [month] => June [0] => 171640121 )
Array ( [seconds] => 41 [minutes] => 48 [hours] => 21 [mday] => 10 [wday] => 2 [mon] => 6 [year] => 1975 [yday] => 160 [weekday] => Tuesday [month] => June [0] => 171640121 )

DT 1975-04-23 04:33:34 am AM 23 Wed April 4 4 04 04 33 23 Wednesday 0 04 Apr 4 +0900 RFC822 Wed, 23 Apr 1975 04:33:34 +0900 34 30 167427214 3 75 1975 112 32400 2003 Error date(): 167427214

 
  "date CDT 1975-04-23 04:33:34 am AM 23 Wed April 4 4 04 04 33 23 Wednesday 0 04 Apr 4 +0900 RFC822 Wed, 23 Apr 1975 04:33:34 +0900 34 30 167427214 3 75 1975 112 32400 2003" (date len=170)
  "date CST 1975-04-23 03:33:34 am AM 23 Wed April 3 3 03 03 33 23 Wednesday 0 04 Apr 4 +0800 RFC822 Wed, 23 Apr 1975 03:33:34 +0800 34 30 167427214 3 75 1975 112 28800 2003" (adodb_date len=170)

07 Oct 1974 04:06:14 +0800 14 31 150321974 1 74 1974 279 28800 2003 Error date(): 150321974
 
  "date CST 1974-10-07 04:06:14 am AM 07 Mon October 4 4 04 04 06 7 Monday 0 10 Oct 10 +0800 RFC822 Mon, 07 Oct 1974 04:06:14 +0800 14 31 150321974 1 74 1974 279 28800 2003" (date len=169)
  "date CST 1974-10-07 04:06:14 am AM 07 Mon October 4 4 04 04 06 7 Monday 0 10 Oct 10 +0800 RFC822 Mon,  7 Oct 1974 04:06:14 +0800 14 31 150321974 1 74 1974 279 28800 2003" (adodb_date len=169)

DT 1979-09-07 23:33:00 pm PM 07 Fri September 11 23 11 23 33 7 Friday 0 09 Sep 9 +0900 RFC822 Fri, 07 Sep 1979 23:33:00 +0900 00 30 305562780 5 79 1979 249 32400 2003 Error date(): 305562780
 
  "date CDT 1979-09-07 23:33:00 pm PM 07 Fri September 11 23 11 23 33 7 Friday 0 09 Sep 9 +0900 RFC822 Fri, 07 Sep 1979 23:33:00 +0900 00 30 305562780 5 79 1979 249 32400 2003" (date len=172)
  "date CST 1979-09-07 22:33:00 pm PM 07 Fri September 10 22 10 22 33 7 Friday 0 09 Sep 9 +0800 RFC822 Fri,  7 Sep 1979 22:33:00 +0800 00 30 305562780 5 79 1979 249 28800 2003" (adodb_date len=172)

Error getdate() 305562780
Array ( [seconds] => 0 [minutes] => 33 [hours] => 23 [mday] => 7 [wday] => 5 [mon] => 9 [year] => 1979 [yday] => 249 [weekday] => Friday [month] => September [0] => 305562780 )
Array ( [seconds] => 0 [minutes] => 33 [hours] => 22 [mday] => 7 [wday] => 5 [mon] => 9 [year] => 1979 [yday] => 249 [weekday] => Friday [month] => September [0] => 305562780 )

DT 1975-06-15 01:37:49 am AM 15 Sun June 1 1 01 01 37 15 Sunday 0 06 Jun 6 +0900 RFC822 Sun, 15 Jun 1975 01:37:49 +0900 49 30 171995869 0 75 1975 165 32400 2003 Error date(): 171995869

 
  "date CDT 1975-06-15 01:37:49 am AM 15 Sun June 1 1 01 01 37 15 Sunday 0 06 Jun 6 +0900 RFC822 Sun, 15 Jun 1975 01:37:49 +0900 49 30 171995869 0 75 1975 165 32400 2003" (date len=166)
  "date CST 1975-06-15 00:37:49 am AM 15 Sun June 12 0 12 00 37 15 Sunday 0 06 Jun 6 +0800 RFC822 Sun, 15 Jun 1975 00:37:49 +0800 49 30 171995869 0 75 1975 165 28800 2003" (adodb_date len=167)

Error getdate() 171995869
Array ( [seconds] => 49 [minutes] => 37 [hours] => 1 [mday] => 15 [wday] => 0 [mon] => 6 [year] => 1975 [yday] => 165 [weekday] => Sunday [month] => June [0] => 171995869 )
Array ( [seconds] => 49 [minutes] => 37 [hours] => 0 [mday] => 15 [wday] => 0 [mon] => 6 [year] => 1975 [yday] => 165 [weekday] => Sunday [month] => June [0] => 171995869 )

DT 1975-04-21 22:10:36 pm PM 21 Mon April 10 22 10 22 10 21 Monday 0 04 Apr 4 +0900 RFC822 Mon, 21 Apr 1975 22:10:36 +0900 36 30 167317836 1 75 1975 110 32400 2003 Error date(): 167317836

 
  "date CDT 1975-04-21 22:10:36 pm PM 21 Mon April 10 22 10 22 10 21 Monday 0 04 Apr 4 +0900 RFC822 Mon, 21 Apr 1975 22:10:36 +0900 36 30 167317836 1 75 1975 110 32400 2003" (date len=169)
  "date CST 1975-04-21 21:10:36 pm PM 21 Mon April 9 21 09 21 10 21 Monday 0 04 Apr 4 +0800 RFC822 Mon, 21 Apr 1975 21:10:36 +0800 36 30 167317836 1 75 1975 110 28800 2003" (adodb_date len=168)

Error getdate() 167317836
Array ( [seconds] => 36 [minutes] => 10 [hours] => 22 [mday] => 21 [wday] => 1 [mon] => 4 [year] => 1975 [yday] => 110 [weekday] => Monday [month] => April [0] => 167317836 )
Array ( [seconds] => 36 [minutes] => 10 [hours] => 21 [mday] => 21 [wday] => 1 [mon] => 4 [year] => 1975 [yday] => 110 [weekday] => Monday [month] => April [0] => 167317836 )

01 Aug 1973 14:48:22 +0800 22 31 113035702 3 73 1973 212 28800 2003 Error date(): 113035702

 
  "date CST 1973-08-01 14:48:22 pm PM 01 Wed August 2 14 02 14 48 1 Wednesday 0 08 Aug 8 +0800 RFC822 Wed, 01 Aug 1973 14:48:22 +0800 22 31 113035702 3 73 1973 212 28800 2003" (date len=171)
  "date CST 1973-08-01 14:48:22 pm PM 01 Wed August 2 14 02 14 48 1 Wednesday 0 08 Aug 8 +0800 RFC822 Wed,  1 Aug 1973 14:48:22 +0800 22 31 113035702 3 73 1973 212 28800 2003" (adodb_date len=171)

06 Aug 1971 14:39:35 +0800 35 31 50308775 5 71 1971 217 28800 2003 Error date(): 50308775
 
  "date CST 1971-08-06 14:39:35 pm PM 06 Fri August 2 14 02 14 39 6 Friday 0 08 Aug 8 +0800 RFC822 Fri, 06 Aug 1971 14:39:35 +0800 35 31 50308775 5 71 1971 217 28800 2003" (date len=167)
  "date CST 1971-08-06 14:39:35 pm PM 06 Fri August 2 14 02 14 39 6 Friday 0 08 Aug 8 +0800 RFC822 Fri,  6 Aug 1971 14:39:35 +0800 35 31 50308775 5 71 1971 217 28800 2003" (adodb_date len=167)

02 Jan 1979 13:21:38 +0800 38 31 284102498 2 79 1979 1 28800 2003 Error date(): 284102498
 
  "date CST 1979-01-02 13:21:38 pm PM 02 Tue January 1 13 01 13 21 2 Tuesday 0 01 Jan 1 +0800 RFC822 Tue, 02 Jan 1979 13:21:38 +0800 38 31 284102498 2 79 1979 1 28800 2003" (date len=168)
  "date CST 1979-01-02 13:21:38 pm PM 02 Tue January 1 13 01 13 21 2 Tuesday 0 01 Jan 1 +0800 RFC822 Tue,  2 Jan 1979 13:21:38 +0800 38 31 284102498 2 79 1979 1 28800 2003" (adodb_date len=168)

DT 1975-08-16 06:56:21 am AM 16 Sat August 6 6 06 06 56 16 Saturday 0 08 Aug 8 +0900 RFC822 Sat, 16 Aug 1975 06:56:21 +0900 21 31 177371781 6 75 1975 227 32400 2003 Error date(): 177371781
 
  "date CDT 1975-08-16 06:56:21 am AM 16 Sat August 6 6 06 06 56 16 Saturday 0 08 Aug 8 +0900 RFC822 Sat, 16 Aug 1975 06:56:21 +0900 21 31 177371781 6 75 1975 227 32400 2003" (date len=170)
  "date CST 1975-08-16 05:56:21 am AM 16 Sat August 5 5 05 05 56 16 Saturday 0 08 Aug 8 +0800 RFC822 Sat, 16 Aug 1975 05:56:21 +0800 21 31 177371781 6 75 1975 227 28800 2003" (adodb_date len=170)

06 Apr 1977 23:21:17 +0800 17 30 229188077 3 77 1977 95 28800 2003 Error date(): 229188077
 
  "date CST 1977-04-06 23:21:17 pm PM 06 Wed April 11 23 11 23 21 6 Wednesday 0 04 Apr 4 +0800 RFC822 Wed, 06 Apr 1977 23:21:17 +0800 17 30 229188077 3 77 1977 95 28800 2003" (date len=170)
  "date CST 1977-04-06 23:21:17 pm PM 06 Wed April 11 23 11 23 21 6 Wednesday 0 04 Apr 4 +0800 RFC822 Wed,  6 Apr 1977 23:21:17 +0800 17 30 229188077 3 77 1977 95 28800 2003" (adodb_date len=170)

02 Dec 1980 17:58:36 +0800 36 31 344599116 2 80 1980 336 28800 2003 Error date(): 344599116
 
  "date CST 1980-12-02 17:58:36 pm PM 02 Tue December 5 17 05 17 58 2 Tuesday 1 12 Dec 12 +0800 RFC822 Tue, 02 Dec 1980 17:58:36 +0800 36 31 344599116 2 80 1980 336 28800 2003" (date len=172)
  "date CST 1980-12-02 17:58:36 pm PM 02 Tue December 5 17 05 17 58 2 Tuesday 1 12 Dec 12 +0800 RFC822 Tue,  2 Dec 1980 17:58:36 +0800 36 31 344599116 2 80 1980 336 28800 2003" (adodb_date len=172)

DT 1974-05-12 15:15:57 pm PM 12 Sun May 3 15 03 15 15 12 Sunday 0 05 May 5 +0900 RFC822 Sun, 12 May 1974 15:15:57 +0900 57 31 137571357 0 74 1974 131 32400 2003 Error date(): 137571357
 
  "date CDT 1974-05-12 15:15:57 pm PM 12 Sun May 3 15 03 15 15 12 Sunday 0 05 May 5 +0900 RFC822 Sun, 12 May 1974 15:15:57 +0900 57 31 137571357 0 74 1974 131 32400 2003" (date len=166)
  "date CST 1974-05-12 14:15:57 pm PM 12 Sun May 2 14 02 14 15 12 Sunday 0 05 May 5 +0800 RFC822 Sun, 12 May 1974 14:15:57 +0800 57 31 137571357 0 74 1974 131 28800 2003" (adodb_date len=166)

08 Mar 1977 22:37:12 +0800 12 31 226679832 2 77 1977 66 28800 2003 Error date(): 226679832
 
  "date CST 1977-03-08 22:37:12 pm PM 08 Tue March 10 22 10 22 37 8 Tuesday 0 03 Mar 3 +0800 RFC822 Tue, 08 Mar 1977 22:37:12 +0800 12 31 226679832 2 77 1977 66 28800 2003" (date len=168)
  "date CST 1977-03-08 22:37:12 pm PM 08 Tue March 10 22 10 22 37 8 Tuesday 0 03 Mar 3 +0800 RFC822 Tue,  8 Mar 1977 22:37:12 +0800 12 31 226679832 2 77 1977 66 28800 2003" (adodb_date len=168)

DT 1974-04-29 16:50:01 pm PM 29 Mon April 4 16 04 16 50 29 Monday 0 04 Apr 4 +0900 RFC822 Mon, 29 Apr 1974 16:50:01 +0900 01 30 136453801 1 74 1974 118 32400 2003 Error date(): 136453801
 
  "date CDT 1974-04-29 16:50:01 pm PM 29 Mon April 4 16 04 16 50 29 Monday 0 04 Apr 4 +0900 RFC822 Mon, 29 Apr 1974 16:50:01 +0900 01 30 136453801 1 74 1974 118 32400 2003" (date len=168)
  "date CST 1974-04-29 15:50:01 pm PM 29 Mon April 3 15 03 15 50 29 Monday 0 04 Apr 4 +0800 RFC822 Mon, 29 Apr 1974 15:50:01 +0800 01 30 136453801 1 74 1974 118 28800 2003" (adodb_date len=168)

Error getdate() 136453801
Array ( [seconds] => 1 [minutes] => 50 [hours] => 16 [mday] => 29 [wday] => 1 [mon] => 4 [year] => 1974 [yday] => 118 [weekday] => Monday [month] => April [0] => 136453801 )
Array ( [seconds] => 1 [minutes] => 50 [hours] => 15 [mday] => 29 [wday] => 1 [mon] => 4 [year] => 1974 [yday] => 118 [weekday] => Monday [month] => April [0] => 136453801 )

Testing random dates between 100 and 4000

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

Failed :-(

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