|
|
Posted by Gordon Burditt on 10/08/06 04:36
>SQL query code doesn't work. I connect to My SQL Server. and
>'StartDate' is the name of textbox. it forms 07/10/2006
>Thus, I receive two dates as $StartD and $EndD.
07/10/2006 is NOT the date format that MySQL uses. MySQL wants
2006-07-10 or 2006-10-07, depending on what country's date format
07/10/2006 is intended to be.
If you wish to convert TO MySQL's date format, try str_to_date().
If you wish to convert FROM MySQL's date format to some other format,
try date_format().
Navigation:
[Reply to this message]
|