Page 1 of 1

Date Formating

Posted: Wed Jul 23, 2003 10:42 am
by gurjit
I have a datetime field type in a table which stores the date like this

2003-07-23 16:38

i'm running a query to search a date range but i cannot get the query to just look at the date part in the WHERE statement

WHERE f_date_closed = '$today_search'

the f_date_closed has date stored like 2003-07-23 16:38 but i am searching for 2003-07-23 in the today_search parameter.

How do you only pull the date in the f_date_closed field and ignore the time?

Posted: Wed Jul 23, 2003 11:06 am
by AVATAr
if you are using mysql check the DATE_FORMAT function (http://www.mysql.com/doc/en/Date_and_ti ... tions.html)