| Subject | Re: [firebird-support] Get all records posted at a specific time |
|---|---|
| Author | Martijn Tonies |
| Post date | 2005-05-17T14:47:41Z |
> How can I see all the records posted at a specific time? My tables have aAM'
> CREATED column which is populated with a value like '5/16/2005 10:05:44
>where created = '5/16/2005 10:05:44'
>
>
> However, the following SQL:
>
>
>
> select * from scheduled_work
>
> where created = '5/16/2005 10:05:44 AM'
should do it.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com