Re: Query
| From: | Tatang Widyanto | Date: | Tue, 16 Apr 2002 14:45:00 +0000 |
| Subject: | Re: Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18547@lists.php.net to get a copy of this message | ||
On Tue, 16 Apr 2002 15:04:25 +0200
Jeroen Timmers <maillist@start4me.nl> wrote:
> hello,
>
> i have a table with a datetime field,
> now i want to view al the records
> with time 12:00:00 and the date is
> not important.
>
> Who could help me?
>
> Jeroen
>
>
Try this :
SELECT * FROM TableName WHERE EXTRACT(HOUR_SECOND FROM FieldName) = '120000'
deZayner