Except for TO_CHAR() which is Oracle-specific, it should be pretty much the
same. I don't use Access, but you should be able to find the date
conversion function in Access's SQL builder or Help.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 17, 2001 23:53
Subject: How to delete records from MS Access DB.
> How I can delete records from MS Access DB using DBI module.
> I want to delete a records which are "too" old.
>
> This would be easy if I could use Oracle DB then would work like this.
>
> _____
> my $accessth = $Access_dbh->prepare( q{delete from Data
> where (DATE_TIME < to_date('2001-06-01 12:30:00', 'YYYY-MM-DD HH24:MI:SS')
> }) || die "Can't prepare statement: $DBI::errstr";
>
> my $rv = $accessth->execute() || die "Can't execute statement:
> $DBI::errstr";
> _____
>
> But how to do it with Access DB?
