pillmill
asked on
Reference TimeStamp in Delete ?
Hi:
How do I reference TimeStamp data in a Delete query ?
I would like to delete all entries in a table that were
created before 2006. The data is stored in TimeStamp
format and is drawn from a linked MySQL table.
In Access, it appears as: 4/5/2006 1:47:25 PM
I would like to write a Delete SQL, such as:
DELETE * FROM Table WHERE TimeTS<2006;
Thanks,
Phil Miller
How do I reference TimeStamp data in a Delete query ?
I would like to delete all entries in a table that were
created before 2006. The data is stored in TimeStamp
format and is drawn from a linked MySQL table.
In Access, it appears as: 4/5/2006 1:47:25 PM
I would like to write a Delete SQL, such as:
DELETE * FROM Table WHERE TimeTS<2006;
Thanks,
Phil Miller
DELETE * FROM Table WHERE year(TimeTS)<2006
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.