I have the following piece of code to format the date from my Query.
but the %c is for the monthy removes the 0 (zero) on months 01-09. is there a format that will retain the zero or do i need to figure a way to get that zero back in the variable.
The Reason is because I need to compair $the_date with $new_date = date ('Y/m/d')
the select date_format results is 2006/9/20 and the date function results is 2006/09/20
and the are not the same.
Thanks
-C
PHP Code:
SELECT date_format(my_date, '%Y%c/%d') AS the_date
The Reason is because I need to compair $the_date with $new_date = date ('Y/m/d')
the select date_format results is 2006/9/20 and the date function results is 2006/09/20
and the are not the same.
Thanks
-C
Comment