All - I'm trying to use DBI to read a MS Access db. One of the columns in
the DB is a Date/Time type. I'm trying to query on a range of times.
The following works in MySQL off the command line where S_TIME is a DATETIME
column, so I thought the MS Access call would be the same:
select * from sa where (S_TIME > (timestamp'2001-12-04 13:00:00'))
Trying to talk to Access, I used the following:
$sth_select = $dbh_MSAccess->prepare("SELECT * FROM $table where (S_TIME >
(timestamp('2001-12-04 13:00:00') ))");
However, I get the following error (it doesn't know what the timestamp
function is):
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]
Undefine
d function 'timestamp' in expression. (SQL-37000)(DBD: st_execute/SQLExecute
err
=-1) at D:\Agile\Projects\FBCB2\Apr_02\Data\accToMySql_vload2.pl line 171.
SELECT execute ERROR for sa table: DBI::db=HASH(0x236cc78)->errstr
Is this a quirk with Access - seemed to work ok with MySQL.
Any suggestions/workarounds?
Thanks,
Mark
-
Mark Riehl
Agile Communications, Inc.
Email: [EMAIL PROTECTED]
Office: (732) 528-9305
Fax: (732) 528-9308
Cell: (732) 996-7630
