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-09-08 17:23:28 pm PM 08 Sun September 5 17 05 17 23 8 Sunday 0 09 Sep 9 +0900 RFC822 Sun, 08 Sep 1974 17:23:28 +0900 28 30 147860608 0 74 1974 250 32400 2003 Error date(): 147860608
 
  "date CDT 1974-09-08 17:23:28 pm PM 08 Sun September 5 17 05 17 23 8 Sunday 0 09 Sep 9 +0900 RFC822 Sun, 08 Sep 1974 17:23:28 +0900 28 30 147860608 0 74 1974 250 32400 2003" (date len=171)
  "date CST 1974-09-08 16:23:28 pm PM 08 Sun September 4 16 04 16 23 8 Sunday 0 09 Sep 9 +0800 RFC822 Sun,  8 Sep 1974 16:23:28 +0800 28 30 147860608 0 74 1974 250 28800 2003" (adodb_date len=171)

Error getdate() 147860608
Array ( [seconds] => 28 [minutes] => 23 [hours] => 17 [mday] => 8 [wday] => 0 [mon] => 9 [year] => 1974 [yday] => 250 [weekday] => Sunday [month] => September [0] => 147860608 )
Array ( [seconds] => 28 [minutes] => 23 [hours] => 16 [mday] => 8 [wday] => 0 [mon] => 9 [year] => 1974 [yday] => 250 [weekday] => Sunday [month] => September [0] => 147860608 )

DT 1974-07-06 02:25:24 am AM 06 Sat July 2 2 02 02 25 6 Saturday 0 07 Jul 7 +0900 RFC822 Sat, 06 Jul 1974 02:25:24 +0900 24 31 142277124 6 74 1974 186 32400 2003 Error date(): 142277124

 
  "date CDT 1974-07-06 02:25:24 am AM 06 Sat July 2 2 02 02 25 6 Saturday 0 07 Jul 7 +0900 RFC822 Sat, 06 Jul 1974 02:25:24 +0900 24 31 142277124 6 74 1974 186 32400 2003" (date len=167)
  "date CST 1974-07-06 01:25:24 am AM 06 Sat July 1 1 01 01 25 6 Saturday 0 07 Jul 7 +0800 RFC822 Sat,  6 Jul 1974 01:25:24 +0800 24 31 142277124 6 74 1974 186 28800 2003" (adodb_date len=167)

Error getdate() 142277124
Array ( [seconds] => 24 [minutes] => 25 [hours] => 2 [mday] => 6 [wday] => 6 [mon] => 7 [year] => 1974 [yday] => 186 [weekday] => Saturday [month] => July [0] => 142277124 )
Array ( [seconds] => 24 [minutes] => 25 [hours] => 1 [mday] => 6 [wday] => 6 [mon] => 7 [year] => 1974 [yday] => 186 [weekday] => Saturday [month] => July [0] => 142277124 )

DT 1975-09-24 13:03:00 pm PM 24 Wed September 1 13 01 13 03 24 Wednesday 0 09 Sep 9 +0900 RFC822 Wed, 24 Sep 1975 13:03:00 +0900 00 30 180763380 3 75 1975 266 32400 2003 Error date(): 180763380

 
  "date CDT 1975-09-24 13:03:00 pm PM 24 Wed September 1 13 01 13 03 24 Wednesday 0 09 Sep 9 +0900 RFC822 Wed, 24 Sep 1975 13:03:00 +0900 00 30 180763380 3 75 1975 266 32400 2003" (date len=175)
  "date CST 1975-09-24 12:03:00 pm PM 24 Wed September 12 12 12 12 03 24 Wednesday 0 09 Sep 9 +0800 RFC822 Wed, 24 Sep 1975 12:03:00 +0800 00 30 180763380 3 75 1975 266 28800 2003" (adodb_date len=176)

Error getdate() 180763380
Array ( [seconds] => 0 [minutes] => 3 [hours] => 13 [mday] => 24 [wday] => 3 [mon] => 9 [year] => 1975 [yday] => 266 [weekday] => Wednesday [month] => September [0] => 180763380 )
Array ( [seconds] => 0 [minutes] => 3 [hours] => 12 [mday] => 24 [wday] => 3 [mon] => 9 [year] => 1975 [yday] => 266 [weekday] => Wednesday [month] => September [0] => 180763380 )

DT 1975-04-02 07:58:31 am AM 02 Wed April 7 7 07 07 58 2 Wednesday 0 04 Apr 4 +0900 RFC822 Wed, 02 Apr 1975 07:58:31 +0900 31 30 165625111 3 75 1975 91 32400 2003 Error date(): 165625111

 
  "date CDT 1975-04-02 07:58:31 am AM 02 Wed April 7 7 07 07 58 2 Wednesday 0 04 Apr 4 +0900 RFC822 Wed, 02 Apr 1975 07:58:31 +0900 31 30 165625111 3 75 1975 91 32400 2003" (date len=168)
  "date CST 1975-04-02 06:58:31 am AM 02 Wed April 6 6 06 06 58 2 Wednesday 0 04 Apr 4 +0800 RFC822 Wed,  2 Apr 1975 06:58:31 +0800 31 30 165625111 3 75 1975 91 28800 2003" (adodb_date len=168)

Error getdate() 165625111
Array ( [seconds] => 31 [minutes] => 58 [hours] => 7 [mday] => 2 [wday] => 3 [mon] => 4 [year] => 1975 [yday] => 91 [weekday] => Wednesday [month] => April [0] => 165625111 )
Array ( [seconds] => 31 [minutes] => 58 [hours] => 6 [mday] => 2 [wday] => 3 [mon] => 4 [year] => 1975 [yday] => 91 [weekday] => Wednesday [month] => April [0] => 165625111 )

DT 1974-09-15 11:54:08 am AM 15 Sun September 11 11 11 11 54 15 Sunday 0 09 Sep 9 +0900 RFC822 Sun, 15 Sep 1974 11:54:08 +0900 08 30 148445648 0 74 1974 257 32400 2003 Error date(): 148445648

 
  "date CDT 1974-09-15 11:54:08 am AM 15 Sun September 11 11 11 11 54 15 Sunday 0 09 Sep 9 +0900 RFC822 Sun, 15 Sep 1974 11:54:08 +0900 08 30 148445648 0 74 1974 257 32400 2003" (date len=173)
  "date CST 1974-09-15 10:54:08 am AM 15 Sun September 10 10 10 10 54 15 Sunday 0 09 Sep 9 +0800 RFC822 Sun, 15 Sep 1974 10:54:08 +0800 08 30 148445648 0 74 1974 257 28800 2003" (adodb_date len=173)

Error getdate() 148445648
Array ( [seconds] => 8 [minutes] => 54 [hours] => 11 [mday] => 15 [wday] => 0 [mon] => 9 [year] => 1974 [yday] => 257 [weekday] => Sunday [month] => September [0] => 148445648 )
Array ( [seconds] => 8 [minutes] => 54 [hours] => 10 [mday] => 15 [wday] => 0 [mon] => 9 [year] => 1974 [yday] => 257 [weekday] => Sunday [month] => September [0] => 148445648 )

03 Apr 1977 19:28:12 +0800 12 30 228914892 0 77 1977 92 28800 2003 Error date(): 228914892

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

DT 1975-07-21 09:36:15 am AM 21 Mon July 9 9 09 09 36 21 Monday 0 07 Jul 7 +0900 RFC822 Mon, 21 Jul 1975 09:36:15 +0900 15 31 175134975 1 75 1975 201 32400 2003 Error date(): 175134975
 
  "date CDT 1975-07-21 09:36:15 am AM 21 Mon July 9 9 09 09 36 21 Monday 0 07 Jul 7 +0900 RFC822 Mon, 21 Jul 1975 09:36:15 +0900 15 31 175134975 1 75 1975 201 32400 2003" (date len=166)
  "date CST 1975-07-21 08:36:15 am AM 21 Mon July 8 8 08 08 36 21 Monday 0 07 Jul 7 +0800 RFC822 Mon, 21 Jul 1975 08:36:15 +0800 15 31 175134975 1 75 1975 201 28800 2003" (adodb_date len=166)

Error getdate() 175134975
Array ( [seconds] => 15 [minutes] => 36 [hours] => 9 [mday] => 21 [wday] => 1 [mon] => 7 [year] => 1975 [yday] => 201 [weekday] => Monday [month] => July [0] => 175134975 )
Array ( [seconds] => 15 [minutes] => 36 [hours] => 8 [mday] => 21 [wday] => 1 [mon] => 7 [year] => 1975 [yday] => 201 [weekday] => Monday [month] => July [0] => 175134975 )

DT 1979-09-16 06:42:46 am AM 16 Sun September 6 6 06 06 42 16 Sunday 0 09 Sep 9 +0900 RFC822 Sun, 16 Sep 1979 06:42:46 +0900 46 30 306279766 0 79 1979 258 32400 2003 Error date(): 306279766

 
  "date CDT 1979-09-16 06:42:46 am AM 16 Sun September 6 6 06 06 42 16 Sunday 0 09 Sep 9 +0900 RFC822 Sun, 16 Sep 1979 06:42:46 +0900 46 30 306279766 0 79 1979 258 32400 2003" (date len=171)
  "date CST 1979-09-16 05:42:46 am AM 16 Sun September 5 5 05 05 42 16 Sunday 0 09 Sep 9 +0800 RFC822 Sun, 16 Sep 1979 05:42:46 +0800 46 30 306279766 0 79 1979 258 28800 2003" (adodb_date len=171)

Error getdate() 306279766
Array ( [seconds] => 46 [minutes] => 42 [hours] => 6 [mday] => 16 [wday] => 0 [mon] => 9 [year] => 1979 [yday] => 258 [weekday] => Sunday [month] => September [0] => 306279766 )
Array ( [seconds] => 46 [minutes] => 42 [hours] => 5 [mday] => 16 [wday] => 0 [mon] => 9 [year] => 1979 [yday] => 258 [weekday] => Sunday [month] => September [0] => 306279766 )

07 Jan 1977 20:53:23 +0800 23 31 221489603 5 77 1977 6 28800 2003 Error date(): 221489603

 
  "date CST 1977-01-07 20:53:23 pm PM 07 Fri January 8 20 08 20 53 7 Friday 0 01 Jan 1 +0800 RFC822 Fri, 07 Jan 1977 20:53:23 +0800 23 31 221489603 5 77 1977 6 28800 2003" (date len=167)
  "date CST 1977-01-07 20:53:23 pm PM 07 Fri January 8 20 08 20 53 7 Friday 0 01 Jan 1 +0800 RFC822 Fri,  7 Jan 1977 20:53:23 +0800 23 31 221489603 5 77 1977 6 28800 2003" (adodb_date len=167)

04 Dec 1976 15:51:18 +0800 18 31 218533878 6 76 1976 338 28800 2003 Error date(): 218533878
 
  "date CST 1976-12-04 15:51:18 pm PM 04 Sat December 3 15 03 15 51 4 Saturday 1 12 Dec 12 +0800 RFC822 Sat, 04 Dec 1976 15:51:18 +0800 18 31 218533878 6 76 1976 338 28800 2003" (date len=173)
  "date CST 1976-12-04 15:51:18 pm PM 04 Sat December 3 15 03 15 51 4 Saturday 1 12 Dec 12 +0800 RFC822 Sat,  4 Dec 1976 15:51:18 +0800 18 31 218533878 6 76 1976 338 28800 2003" (adodb_date len=173)

04 Mar 1975 11:45:15 +0800 15 31 163136715 2 75 1975 62 28800 2003 Error date(): 163136715
 
  "date CST 1975-03-04 11:45:15 am AM 04 Tue March 11 11 11 11 45 4 Tuesday 0 03 Mar 3 +0800 RFC822 Tue, 04 Mar 1975 11:45:15 +0800 15 31 163136715 2 75 1975 62 28800 2003" (date len=168)
  "date CST 1975-03-04 11:45:15 am AM 04 Tue March 11 11 11 11 45 4 Tuesday 0 03 Mar 3 +0800 RFC822 Tue,  4 Mar 1975 11:45:15 +0800 15 31 163136715 2 75 1975 62 28800 2003" (adodb_date len=168)

05 Feb 1976 13:24:36 +0800 36 29 192345876 4 76 1976 35 28800 2003 Error date(): 192345876
 
  "date CST 1976-02-05 13:24:36 pm PM 05 Thu February 1 13 01 13 24 5 Thursday 1 02 Feb 2 +0800 RFC822 Thu, 05 Feb 1976 13:24:36 +0800 36 29 192345876 4 76 1976 35 28800 2003" (date len=171)
  "date CST 1976-02-05 13:24:36 pm PM 05 Thu February 1 13 01 13 24 5 Thursday 1 02 Feb 2 +0800 RFC822 Thu,  5 Feb 1976 13:24:36 +0800 36 29 192345876 4 76 1976 35 28800 2003" (adodb_date len=171)

09 Jan 1978 17:30:21 +0800 21 31 253186221 1 78 1978 8 28800 2003 Error date(): 253186221
 
  "date CST 1978-01-09 17:30:21 pm PM 09 Mon January 5 17 05 17 30 9 Monday 0 01 Jan 1 +0800 RFC822 Mon, 09 Jan 1978 17:30:21 +0800 21 31 253186221 1 78 1978 8 28800 2003" (date len=167)
  "date CST 1978-01-09 17:30:21 pm PM 09 Mon January 5 17 05 17 30 9 Monday 0 01 Jan 1 +0800 RFC822 Mon,  9 Jan 1978 17:30:21 +0800 21 31 253186221 1 78 1978 8 28800 2003" (adodb_date len=167)

DT 1974-07-02 07:22:23 am AM 02 Tue July 7 7 07 07 22 2 Tuesday 0 07 Jul 7 +0900 RFC822 Tue, 02 Jul 1974 07:22:23 +0900 23 31 141949343 2 74 1974 182 32400 2003 Error date(): 141949343
 
  "date CDT 1974-07-02 07:22:23 am AM 02 Tue July 7 7 07 07 22 2 Tuesday 0 07 Jul 7 +0900 RFC822 Tue, 02 Jul 1974 07:22:23 +0900 23 31 141949343 2 74 1974 182 32400 2003" (date len=166)
  "date CST 1974-07-02 06:22:23 am AM 02 Tue July 6 6 06 06 22 2 Tuesday 0 07 Jul 7 +0800 RFC822 Tue,  2 Jul 1974 06:22:23 +0800 23 31 141949343 2 74 1974 182 28800 2003" (adodb_date len=166)

01 Feb 1977 06:14:49 +0800 49 28 223596889 2 77 1977 31 28800 2003 Error date(): 223596889
 
  "date CST 1977-02-01 06:14:49 am AM 01 Tue February 6 6 06 06 14 1 Tuesday 0 02 Feb 2 +0800 RFC822 Tue, 01 Feb 1977 06:14:49 +0800 49 28 223596889 2 77 1977 31 28800 2003" (date len=169)
  "date CST 1977-02-01 06:14:49 am AM 01 Tue February 6 6 06 06 14 1 Tuesday 0 02 Feb 2 +0800 RFC822 Tue,  1 Feb 1977 06:14:49 +0800 49 28 223596889 2 77 1977 31 28800 2003" (adodb_date len=169)

07 Nov 1979 22:30:54 +0800 54 30 310833054 3 79 1979 310 28800 2003 Error date(): 310833054
 
  "date CST 1979-11-07 22:30:54 pm PM 07 Wed November 10 22 10 22 30 7 Wednesday 0 11 Nov 11 +0800 RFC822 Wed, 07 Nov 1979 22:30:54 +0800 54 30 310833054 3 79 1979 310 28800 2003" (date len=175)
  "date CST 1979-11-07 22:30:54 pm PM 07 Wed November 10 22 10 22 30 7 Wednesday 0 11 Nov 11 +0800 RFC822 Wed,  7 Nov 1979 22:30:54 +0800 54 30 310833054 3 79 1979 310 28800 2003" (adodb_date len=175)

06 Sep 1980 16:37:07 +0800 07 30 337077427 6 80 1980 249 28800 2003 Error date(): 337077427
 
  "date CST 1980-09-06 16:37:07 pm PM 06 Sat September 4 16 04 16 37 6 Saturday 1 09 Sep 9 +0800 RFC822 Sat, 06 Sep 1980 16:37:07 +0800 07 30 337077427 6 80 1980 249 28800 2003" (date len=173)
  "date CST 1980-09-06 16:37:07 pm PM 06 Sat September 4 16 04 16 37 6 Saturday 1 09 Sep 9 +0800 RFC822 Sat,  6 Sep 1980 16:37:07 +0800 07 30 337077427 6 80 1980 249 28800 2003" (adodb_date len=173)

DT 1974-05-08 01:28:07 am AM 08 Wed May 1 1 01 01 28 8 Wednesday 0 05 May 5 +0900 RFC822 Wed, 08 May 1974 01:28:07 +0900 07 31 137176087 3 74 1974 127 32400 2003 Error date(): 137176087
 
  "date CDT 1974-05-08 01:28:07 am AM 08 Wed May 1 1 01 01 28 8 Wednesday 0 05 May 5 +0900 RFC822 Wed, 08 May 1974 01:28:07 +0900 07 31 137176087 3 74 1974 127 32400 2003" (date len=167)
  "date CST 1974-05-08 00:28:07 am AM 08 Wed May 12 0 12 00 28 8 Wednesday 0 05 May 5 +0800 RFC822 Wed,  8 May 1974 00:28:07 +0800 07 31 137176087 3 74 1974 127 28800 2003" (adodb_date len=168)

Error getdate() 137176087
Array ( [seconds] => 7 [minutes] => 28 [hours] => 1 [mday] => 8 [wday] => 3 [mon] => 5 [year] => 1974 [yday] => 127 [weekday] => Wednesday [month] => May [0] => 137176087 )
Array ( [seconds] => 7 [minutes] => 28 [hours] => 0 [mday] => 8 [wday] => 3 [mon] => 5 [year] => 1974 [yday] => 127 [weekday] => Wednesday [month] => May [0] => 137176087 )

07 May 1980 15:37:00 +0800 00 31 326533020 3 80 1980 127 28800 2003 Error date(): 326533020

 
  "date CST 1980-05-07 15:37:00 pm PM 07 Wed May 3 15 03 15 37 7 Wednesday 1 05 May 5 +0800 RFC822 Wed, 07 May 1980 15:37:00 +0800 00 31 326533020 3 80 1980 127 28800 2003" (date len=168)
  "date CST 1980-05-07 15:37:00 pm PM 07 Wed May 3 15 03 15 37 7 Wednesday 1 05 May 5 +0800 RFC822 Wed,  7 May 1980 15:37:00 +0800 00 31 326533020 3 80 1980 127 28800 2003" (adodb_date len=168)

DT 1975-05-22 19:31:11 pm PM 22 Thu May 7 19 07 19 31 22 Thursday 0 05 May 5 +0900 RFC822 Thu, 22 May 1975 19:31:11 +0900 11 31 169986671 4 75 1975 141 32400 2003 Error date(): 169986671
 
  "date CDT 1975-05-22 19:31:11 pm PM 22 Thu May 7 19 07 19 31 22 Thursday 0 05 May 5 +0900 RFC822 Thu, 22 May 1975 19:31:11 +0900 11 31 169986671 4 75 1975 141 32400 2003" (date len=168)
  "date CST 1975-05-22 18:31:11 pm PM 22 Thu May 6 18 06 18 31 22 Thursday 0 05 May 5 +0800 RFC822 Thu, 22 May 1975 18:31:11 +0800 11 31 169986671 4 75 1975 141 28800 2003" (adodb_date len=168)

Error getdate() 169986671
Array ( [seconds] => 11 [minutes] => 31 [hours] => 19 [mday] => 22 [wday] => 4 [mon] => 5 [year] => 1975 [yday] => 141 [weekday] => Thursday [month] => May [0] => 169986671 )
Array ( [seconds] => 11 [minutes] => 31 [hours] => 18 [mday] => 22 [wday] => 4 [mon] => 5 [year] => 1975 [yday] => 141 [weekday] => Thursday [month] => May [0] => 169986671 )

08 Aug 1976 23:36:19 +0800 19 31 208366579 0 76 1976 220 28800 2003 Error date(): 208366579

 
  "date CST 1976-08-08 23:36:19 pm PM 08 Sun August 11 23 11 23 36 8 Sunday 1 08 Aug 8 +0800 RFC822 Sun, 08 Aug 1976 23:36:19 +0800 19 31 208366579 0 76 1976 220 28800 2003" (date len=169)
  "date CST 1976-08-08 23:36:19 pm PM 08 Sun August 11 23 11 23 36 8 Sunday 1 08 Aug 8 +0800 RFC822 Sun,  8 Aug 1976 23:36:19 +0800 19 31 208366579 0 76 1976 220 28800 2003" (adodb_date len=169)

07 Dec 1976 18:44:37 +0800 37 31 218803477 2 76 1976 341 28800 2003 Error date(): 218803477
 
  "date CST 1976-12-07 18:44:37 pm PM 07 Tue December 6 18 06 18 44 7 Tuesday 1 12 Dec 12 +0800 RFC822 Tue, 07 Dec 1976 18:44:37 +0800 37 31 218803477 2 76 1976 341 28800 2003" (date len=172)
  "date CST 1976-12-07 18:44:37 pm PM 07 Tue December 6 18 06 18 44 7 Tuesday 1 12 Dec 12 +0800 RFC822 Tue,  7 Dec 1976 18:44:37 +0800 37 31 218803477 2 76 1976 341 28800 2003" (adodb_date len=172)

06 Nov 1978 18:11:11 +0800 11 30 279195071 1 78 1978 309 28800 2003 Error date(): 279195071
 
  "date CST 1978-11-06 18:11:11 pm PM 06 Mon November 6 18 06 18 11 6 Monday 0 11 Nov 11 +0800 RFC822 Mon, 06 Nov 1978 18:11:11 +0800 11 30 279195071 1 78 1978 309 28800 2003" (date len=171)
  "date CST 1978-11-06 18:11:11 pm PM 06 Mon November 6 18 06 18 11 6 Monday 0 11 Nov 11 +0800 RFC822 Mon,  6 Nov 1978 18:11:11 +0800 11 30 279195071 1 78 1978 309 28800 2003" (adodb_date len=171)

DT 1975-05-25 13:32:09 pm PM 25 Sun May 1 13 01 13 32 25 Sunday 0 05 May 5 +0900 RFC822 Sun, 25 May 1975 13:32:09 +0900 09 31 170224329 0 75 1975 144 32400 2003 Error date(): 170224329
 
  "date CDT 1975-05-25 13:32:09 pm PM 25 Sun May 1 13 01 13 32 25 Sunday 0 05 May 5 +0900 RFC822 Sun, 25 May 1975 13:32:09 +0900 09 31 170224329 0 75 1975 144 32400 2003" (date len=166)
  "date CST 1975-05-25 12:32:09 pm PM 25 Sun May 12 12 12 12 32 25 Sunday 0 05 May 5 +0800 RFC822 Sun, 25 May 1975 12:32:09 +0800 09 31 170224329 0 75 1975 144 28800 2003" (adodb_date len=167)

Error getdate() 170224329
Array ( [seconds] => 9 [minutes] => 32 [hours] => 13 [mday] => 25 [wday] => 0 [mon] => 5 [year] => 1975 [yday] => 144 [weekday] => Sunday [month] => May [0] => 170224329 )
Array ( [seconds] => 9 [minutes] => 32 [hours] => 12 [mday] => 25 [wday] => 0 [mon] => 5 [year] => 1975 [yday] => 144 [weekday] => Sunday [month] => May [0] => 170224329 )

DT 1974-09-07 11:42:20 am AM 07 Sat September 11 11 11 11 42 7 Saturday 0 09 Sep 9 +0900 RFC822 Sat, 07 Sep 1974 11:42:20 +0900 20 30 147753740 6 74 1974 249 32400 2003 Error date(): 147753740

 
  "date CDT 1974-09-07 11:42:20 am AM 07 Sat September 11 11 11 11 42 7 Saturday 0 09 Sep 9 +0900 RFC822 Sat, 07 Sep 1974 11:42:20 +0900 20 30 147753740 6 74 1974 249 32400 2003" (date len=174)
  "date CST 1974-09-07 10:42:20 am AM 07 Sat September 10 10 10 10 42 7 Saturday 0 09 Sep 9 +0800 RFC822 Sat,  7 Sep 1974 10:42:20 +0800 20 30 147753740 6 74 1974 249 28800 2003" (adodb_date len=174)

Error getdate() 147753740
Array ( [seconds] => 20 [minutes] => 42 [hours] => 11 [mday] => 7 [wday] => 6 [mon] => 9 [year] => 1974 [yday] => 249 [weekday] => Saturday [month] => September [0] => 147753740 )
Array ( [seconds] => 20 [minutes] => 42 [hours] => 10 [mday] => 7 [wday] => 6 [mon] => 9 [year] => 1974 [yday] => 249 [weekday] => Saturday [month] => September [0] => 147753740 )

DT 1974-08-12 06:48:11 am AM 12 Mon August 6 6 06 06 48 12 Monday 0 08 Aug 8 +0900 RFC822 Mon, 12 Aug 1974 06:48:11 +0900 11 31 145489691 1 74 1974 223 32400 2003 Error date(): 145489691

 
  "date CDT 1974-08-12 06:48:11 am AM 12 Mon August 6 6 06 06 48 12 Monday 0 08 Aug 8 +0900 RFC822 Mon, 12 Aug 1974 06:48:11 +0900 11 31 145489691 1 74 1974 223 32400 2003" (date len=168)
  "date CST 1974-08-12 05:48:11 am AM 12 Mon August 5 5 05 05 48 12 Monday 0 08 Aug 8 +0800 RFC822 Mon, 12 Aug 1974 05:48:11 +0800 11 31 145489691 1 74 1974 223 28800 2003" (adodb_date len=168)

Error getdate() 145489691
Array ( [seconds] => 11 [minutes] => 48 [hours] => 6 [mday] => 12 [wday] => 1 [mon] => 8 [year] => 1974 [yday] => 223 [weekday] => Monday [month] => August [0] => 145489691 )
Array ( [seconds] => 11 [minutes] => 48 [hours] => 5 [mday] => 12 [wday] => 1 [mon] => 8 [year] => 1974 [yday] => 223 [weekday] => Monday [month] => August [0] => 145489691 )

DT 1975-04-06 02:06:51 am AM 06 Sun April 2 2 02 02 06 6 Sunday 0 04 Apr 4 +0900 RFC822 Sun, 06 Apr 1975 02:06:51 +0900 51 30 165949611 0 75 1975 95 32400 2003 Error date(): 165949611

 
  "date CDT 1975-04-06 02:06:51 am AM 06 Sun April 2 2 02 02 06 6 Sunday 0 04 Apr 4 +0900 RFC822 Sun, 06 Apr 1975 02:06:51 +0900 51 30 165949611 0 75 1975 95 32400 2003" (date len=165)
  "date CST 1975-04-06 01:06:51 am AM 06 Sun April 1 1 01 01 06 6 Sunday 0 04 Apr 4 +0800 RFC822 Sun,  6 Apr 1975 01:06:51 +0800 51 30 165949611 0 75 1975 95 28800 2003" (adodb_date len=165)

Error getdate() 165949611
Array ( [seconds] => 51 [minutes] => 6 [hours] => 2 [mday] => 6 [wday] => 0 [mon] => 4 [year] => 1975 [yday] => 95 [weekday] => Sunday [month] => April [0] => 165949611 )
Array ( [seconds] => 51 [minutes] => 6 [hours] => 1 [mday] => 6 [wday] => 0 [mon] => 4 [year] => 1975 [yday] => 95 [weekday] => Sunday [month] => April [0] => 165949611 )

06 Feb 1979 08:17:43 +0800 43 28 287108263 2 79 1979 36 28800 2003 Error date(): 287108263

 
  "date CST 1979-02-06 08:17:43 am AM 06 Tue February 8 8 08 08 17 6 Tuesday 0 02 Feb 2 +0800 RFC822 Tue, 06 Feb 1979 08:17:43 +0800 43 28 287108263 2 79 1979 36 28800 2003" (date len=169)
  "date CST 1979-02-06 08:17:43 am AM 06 Tue February 8 8 08 08 17 6 Tuesday 0 02 Feb 2 +0800 RFC822 Tue,  6 Feb 1979 08:17:43 +0800 43 28 287108263 2 79 1979 36 28800 2003" (adodb_date len=169)

08 May 1983 22:05:14 +0800 14 31 421250714 0 83 1983 127 28800 2003 Error date(): 421250714
 
  "date CST 1983-05-08 22:05:14 pm PM 08 Sun May 10 22 10 22 05 8 Sunday 0 05 May 5 +0800 RFC822 Sun, 08 May 1983 22:05:14 +0800 14 31 421250714 0 83 1983 127 28800 2003" (date len=166)
  "date CST 1983-05-08 22:05:14 pm PM 08 Sun May 10 22 10 22 05 8 Sunday 0 05 May 5 +0800 RFC822 Sun,  8 May 1983 22:05:14 +0800 14 31 421250714 0 83 1983 127 28800 2003" (adodb_date len=166)

06 Feb 1976 09:32:54 +0800 54 29 192418374 5 76 1976 36 28800 2003 Error date(): 192418374
 
  "date CST 1976-02-06 09:32:54 am AM 06 Fri February 9 9 09 09 32 6 Friday 1 02 Feb 2 +0800 RFC822 Fri, 06 Feb 1976 09:32:54 +0800 54 29 192418374 5 76 1976 36 28800 2003" (date len=168)
  "date CST 1976-02-06 09:32:54 am AM 06 Fri February 9 9 09 09 32 6 Friday 1 02 Feb 2 +0800 RFC822 Fri,  6 Feb 1976 09:32:54 +0800 54 29 192418374 5 76 1976 36 28800 2003" (adodb_date len=168)

DT 1975-05-22 22:24:02 pm PM 22 Thu May 10 22 10 22 24 22 Thursday 0 05 May 5 +0900 RFC822 Thu, 22 May 1975 22:24:02 +0900 02 31 169997042 4 75 1975 141 32400 2003 Error date(): 169997042
 
  "date CDT 1975-05-22 22:24:02 pm PM 22 Thu May 10 22 10 22 24 22 Thursday 0 05 May 5 +0900 RFC822 Thu, 22 May 1975 22:24:02 +0900 02 31 169997042 4 75 1975 141 32400 2003" (date len=169)
  "date CST 1975-05-22 21:24:02 pm PM 22 Thu May 9 21 09 21 24 22 Thursday 0 05 May 5 +0800 RFC822 Thu, 22 May 1975 21:24:02 +0800 02 31 169997042 4 75 1975 141 28800 2003" (adodb_date len=168)

DT 1974-07-27 18:38:16 pm PM 27 Sat July 6 18 06 18 38 27 Saturday 0 07 Jul 7 +0900 RFC822 Sat, 27 Jul 1974 18:38:16 +0900 16 31 144149896 6 74 1974 207 32400 2003 Error date(): 144149896
 
  "date CDT 1974-07-27 18:38:16 pm PM 27 Sat July 6 18 06 18 38 27 Saturday 0 07 Jul 7 +0900 RFC822 Sat, 27 Jul 1974 18:38:16 +0900 16 31 144149896 6 74 1974 207 32400 2003" (date len=169)
  "date CST 1974-07-27 17:38:16 pm PM 27 Sat July 5 17 05 17 38 27 Saturday 0 07 Jul 7 +0800 RFC822 Sat, 27 Jul 1974 17:38:16 +0800 16 31 144149896 6 74 1974 207 28800 2003" (adodb_date len=169)

Error getdate() 144149896
Array ( [seconds] => 16 [minutes] => 38 [hours] => 18 [mday] => 27 [wday] => 6 [mon] => 7 [year] => 1974 [yday] => 207 [weekday] => Saturday [month] => July [0] => 144149896 )
Array ( [seconds] => 16 [minutes] => 38 [hours] => 17 [mday] => 27 [wday] => 6 [mon] => 7 [year] => 1974 [yday] => 207 [weekday] => Saturday [month] => July [0] => 144149896 )

07 Jul 1977 09:38:24 +0800 24 31 237087504 4 77 1977 187 28800 2003 Error date(): 237087504

 
  "date CST 1977-07-07 09:38:24 am AM 07 Thu July 9 9 09 09 38 7 Thursday 0 07 Jul 7 +0800 RFC822 Thu, 07 Jul 1977 09:38:24 +0800 24 31 237087504 4 77 1977 187 28800 2003" (date len=167)
  "date CST 1977-07-07 09:38:24 am AM 07 Thu July 9 9 09 09 38 7 Thursday 0 07 Jul 7 +0800 RFC822 Thu,  7 Jul 1977 09:38:24 +0800 24 31 237087504 4 77 1977 187 28800 2003" (adodb_date len=167)

07 Sep 1973 07:32:41 +0800 41 30 116206361 5 73 1973 249 28800 2003 Error date(): 116206361
 
  "date CST 1973-09-07 07:32:41 am AM 07 Fri September 7 7 07 07 32 7 Friday 0 09 Sep 9 +0800 RFC822 Fri, 07 Sep 1973 07:32:41 +0800 41 30 116206361 5 73 1973 249 28800 2003" (date len=170)
  "date CST 1973-09-07 07:32:41 am AM 07 Fri September 7 7 07 07 32 7 Friday 0 09 Sep 9 +0800 RFC822 Fri,  7 Sep 1973 07:32:41 +0800 41 30 116206361 5 73 1973 249 28800 2003" (adodb_date len=170)

01 Nov 1978 03:54:39 +0800 39 30 278711679 3 78 1978 304 28800 2003 Error date(): 278711679
 
  "date CST 1978-11-01 03:54:39 am AM 01 Wed November 3 3 03 03 54 1 Wednesday 0 11 Nov 11 +0800 RFC822 Wed, 01 Nov 1978 03:54:39 +0800 39 30 278711679 3 78 1978 304 28800 2003" (date len=173)
  "date CST 1978-11-01 03:54:39 am AM 01 Wed November 3 3 03 03 54 1 Wednesday 0 11 Nov 11 +0800 RFC822 Wed,  1 Nov 1978 03:54:39 +0800 39 30 278711679 3 78 1978 304 28800 2003" (adodb_date len=173)

09 Jul 1977 04:08:49 +0800 49 31 237240529 6 77 1977 189 28800 2003 Error date(): 237240529
 
  "date CST 1977-07-09 04:08:49 am AM 09 Sat July 4 4 04 04 08 9 Saturday 0 07 Jul 7 +0800 RFC822 Sat, 09 Jul 1977 04:08:49 +0800 49 31 237240529 6 77 1977 189 28800 2003" (date len=167)
  "date CST 1977-07-09 04:08:49 am AM 09 Sat July 4 4 04 04 08 9 Saturday 0 07 Jul 7 +0800 RFC822 Sat,  9 Jul 1977 04:08:49 +0800 49 31 237240529 6 77 1977 189 28800 2003" (adodb_date len=167)

09 Mar 1976 11:23:51 +0800 51 31 195189831 2 76 1976 68 28800 2003 Error date(): 195189831
 
  "date CST 1976-03-09 11:23:51 am AM 09 Tue March 11 11 11 11 23 9 Tuesday 1 03 Mar 3 +0800 RFC822 Tue, 09 Mar 1976 11:23:51 +0800 51 31 195189831 2 76 1976 68 28800 2003" (date len=168)
  "date CST 1976-03-09 11:23:51 am AM 09 Tue March 11 11 11 11 23 9 Tuesday 1 03 Mar 3 +0800 RFC822 Tue,  9 Mar 1976 11:23:51 +0800 51 31 195189831 2 76 1976 68 28800 2003" (adodb_date len=168)

09 Jun 1977 05:15:42 +0800 42 30 234652542 4 77 1977 159 28800 2003 Error date(): 234652542
 
  "date CST 1977-06-09 05:15:42 am AM 09 Thu June 5 5 05 05 15 9 Thursday 0 06 Jun 6 +0800 RFC822 Thu, 09 Jun 1977 05:15:42 +0800 42 30 234652542 4 77 1977 159 28800 2003" (date len=167)
  "date CST 1977-06-09 05:15:42 am AM 09 Thu June 5 5 05 05 15 9 Thursday 0 06 Jun 6 +0800 RFC822 Thu,  9 Jun 1977 05:15:42 +0800 42 30 234652542 4 77 1977 159 28800 2003" (adodb_date len=167)

08 Jan 1971 04:35:09 +0800 09 31 32128509 5 71 1971 7 28800 2003 Error date(): 32128509
 
  "date CST 1971-01-08 04:35:09 am AM 08 Fri January 4 4 04 04 35 8 Friday 0 01 Jan 1 +0800 RFC822 Fri, 08 Jan 1971 04:35:09 +0800 09 31 32128509 5 71 1971 7 28800 2003" (date len=165)
  "date CST 1971-01-08 04:35:09 am AM 08 Fri January 4 4 04 04 35 8 Friday 0 01 Jan 1 +0800 RFC822 Fri,  8 Jan 1971 04:35:09 +0800 09 31 32128509 5 71 1971 7 28800 2003" (adodb_date len=165)

08 Jan 1979 23:37:16 +0800 16 31 284657836 1 79 1979 7 28800 2003 Error date(): 284657836
 
  "date CST 1979-01-08 23:37:16 pm PM 08 Mon January 11 23 11 23 37 8 Monday 0 01 Jan 1 +0800 RFC822 Mon, 08 Jan 1979 23:37:16 +0800 16 31 284657836 1 79 1979 7 28800 2003" (date len=168)
  "date CST 1979-01-08 23:37:16 pm PM 08 Mon January 11 23 11 23 37 8 Monday 0 01 Jan 1 +0800 RFC822 Mon,  8 Jan 1979 23:37:16 +0800 16 31 284657836 1 79 1979 7 28800 2003" (adodb_date len=168)

DT 1974-06-03 13:23:27 pm PM 03 Mon June 1 13 01 13 23 3 Monday 0 06 Jun 6 +0900 RFC822 Mon, 03 Jun 1974 13:23:27 +0900 27 30 139465407 1 74 1974 153 32400 2003 Error date(): 139465407
 
  "date CDT 1974-06-03 13:23:27 pm PM 03 Mon June 1 13 01 13 23 3 Monday 0 06 Jun 6 +0900 RFC822 Mon, 03 Jun 1974 13:23:27 +0900 27 30 139465407 1 74 1974 153 32400 2003" (date len=166)
  "date CST 1974-06-03 12:23:27 pm PM 03 Mon June 12 12 12 12 23 3 Monday 0 06 Jun 6 +0800 RFC822 Mon,  3 Jun 1974 12:23:27 +0800 27 30 139465407 1 74 1974 153 28800 2003" (adodb_date len=167)

Error getdate() 139465407
Array ( [seconds] => 27 [minutes] => 23 [hours] => 13 [mday] => 3 [wday] => 1 [mon] => 6 [year] => 1974 [yday] => 153 [weekday] => Monday [month] => June [0] => 139465407 )
Array ( [seconds] => 27 [minutes] => 23 [hours] => 12 [mday] => 3 [wday] => 1 [mon] => 6 [year] => 1974 [yday] => 153 [weekday] => Monday [month] => June [0] => 139465407 )

02 Jul 1978 02:56:29 +0800 29 31 268167389 0 78 1978 182 28800 2003 Error date(): 268167389

 
  "date CST 1978-07-02 02:56:29 am AM 02 Sun July 2 2 02 02 56 2 Sunday 0 07 Jul 7 +0800 RFC822 Sun, 02 Jul 1978 02:56:29 +0800 29 31 268167389 0 78 1978 182 28800 2003" (date len=165)
  "date CST 1978-07-02 02:56:29 am AM 02 Sun July 2 2 02 02 56 2 Sunday 0 07 Jul 7 +0800 RFC822 Sun,  2 Jul 1978 02:56:29 +0800 29 31 268167389 0 78 1978 182 28800 2003" (adodb_date len=165)

DT 1979-07-04 17:28:35 pm PM 04 Wed July 5 17 05 17 28 4 Wednesday 0 07 Jul 7 +0900 RFC822 Wed, 04 Jul 1979 17:28:35 +0900 35 31 299924915 3 79 1979 184 32400 2003 Error date(): 299924915
 
  "date CDT 1979-07-04 17:28:35 pm PM 04 Wed July 5 17 05 17 28 4 Wednesday 0 07 Jul 7 +0900 RFC822 Wed, 04 Jul 1979 17:28:35 +0900 35 31 299924915 3 79 1979 184 32400 2003" (date len=169)
  "date CST 1979-07-04 16:28:35 pm PM 04 Wed July 4 16 04 16 28 4 Wednesday 0 07 Jul 7 +0800 RFC822 Wed,  4 Jul 1979 16:28:35 +0800 35 31 299924915 3 79 1979 184 28800 2003" (adodb_date len=169)

Error getdate() 299924915
Array ( [seconds] => 35 [minutes] => 28 [hours] => 17 [mday] => 4 [wday] => 3 [mon] => 7 [year] => 1979 [yday] => 184 [weekday] => Wednesday [month] => July [0] => 299924915 )
Array ( [seconds] => 35 [minutes] => 28 [hours] => 16 [mday] => 4 [wday] => 3 [mon] => 7 [year] => 1979 [yday] => 184 [weekday] => Wednesday [month] => July [0] => 299924915 )

DT 1975-04-22 17:24:55 pm PM 22 Tue April 5 17 05 17 24 22 Tuesday 0 04 Apr 4 +0900 RFC822 Tue, 22 Apr 1975 17:24:55 +0900 55 30 167387095 2 75 1975 111 32400 2003 Error date(): 167387095

 
  "date CDT 1975-04-22 17:24:55 pm PM 22 Tue April 5 17 05 17 24 22 Tuesday 0 04 Apr 4 +0900 RFC822 Tue, 22 Apr 1975 17:24:55 +0900 55 30 167387095 2 75 1975 111 32400 2003" (date len=169)
  "date CST 1975-04-22 16:24:55 pm PM 22 Tue April 4 16 04 16 24 22 Tuesday 0 04 Apr 4 +0800 RFC822 Tue, 22 Apr 1975 16:24:55 +0800 55 30 167387095 2 75 1975 111 28800 2003" (adodb_date len=169)

Error getdate() 167387095
Array ( [seconds] => 55 [minutes] => 24 [hours] => 17 [mday] => 22 [wday] => 2 [mon] => 4 [year] => 1975 [yday] => 111 [weekday] => Tuesday [month] => April [0] => 167387095 )
Array ( [seconds] => 55 [minutes] => 24 [hours] => 16 [mday] => 22 [wday] => 2 [mon] => 4 [year] => 1975 [yday] => 111 [weekday] => Tuesday [month] => April [0] => 167387095 )

09 Feb 1979 16:52:05 +0800 05 28 287398325 5 79 1979 39 28800 2003 Error date(): 287398325

 
  "date CST 1979-02-09 16:52:05 pm PM 09 Fri February 4 16 04 16 52 9 Friday 0 02 Feb 2 +0800 RFC822 Fri, 09 Feb 1979 16:52:05 +0800 05 28 287398325 5 79 1979 39 28800 2003" (date len=169)
  "date CST 1979-02-09 16:52:05 pm PM 09 Fri February 4 16 04 16 52 9 Friday 0 02 Feb 2 +0800 RFC822 Fri,  9 Feb 1979 16:52:05 +0800 05 28 287398325 5 79 1979 39 28800 2003" (adodb_date len=169)

03 Nov 1982 08:32:37 +0800 37 30 405131557 3 82 1982 306 28800 2003 Error date(): 405131557
 
  "date CST 1982-11-03 08:32:37 am AM 03 Wed November 8 8 08 08 32 3 Wednesday 0 11 Nov 11 +0800 RFC822 Wed, 03 Nov 1982 08:32:37 +0800 37 30 405131557 3 82 1982 306 28800 2003" (date len=173)
  "date CST 1982-11-03 08:32:37 am AM 03 Wed November 8 8 08 08 32 3 Wednesday 0 11 Nov 11 +0800 RFC822 Wed,  3 Nov 1982 08:32:37 +0800 37 30 405131557 3 82 1982 306 28800 2003" (adodb_date len=173)

Testing random dates between 100 and 4000

Testing 1970 to 1982, or 378432000 seconds, offset=65751: 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981

Failed :-(

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