On Tue, 16 Apr 2002 15:04:25 +0200
Jeroen Timmers <[EMAIL PROTECTED]> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to