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 1974-05-31 00:59:00 am AM 31 Fri May 12 0 12 00 59 31 Friday 0 05 May 5 +0900 RFC822 Fri, 31 May 1974 00:59:00 +0900 00 31 139161540 5 74 1974 150 32400 2003 Error date(): 139161540
 
  "date CDT 1974-05-31 00:59:00 am AM 31 Fri May 12 0 12 00 59 31 Friday 0 05 May 5 +0900 RFC822 Fri, 31 May 1974 00:59:00 +0900 00 31 139161540 5 74 1974 150 32400 2003" (date len=166)
  "date CST 1974-05-30 23:59:00 pm PM 30 Thu May 11 23 11 23 59 30 Thursday 0 05 May 5 +0800 RFC822 Thu, 30 May 1974 23:59:00 +0800 00 31 139161540 4 74 1974 149 28800 2003" (adodb_date len=169)

Error getdate() 139161540
Array ( [seconds] => 0 [minutes] => 59 [hours] => 0 [mday] => 31 [wday] => 5 [mon] => 5 [year] => 1974 [yday] => 150 [weekday] => Friday [month] => May [0] => 139161540 )
Array ( [seconds] => 0 [minutes] => 59 [hours] => 23 [mday] => 30 [wday] => 4 [mon] => 5 [year] => 1974 [yday] => 149 [weekday] => Thursday [month] => May [0] => 139161540 )

04 Sep 1976 17:28:12 +0800 12 30 210677292 6 76 1976 247 28800 2003 Error date(): 210677292

 
  "date CST 1976-09-04 17:28:12 pm PM 04 Sat September 5 17 05 17 28 4 Saturday 1 09 Sep 9 +0800 RFC822 Sat, 04 Sep 1976 17:28:12 +0800 12 30 210677292 6 76 1976 247 28800 2003" (date len=173)
  "date CST 1976-09-04 17:28:12 pm PM 04 Sat September 5 17 05 17 28 4 Saturday 1 09 Sep 9 +0800 RFC822 Sat,  4 Sep 1976 17:28:12 +0800 12 30 210677292 6 76 1976 247 28800 2003" (adodb_date len=173)

01 Sep 1977 11:27:01 +0800 01 30 241932421 4 77 1977 243 28800 2003 Error date(): 241932421
 
  "date CST 1977-09-01 11:27:01 am AM 01 Thu September 11 11 11 11 27 1 Thursday 0 09 Sep 9 +0800 RFC822 Thu, 01 Sep 1977 11:27:01 +0800 01 30 241932421 4 77 1977 243 28800 2003" (date len=174)
  "date CST 1977-09-01 11:27:01 am AM 01 Thu September 11 11 11 11 27 1 Thursday 0 09 Sep 9 +0800 RFC822 Thu,  1 Sep 1977 11:27:01 +0800 01 30 241932421 4 77 1977 243 28800 2003" (adodb_date len=174)

02 Sep 1976 05:43:23 +0800 23 30 210462203 4 76 1976 245 28800 2003 Error date(): 210462203
 
  "date CST 1976-09-02 05:43:23 am AM 02 Thu September 5 5 05 05 43 2 Thursday 1 09 Sep 9 +0800 RFC822 Thu, 02 Sep 1976 05:43:23 +0800 23 30 210462203 4 76 1976 245 28800 2003" (date len=172)
  "date CST 1976-09-02 05:43:23 am AM 02 Thu September 5 5 05 05 43 2 Thursday 1 09 Sep 9 +0800 RFC822 Thu,  2 Sep 1976 05:43:23 +0800 23 30 210462203 4 76 1976 245 28800 2003" (adodb_date len=172)

02 Feb 1982 17:19:44 +0800 44 28 381489584 2 82 1982 32 28800 2003 Error date(): 381489584
 
  "date CST 1982-02-02 17:19:44 pm PM 02 Tue February 5 17 05 17 19 2 Tuesday 0 02 Feb 2 +0800 RFC822 Tue, 02 Feb 1982 17:19:44 +0800 44 28 381489584 2 82 1982 32 28800 2003" (date len=170)
  "date CST 1982-02-02 17:19:44 pm PM 02 Tue February 5 17 05 17 19 2 Tuesday 0 02 Feb 2 +0800 RFC822 Tue,  2 Feb 1982 17:19:44 +0800 44 28 381489584 2 82 1982 32 28800 2003" (adodb_date len=170)

DT 1975-06-29 20:06:08 pm PM 29 Sun June 8 20 08 20 06 29 Sunday 0 06 Jun 6 +0900 RFC822 Sun, 29 Jun 1975 20:06:08 +0900 08 30 173271968 0 75 1975 179 32400 2003 Error date(): 173271968
 
  "date CDT 1975-06-29 20:06:08 pm PM 29 Sun June 8 20 08 20 06 29 Sunday 0 06 Jun 6 +0900 RFC822 Sun, 29 Jun 1975 20:06:08 +0900 08 30 173271968 0 75 1975 179 32400 2003" (date len=167)
  "date CST 1975-06-29 19:06:08 pm PM 29 Sun June 7 19 07 19 06 29 Sunday 0 06 Jun 6 +0800 RFC822 Sun, 29 Jun 1975 19:06:08 +0800 08 30 173271968 0 75 1975 179 28800 2003" (adodb_date len=167)

Error getdate() 173271968
Array ( [seconds] => 8 [minutes] => 6 [hours] => 20 [mday] => 29 [wday] => 0 [mon] => 6 [year] => 1975 [yday] => 179 [weekday] => Sunday [month] => June [0] => 173271968 )
Array ( [seconds] => 8 [minutes] => 6 [hours] => 19 [mday] => 29 [wday] => 0 [mon] => 6 [year] => 1975 [yday] => 179 [weekday] => Sunday [month] => June [0] => 173271968 )

05 Mar 1982 03:37:41 +0800 41 31 384118661 5 82 1982 63 28800 2003 Error date(): 384118661

 
  "date CST 1982-03-05 03:37:41 am AM 05 Fri March 3 3 03 03 37 5 Friday 0 03 Mar 3 +0800 RFC822 Fri, 05 Mar 1982 03:37:41 +0800 41 31 384118661 5 82 1982 63 28800 2003" (date len=165)
  "date CST 1982-03-05 03:37:41 am AM 05 Fri March 3 3 03 03 37 5 Friday 0 03 Mar 3 +0800 RFC822 Fri,  5 Mar 1982 03:37:41 +0800 41 31 384118661 5 82 1982 63 28800 2003" (adodb_date len=165)

05 Dec 1978 03:50:44 +0800 44 31 281649044 2 78 1978 338 28800 2003 Error date(): 281649044
 
  "date CST 1978-12-05 03:50:44 am AM 05 Tue December 3 3 03 03 50 5 Tuesday 0 12 Dec 12 +0800 RFC822 Tue, 05 Dec 1978 03:50:44 +0800 44 31 281649044 2 78 1978 338 28800 2003" (date len=171)
  "date CST 1978-12-05 03:50:44 am AM 05 Tue December 3 3 03 03 50 5 Tuesday 0 12 Dec 12 +0800 RFC822 Tue,  5 Dec 1978 03:50:44 +0800 44 31 281649044 2 78 1978 338 28800 2003" (adodb_date len=171)

DT 1979-08-29 02:24:20 am AM 29 Wed August 2 2 02 02 24 29 Wednesday 0 08 Aug 8 +0900 RFC822 Wed, 29 Aug 1979 02:24:20 +0900 20 31 304709060 3 79 1979 240 32400 2003 Error date(): 304709060
 
  "date CDT 1979-08-29 02:24:20 am AM 29 Wed August 2 2 02 02 24 29 Wednesday 0 08 Aug 8 +0900 RFC822 Wed, 29 Aug 1979 02:24:20 +0900 20 31 304709060 3 79 1979 240 32400 2003" (date len=171)
  "date CST 1979-08-29 01:24:20 am AM 29 Wed August 1 1 01 01 24 29 Wednesday 0 08 Aug 8 +0800 RFC822 Wed, 29 Aug 1979 01:24:20 +0800 20 31 304709060 3 79 1979 240 28800 2003" (adodb_date len=171)

Error getdate() 304709060
Array ( [seconds] => 20 [minutes] => 24 [hours] => 2 [mday] => 29 [wday] => 3 [mon] => 8 [year] => 1979 [yday] => 240 [weekday] => Wednesday [month] => August [0] => 304709060 )
Array ( [seconds] => 20 [minutes] => 24 [hours] => 1 [mday] => 29 [wday] => 3 [mon] => 8 [year] => 1979 [yday] => 240 [weekday] => Wednesday [month] => August [0] => 304709060 )

03 May 1973 06:55:10 +0800 10 31 105231310 4 73 1973 122 28800 2003 Error date(): 105231310

 
  "date CST 1973-05-03 06:55:10 am AM 03 Thu May 6 6 06 06 55 3 Thursday 0 05 May 5 +0800 RFC822 Thu, 03 May 1973 06:55:10 +0800 10 31 105231310 4 73 1973 122 28800 2003" (date len=166)
  "date CST 1973-05-03 06:55:10 am AM 03 Thu May 6 6 06 06 55 3 Thursday 0 05 May 5 +0800 RFC822 Thu,  3 May 1973 06:55:10 +0800 10 31 105231310 4 73 1973 122 28800 2003" (adodb_date len=166)

DT 1974-08-17 19:39:08 pm PM 17 Sat August 7 19 07 19 39 17 Saturday 0 08 Aug 8 +0900 RFC822 Sat, 17 Aug 1974 19:39:08 +0900 08 31 145967948 6 74 1974 228 32400 2003 Error date(): 145967948
 
  "date CDT 1974-08-17 19:39:08 pm PM 17 Sat August 7 19 07 19 39 17 Saturday 0 08 Aug 8 +0900 RFC822 Sat, 17 Aug 1974 19:39:08 +0900 08 31 145967948 6 74 1974 228 32400 2003" (date len=171)
  "date CST 1974-08-17 18:39:08 pm PM 17 Sat August 6 18 06 18 39 17 Saturday 0 08 Aug 8 +0800 RFC822 Sat, 17 Aug 1974 18:39:08 +0800 08 31 145967948 6 74 1974 228 28800 2003" (adodb_date len=171)

Error getdate() 145967948
Array ( [seconds] => 8 [minutes] => 39 [hours] => 19 [mday] => 17 [wday] => 6 [mon] => 8 [year] => 1974 [yday] => 228 [weekday] => Saturday [month] => August [0] => 145967948 )
Array ( [seconds] => 8 [minutes] => 39 [hours] => 18 [mday] => 17 [wday] => 6 [mon] => 8 [year] => 1974 [yday] => 228 [weekday] => Saturday [month] => August [0] => 145967948 )

DT 1979-09-06 09:57:53 am AM 06 Thu September 9 9 09 09 57 6 Thursday 0 09 Sep 9 +0900 RFC822 Thu, 06 Sep 1979 09:57:53 +0900 53 30 305427473 4 79 1979 248 32400 2003 Error date(): 305427473

 
  "date CDT 1979-09-06 09:57:53 am AM 06 Thu September 9 9 09 09 57 6 Thursday 0 09 Sep 9 +0900 RFC822 Thu, 06 Sep 1979 09:57:53 +0900 53 30 305427473 4 79 1979 248 32400 2003" (date len=172)
  "date CST 1979-09-06 08:57:53 am AM 06 Thu September 8 8 08 08 57 6 Thursday 0 09 Sep 9 +0800 RFC822 Thu,  6 Sep 1979 08:57:53 +0800 53 30 305427473 4 79 1979 248 28800 2003" (adodb_date len=172)

02 Mar 1975 18:28:09 +0800 09 31 162988089 0 75 1975 60 28800 2003 Error date(): 162988089
 
  "date CST 1975-03-02 18:28:09 pm PM 02 Sun March 6 18 06 18 28 2 Sunday 0 03 Mar 3 +0800 RFC822 Sun, 02 Mar 1975 18:28:09 +0800 09 31 162988089 0 75 1975 60 28800 2003" (date len=166)
  "date CST 1975-03-02 18:28:09 pm PM 02 Sun March 6 18 06 18 28 2 Sunday 0 03 Mar 3 +0800 RFC822 Sun,  2 Mar 1975 18:28:09 +0800 09 31 162988089 0 75 1975 60 28800 2003" (adodb_date len=166)

DT 1974-06-04 21:32:34 pm PM 04 Tue June 9 21 09 21 32 4 Tuesday 0 06 Jun 6 +0900 RFC822 Tue, 04 Jun 1974 21:32:34 +0900 34 30 139581154 2 74 1974 154 32400 2003 Error date(): 139581154
 
  "date CDT 1974-06-04 21:32:34 pm PM 04 Tue June 9 21 09 21 32 4 Tuesday 0 06 Jun 6 +0900 RFC822 Tue, 04 Jun 1974 21:32:34 +0900 34 30 139581154 2 74 1974 154 32400 2003" (date len=167)
  "date CST 1974-06-04 20:32:34 pm PM 04 Tue June 8 20 08 20 32 4 Tuesday 0 06 Jun 6 +0800 RFC822 Tue,  4 Jun 1974 20:32:34 +0800 34 30 139581154 2 74 1974 154 28800 2003" (adodb_date len=167)

Error getdate() 139581154
Array ( [seconds] => 34 [minutes] => 32 [hours] => 21 [mday] => 4 [wday] => 2 [mon] => 6 [year] => 1974 [yday] => 154 [weekday] => Tuesday [month] => June [0] => 139581154 )
Array ( [seconds] => 34 [minutes] => 32 [hours] => 20 [mday] => 4 [wday] => 2 [mon] => 6 [year] => 1974 [yday] => 154 [weekday] => Tuesday [month] => June [0] => 139581154 )

DT 1975-05-20 14:01:17 pm PM 20 Tue May 2 14 02 14 01 20 Tuesday 0 05 May 5 +0900 RFC822 Tue, 20 May 1975 14:01:17 +0900 17 31 169794077 2 75 1975 139 32400 2003 Error date(): 169794077

 
  "date CDT 1975-05-20 14:01:17 pm PM 20 Tue May 2 14 02 14 01 20 Tuesday 0 05 May 5 +0900 RFC822 Tue, 20 May 1975 14:01:17 +0900 17 31 169794077 2 75 1975 139 32400 2003" (date len=167)
  "date CST 1975-05-20 13:01:17 pm PM 20 Tue May 1 13 01 13 01 20 Tuesday 0 05 May 5 +0800 RFC822 Tue, 20 May 1975 13:01:17 +0800 17 31 169794077 2 75 1975 139 28800 2003" (adodb_date len=167)

Error getdate() 169794077
Array ( [seconds] => 17 [minutes] => 1 [hours] => 14 [mday] => 20 [wday] => 2 [mon] => 5 [year] => 1975 [yday] => 139 [weekday] => Tuesday [month] => May [0] => 169794077 )
Array ( [seconds] => 17 [minutes] => 1 [hours] => 13 [mday] => 20 [wday] => 2 [mon] => 5 [year] => 1975 [yday] => 139 [weekday] => Tuesday [month] => May [0] => 169794077 )

04 Jan 1975 22:38:38 +0800 38 31 158078318 6 75 1975 3 28800 2003 Error date(): 158078318

 
  "date CST 1975-01-04 22:38:38 pm PM 04 Sat January 10 22 10 22 38 4 Saturday 0 01 Jan 1 +0800 RFC822 Sat, 04 Jan 1975 22:38:38 +0800 38 31 158078318 6 75 1975 3 28800 2003" (date len=170)
  "date CST 1975-01-04 22:38:38 pm PM 04 Sat January 10 22 10 22 38 4 Saturday 0 01 Jan 1 +0800 RFC822 Sat,  4 Jan 1975 22:38:38 +0800 38 31 158078318 6 75 1975 3 28800 2003" (adodb_date len=170)

03 Mar 1974 22:05:22 +0800 22 31 131551522 0 74 1974 61 28800 2003 Error date(): 131551522
 
  "date CST 1974-03-03 22:05:22 pm PM 03 Sun March 10 22 10 22 05 3 Sunday 0 03 Mar 3 +0800 RFC822 Sun, 03 Mar 1974 22:05:22 +0800 22 31 131551522 0 74 1974 61 28800 2003" (date len=167)
  "date CST 1974-03-03 22:05:22 pm PM 03 Sun March 10 22 10 22 05 3 Sunday 0 03 Mar 3 +0800 RFC822 Sun,  3 Mar 1974 22:05:22 +0800 22 31 131551522 0 74 1974 61 28800 2003" (adodb_date len=167)

06 Sep 1981 02:05:53 +0800 53 30 368561153 0 81 1981 248 28800 2003 Error date(): 368561153
 
  "date CST 1981-09-06 02:05:53 am AM 06 Sun September 2 2 02 02 05 6 Sunday 0 09 Sep 9 +0800 RFC822 Sun, 06 Sep 1981 02:05:53 +0800 53 30 368561153 0 81 1981 248 28800 2003" (date len=170)
  "date CST 1981-09-06 02:05:53 am AM 06 Sun September 2 2 02 02 05 6 Sunday 0 09 Sep 9 +0800 RFC822 Sun,  6 Sep 1981 02:05:53 +0800 53 30 368561153 0 81 1981 248 28800 2003" (adodb_date len=170)

02 Jul 1978 18:56:56 +0800 56 31 268225016 0 78 1978 182 28800 2003 Error date(): 268225016
 
  "date CST 1978-07-02 18:56:56 pm PM 02 Sun July 6 18 06 18 56 2 Sunday 0 07 Jul 7 +0800 RFC822 Sun, 02 Jul 1978 18:56:56 +0800 56 31 268225016 0 78 1978 182 28800 2003" (date len=166)
  "date CST 1978-07-02 18:56:56 pm PM 02 Sun July 6 18 06 18 56 2 Sunday 0 07 Jul 7 +0800 RFC822 Sun,  2 Jul 1978 18:56:56 +0800 56 31 268225016 0 78 1978 182 28800 2003" (adodb_date len=166)

02 Jan 1980 05:16:43 +0800 43 31 315609403 3 80 1980 1 28800 2003 Error date(): 315609403
 
  "date CST 1980-01-02 05:16:43 am AM 02 Wed January 5 5 05 05 16 2 Wednesday 1 01 Jan 1 +0800 RFC822 Wed, 02 Jan 1980 05:16:43 +0800 43 31 315609403 3 80 1980 1 28800 2003" (date len=169)
  "date CST 1980-01-02 05:16:43 am AM 02 Wed January 5 5 05 05 16 2 Wednesday 1 01 Jan 1 +0800 RFC822 Wed,  2 Jan 1980 05:16:43 +0800 43 31 315609403 3 80 1980 1 28800 2003" (adodb_date len=169)

04 Jan 1976 04:04:19 +0800 19 31 189547459 0 76 1976 3 28800 2003 Error date(): 189547459
 
  "date CST 1976-01-04 04:04:19 am AM 04 Sun January 4 4 04 04 04 4 Sunday 1 01 Jan 1 +0800 RFC822 Sun, 04 Jan 1976 04:04:19 +0800 19 31 189547459 0 76 1976 3 28800 2003" (date len=166)
  "date CST 1976-01-04 04:04:19 am AM 04 Sun January 4 4 04 04 04 4 Sunday 1 01 Jan 1 +0800 RFC822 Sun,  4 Jan 1976 04:04:19 +0800 19 31 189547459 0 76 1976 3 28800 2003" (adodb_date len=166)

05 Jun 1973 06:30:39 +0800 39 30 108081039 2 73 1973 155 28800 2003 Error date(): 108081039
 
  "date CST 1973-06-05 06:30:39 am AM 05 Tue June 6 6 06 06 30 5 Tuesday 0 06 Jun 6 +0800 RFC822 Tue, 05 Jun 1973 06:30:39 +0800 39 30 108081039 2 73 1973 155 28800 2003" (date len=166)
  "date CST 1973-06-05 06:30:39 am AM 05 Tue June 6 6 06 06 30 5 Tuesday 0 06 Jun 6 +0800 RFC822 Tue,  5 Jun 1973 06:30:39 +0800 39 30 108081039 2 73 1973 155 28800 2003" (adodb_date len=166)

01 Jan 1973 17:00:34 +0800 34 31 94726834 1 73 1973 0 28800 2003 Error date(): 94726834
 
  "date CST 1973-01-01 17:00:34 pm PM 01 Mon January 5 17 05 17 00 1 Monday 0 01 Jan 1 +0800 RFC822 Mon, 01 Jan 1973 17:00:34 +0800 34 31 94726834 1 73 1973 0 28800 2003" (date len=166)
  "date CST 1973-01-01 17:00:34 pm PM 01 Mon January 5 17 05 17 00 1 Monday 0 01 Jan 1 +0800 RFC822 Mon,  1 Jan 1973 17:00:34 +0800 34 31 94726834 1 73 1973 0 28800 2003" (adodb_date len=166)

08 Aug 1971 09:30:06 +0800 06 31 50463006 0 71 1971 219 28800 2003 Error date(): 50463006
 
  "date CST 1971-08-08 09:30:06 am AM 08 Sun August 9 9 09 09 30 8 Sunday 0 08 Aug 8 +0800 RFC822 Sun, 08 Aug 1971 09:30:06 +0800 06 31 50463006 0 71 1971 219 28800 2003" (date len=166)
  "date CST 1971-08-08 09:30:06 am AM 08 Sun August 9 9 09 09 30 8 Sunday 0 08 Aug 8 +0800 RFC822 Sun,  8 Aug 1971 09:30:06 +0800 06 31 50463006 0 71 1971 219 28800 2003" (adodb_date len=166)

DT 1975-08-14 09:03:09 am AM 14 Thu August 9 9 09 09 03 14 Thursday 0 08 Aug 8 +0900 RFC822 Thu, 14 Aug 1975 09:03:09 +0900 09 31 177206589 4 75 1975 225 32400 2003 Error date(): 177206589
 
  "date CDT 1975-08-14 09:03:09 am AM 14 Thu August 9 9 09 09 03 14 Thursday 0 08 Aug 8 +0900 RFC822 Thu, 14 Aug 1975 09:03:09 +0900 09 31 177206589 4 75 1975 225 32400 2003" (date len=170)
  "date CST 1975-08-14 08:03:09 am AM 14 Thu August 8 8 08 08 03 14 Thursday 0 08 Aug 8 +0800 RFC822 Thu, 14 Aug 1975 08:03:09 +0800 09 31 177206589 4 75 1975 225 28800 2003" (adodb_date len=170)

DT 1975-04-12 16:46:51 pm PM 12 Sat April 4 16 04 16 46 12 Saturday 0 04 Apr 4 +0900 RFC822 Sat, 12 Apr 1975 16:46:51 +0900 51 30 166520811 6 75 1975 101 32400 2003 Error date(): 166520811
 
  "date CDT 1975-04-12 16:46:51 pm PM 12 Sat April 4 16 04 16 46 12 Saturday 0 04 Apr 4 +0900 RFC822 Sat, 12 Apr 1975 16:46:51 +0900 51 30 166520811 6 75 1975 101 32400 2003" (date len=170)
  "date CST 1975-04-12 15:46:51 pm PM 12 Sat April 3 15 03 15 46 12 Saturday 0 04 Apr 4 +0800 RFC822 Sat, 12 Apr 1975 15:46:51 +0800 51 30 166520811 6 75 1975 101 28800 2003" (adodb_date len=170)

Error getdate() 166520811
Array ( [seconds] => 51 [minutes] => 46 [hours] => 16 [mday] => 12 [wday] => 6 [mon] => 4 [year] => 1975 [yday] => 101 [weekday] => Saturday [month] => April [0] => 166520811 )
Array ( [seconds] => 51 [minutes] => 46 [hours] => 15 [mday] => 12 [wday] => 6 [mon] => 4 [year] => 1975 [yday] => 101 [weekday] => Saturday [month] => April [0] => 166520811 )

07 Feb 1978 02:42:43 +0800 43 28 255638563 2 78 1978 37 28800 2003 Error date(): 255638563

 
  "date CST 1978-02-07 02:42:43 am AM 07 Tue February 2 2 02 02 42 7 Tuesday 0 02 Feb 2 +0800 RFC822 Tue, 07 Feb 1978 02:42:43 +0800 43 28 255638563 2 78 1978 37 28800 2003" (date len=169)
  "date CST 1978-02-07 02:42:43 am AM 07 Tue February 2 2 02 02 42 7 Tuesday 0 02 Feb 2 +0800 RFC822 Tue,  7 Feb 1978 02:42:43 +0800 43 28 255638563 2 78 1978 37 28800 2003" (adodb_date len=169)

04 Apr 1977 05:18:23 +0800 23 30 228950303 1 77 1977 93 28800 2003 Error date(): 228950303
 
  "date CST 1977-04-04 05:18:23 am AM 04 Mon April 5 5 05 05 18 4 Monday 0 04 Apr 4 +0800 RFC822 Mon, 04 Apr 1977 05:18:23 +0800 23 30 228950303 1 77 1977 93 28800 2003" (date len=165)
  "date CST 1977-04-04 05:18:23 am AM 04 Mon April 5 5 05 05 18 4 Monday 0 04 Apr 4 +0800 RFC822 Mon,  4 Apr 1977 05:18:23 +0800 23 30 228950303 1 77 1977 93 28800 2003" (adodb_date len=165)

06 Mar 1971 08:49:35 +0800 35 31 37068575 6 71 1971 64 28800 2003 Error date(): 37068575
 
  "date CST 1971-03-06 08:49:35 am AM 06 Sat March 8 8 08 08 49 6 Saturday 0 03 Mar 3 +0800 RFC822 Sat, 06 Mar 1971 08:49:35 +0800 35 31 37068575 6 71 1971 64 28800 2003" (date len=166)
  "date CST 1971-03-06 08:49:35 am AM 06 Sat March 8 8 08 08 49 6 Saturday 0 03 Mar 3 +0800 RFC822 Sat,  6 Mar 1971 08:49:35 +0800 35 31 37068575 6 71 1971 64 28800 2003" (adodb_date len=166)

05 Oct 1981 20:23:19 +0800 19 31 371132599 1 81 1981 277 28800 2003 Error date(): 371132599
 
  "date CST 1981-10-05 20:23:19 pm PM 05 Mon October 8 20 08 20 23 5 Monday 0 10 Oct 10 +0800 RFC822 Mon, 05 Oct 1981 20:23:19 +0800 19 31 371132599 1 81 1981 277 28800 2003" (date len=170)
  "date CST 1981-10-05 20:23:19 pm PM 05 Mon October 8 20 08 20 23 5 Monday 0 10 Oct 10 +0800 RFC822 Mon,  5 Oct 1981 20:23:19 +0800 19 31 371132599 1 81 1981 277 28800 2003" (adodb_date len=170)

DT 1979-08-11 20:14:39 pm PM 11 Sat August 8 20 08 20 14 11 Saturday 0 08 Aug 8 +0900 RFC822 Sat, 11 Aug 1979 20:14:39 +0900 39 31 303218079 6 79 1979 222 32400 2003 Error date(): 303218079
 
  "date CDT 1979-08-11 20:14:39 pm PM 11 Sat August 8 20 08 20 14 11 Saturday 0 08 Aug 8 +0900 RFC822 Sat, 11 Aug 1979 20:14:39 +0900 39 31 303218079 6 79 1979 222 32400 2003" (date len=171)
  "date CST 1979-08-11 19:14:39 pm PM 11 Sat August 7 19 07 19 14 11 Saturday 0 08 Aug 8 +0800 RFC822 Sat, 11 Aug 1979 19:14:39 +0800 39 31 303218079 6 79 1979 222 28800 2003" (adodb_date len=171)

Error getdate() 303218079
Array ( [seconds] => 39 [minutes] => 14 [hours] => 20 [mday] => 11 [wday] => 6 [mon] => 8 [year] => 1979 [yday] => 222 [weekday] => Saturday [month] => August [0] => 303218079 )
Array ( [seconds] => 39 [minutes] => 14 [hours] => 19 [mday] => 11 [wday] => 6 [mon] => 8 [year] => 1979 [yday] => 222 [weekday] => Saturday [month] => August [0] => 303218079 )

09 Dec 1980 12:53:02 +0800 02 31 345185582 2 80 1980 343 28800 2003 Error date(): 345185582

 
  "date CST 1980-12-09 12:53:02 pm PM 09 Tue December 12 12 12 12 53 9 Tuesday 1 12 Dec 12 +0800 RFC822 Tue, 09 Dec 1980 12:53:02 +0800 02 31 345185582 2 80 1980 343 28800 2003" (date len=173)
  "date CST 1980-12-09 12:53:02 pm PM 09 Tue December 12 12 12 12 53 9 Tuesday 1 12 Dec 12 +0800 RFC822 Tue,  9 Dec 1980 12:53:02 +0800 02 31 345185582 2 80 1980 343 28800 2003" (adodb_date len=173)

DT 1979-08-30 07:43:58 am AM 30 Thu August 7 7 07 07 43 30 Thursday 0 08 Aug 8 +0900 RFC822 Thu, 30 Aug 1979 07:43:58 +0900 58 31 304814638 4 79 1979 241 32400 2003 Error date(): 304814638
 
  "date CDT 1979-08-30 07:43:58 am AM 30 Thu August 7 7 07 07 43 30 Thursday 0 08 Aug 8 +0900 RFC822 Thu, 30 Aug 1979 07:43:58 +0900 58 31 304814638 4 79 1979 241 32400 2003" (date len=170)
  "date CST 1979-08-30 06:43:58 am AM 30 Thu August 6 6 06 06 43 30 Thursday 0 08 Aug 8 +0800 RFC822 Thu, 30 Aug 1979 06:43:58 +0800 58 31 304814638 4 79 1979 241 28800 2003" (adodb_date len=170)

Error getdate() 304814638
Array ( [seconds] => 58 [minutes] => 43 [hours] => 7 [mday] => 30 [wday] => 4 [mon] => 8 [year] => 1979 [yday] => 241 [weekday] => Thursday [month] => August [0] => 304814638 )
Array ( [seconds] => 58 [minutes] => 43 [hours] => 6 [mday] => 30 [wday] => 4 [mon] => 8 [year] => 1979 [yday] => 241 [weekday] => Thursday [month] => August [0] => 304814638 )

09 Oct 1980 19:29:49 +0800 49 31 339938989 4 80 1980 282 28800 2003 Error date(): 339938989

 
  "date CST 1980-10-09 19:29:49 pm PM 09 Thu October 7 19 07 19 29 9 Thursday 1 10 Oct 10 +0800 RFC822 Thu, 09 Oct 1980 19:29:49 +0800 49 31 339938989 4 80 1980 282 28800 2003" (date len=172)
  "date CST 1980-10-09 19:29:49 pm PM 09 Thu October 7 19 07 19 29 9 Thursday 1 10 Oct 10 +0800 RFC822 Thu,  9 Oct 1980 19:29:49 +0800 49 31 339938989 4 80 1980 282 28800 2003" (adodb_date len=172)

02 Nov 1974 22:36:22 +0800 22 30 152634982 6 74 1974 305 28800 2003 Error date(): 152634982
 
  "date CST 1974-11-02 22:36:22 pm PM 02 Sat November 10 22 10 22 36 2 Saturday 0 11 Nov 11 +0800 RFC822 Sat, 02 Nov 1974 22:36:22 +0800 22 30 152634982 6 74 1974 305 28800 2003" (date len=174)
  "date CST 1974-11-02 22:36:22 pm PM 02 Sat November 10 22 10 22 36 2 Saturday 0 11 Nov 11 +0800 RFC822 Sat,  2 Nov 1974 22:36:22 +0800 22 30 152634982 6 74 1974 305 28800 2003" (adodb_date len=174)

DT 1974-04-12 05:43:12 am AM 12 Fri April 5 5 05 05 43 12 Friday 0 04 Apr 4 +0900 RFC822 Fri, 12 Apr 1974 05:43:12 +0900 12 30 134944992 5 74 1974 101 32400 2003 Error date(): 134944992
 
  "date CDT 1974-04-12 05:43:12 am AM 12 Fri April 5 5 05 05 43 12 Friday 0 04 Apr 4 +0900 RFC822 Fri, 12 Apr 1974 05:43:12 +0900 12 30 134944992 5 74 1974 101 32400 2003" (date len=167)
  "date CST 1974-04-12 04:43:12 am AM 12 Fri April 4 4 04 04 43 12 Friday 0 04 Apr 4 +0800 RFC822 Fri, 12 Apr 1974 04:43:12 +0800 12 30 134944992 5 74 1974 101 28800 2003" (adodb_date len=167)

04 Dec 1979 12:44:32 +0800 32 31 313130672 2 79 1979 337 28800 2003 Error date(): 313130672
 
  "date CST 1979-12-04 12:44:32 pm PM 04 Tue December 12 12 12 12 44 4 Tuesday 0 12 Dec 12 +0800 RFC822 Tue, 04 Dec 1979 12:44:32 +0800 32 31 313130672 2 79 1979 337 28800 2003" (date len=173)
  "date CST 1979-12-04 12:44:32 pm PM 04 Tue December 12 12 12 12 44 4 Tuesday 0 12 Dec 12 +0800 RFC822 Tue,  4 Dec 1979 12:44:32 +0800 32 31 313130672 2 79 1979 337 28800 2003" (adodb_date len=173)

DT 1975-06-15 04:50:18 am AM 15 Sun June 4 4 04 04 50 15 Sunday 0 06 Jun 6 +0900 RFC822 Sun, 15 Jun 1975 04:50:18 +0900 18 30 172007418 0 75 1975 165 32400 2003 Error date(): 172007418
 
  "date CDT 1975-06-15 04:50:18 am AM 15 Sun June 4 4 04 04 50 15 Sunday 0 06 Jun 6 +0900 RFC822 Sun, 15 Jun 1975 04:50:18 +0900 18 30 172007418 0 75 1975 165 32400 2003" (date len=166)
  "date CST 1975-06-15 03:50:18 am AM 15 Sun June 3 3 03 03 50 15 Sunday 0 06 Jun 6 +0800 RFC822 Sun, 15 Jun 1975 03:50:18 +0800 18 30 172007418 0 75 1975 165 28800 2003" (adodb_date len=166)

Error getdate() 172007418
Array ( [seconds] => 18 [minutes] => 50 [hours] => 4 [mday] => 15 [wday] => 0 [mon] => 6 [year] => 1975 [yday] => 165 [weekday] => Sunday [month] => June [0] => 172007418 )
Array ( [seconds] => 18 [minutes] => 50 [hours] => 3 [mday] => 15 [wday] => 0 [mon] => 6 [year] => 1975 [yday] => 165 [weekday] => Sunday [month] => June [0] => 172007418 )

09 Sep 1972 14:53:37 +0800 37 30 84869617 6 72 1972 252 28800 2003 Error date(): 84869617

 
  "date CST 1972-09-09 14:53:37 pm PM 09 Sat September 2 14 02 14 53 9 Saturday 1 09 Sep 9 +0800 RFC822 Sat, 09 Sep 1972 14:53:37 +0800 37 30 84869617 6 72 1972 252 28800 2003" (date len=172)
  "date CST 1972-09-09 14:53:37 pm PM 09 Sat September 2 14 02 14 53 9 Saturday 1 09 Sep 9 +0800 RFC822 Sat,  9 Sep 1972 14:53:37 +0800 37 30 84869617 6 72 1972 252 28800 2003" (adodb_date len=172)

02 Jul 1970 09:11:24 +0800 24 31 15729084 4 70 1970 182 28800 2003 Error date(): 15729084
 
  "date CST 1970-07-02 09:11:24 am AM 02 Thu July 9 9 09 09 11 2 Thursday 0 07 Jul 7 +0800 RFC822 Thu, 02 Jul 1970 09:11:24 +0800 24 31 15729084 4 70 1970 182 28800 2003" (date len=166)
  "date CST 1970-07-02 09:11:24 am AM 02 Thu July 9 9 09 09 11 2 Thursday 0 07 Jul 7 +0800 RFC822 Thu,  2 Jul 1970 09:11:24 +0800 24 31 15729084 4 70 1970 182 28800 2003" (adodb_date len=166)

02 Mar 1980 06:09:13 +0800 13 31 320796553 0 80 1980 61 28800 2003 Error date(): 320796553
 
  "date CST 1980-03-02 06:09:13 am AM 02 Sun March 6 6 06 06 09 2 Sunday 1 03 Mar 3 +0800 RFC822 Sun, 02 Mar 1980 06:09:13 +0800 13 31 320796553 0 80 1980 61 28800 2003" (date len=165)
  "date CST 1980-03-02 06:09:13 am AM 02 Sun March 6 6 06 06 09 2 Sunday 1 03 Mar 3 +0800 RFC822 Sun,  2 Mar 1980 06:09:13 +0800 13 31 320796553 0 80 1980 61 28800 2003" (adodb_date len=165)

DT 1975-08-20 12:11:05 pm PM 20 Wed August 12 12 12 12 11 20 Wednesday 0 08 Aug 8 +0900 RFC822 Wed, 20 Aug 1975 12:11:05 +0900 05 31 177736265 3 75 1975 231 32400 2003 Error date(): 177736265
 
  "date CDT 1975-08-20 12:11:05 pm PM 20 Wed August 12 12 12 12 11 20 Wednesday 0 08 Aug 8 +0900 RFC822 Wed, 20 Aug 1975 12:11:05 +0900 05 31 177736265 3 75 1975 231 32400 2003" (date len=173)
  "date CST 1975-08-20 11:11:05 am AM 20 Wed August 11 11 11 11 11 20 Wednesday 0 08 Aug 8 +0800 RFC822 Wed, 20 Aug 1975 11:11:05 +0800 05 31 177736265 3 75 1975 231 28800 2003" (adodb_date len=173)

Error getdate() 177736265
Array ( [seconds] => 5 [minutes] => 11 [hours] => 12 [mday] => 20 [wday] => 3 [mon] => 8 [year] => 1975 [yday] => 231 [weekday] => Wednesday [month] => August [0] => 177736265 )
Array ( [seconds] => 5 [minutes] => 11 [hours] => 11 [mday] => 20 [wday] => 3 [mon] => 8 [year] => 1975 [yday] => 231 [weekday] => Wednesday [month] => August [0] => 177736265 )

Testing random dates between 100 and 4000

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

Failed :-(

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