[RESOLVED] insert date to db

[Pehape]

my input text box let user insert date

but when i insert it to db..

the data come with 2014-12-22 (year-month-day)
i want d,m,Y format.. how to ? thanks

[cgraz]

mysql only stores in yyyy-mm-dd. I want day - month - year too; its how I read dates. You'll need to store how MySQL wants, though. 😉

Fortunately, you can use DATE_FORMAT( ) to format the date so your query returns it in d-m-Y (assuming you have the correct field type).

SELECT DATE_FORMAT(date_field, '%d-%m-%Y') AS dmy FROM your_table

[Pehape]

but if user input '12-09-2006' then in mysql it will '2012-09-20'
is allright with that? the year 2012, and so the day 20 ??

[Installer]

This is why it's a bad idea to use text entry for inputting dates. You really have no idea what format the user is following. What is "05-06-07", or "01-02-2006"? Use, e.g., drop-down selects for month, day, and year. Then you know exactly what is intended, with the bonus that you can then easily assemble the date parts into a db-compatible format, and/or your own preferred format for display, date artithmetic, php function use, etc.

[Pehape]

yeah, installer, that's the way it is...
thanks...this thread resolved.