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