Date Format
Posted: Wed Jul 23, 2003 10:41 am
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?
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?