PHP MySQL Date format Conflict

[GUIR]

Hello,

I inserted a date into mysql database Date type field as string in dd/mm/yyyy format.

example:


...

$arrival = '10/03/2008';
...
...



But when I query database records I get inserted date items as 0000-00-00.

I tried to solve this using many functions, but didn't work (strtotime, getdate, mktime, etc)

Could someone please let me know how to navigate between dates of PHP & MySQL.

I want to keep MySQL data type as Date because I need to query between dates later. Accordingly I will need date conversion extensively between PHP to MySQL and vice versa.

Thanks & Best Regards

[MrCoder]

Insert the date in the same format as MySQL uses.

YEAR-MONTH-DAY

2008-03-13

[chazzy]

Actually, that's just how MySQL displays the date. The data is typically stored in a much different format.

From PHP's end, you should just be formatting the data is it's returned to you in a way you like, than trying to force MySQL to format it for you.

[GUIR]

It worked after I format PHP string as YYYY-MM-DD format.

Thanks for your guidance.

[Huevoos]

I'd rather get the date using php's time() function and store it in mysql using UNIXTIMESTAMP()