[SOLVED] change date format

[zgkhoo]

how to change mysql default date format to ddmmyyyy or dd-mm-yyyy?

where user only need enter ddmmyyyy or dd-mm-yyyy in the form <input type=text>

thanks..

[Barand]

MySQL default format of yyyy-mm-dd is that for a reason.

 

It's ISO standard and you can do comparisons/sorts with that format.

 

dd-mm-yyyy is totally useless as a db date format.

[zgkhoo]

but in my country the default is dd-mm-yyyy

then how i gonna to do ...if i wanna let user key in dd-mm-yyyy in <input type=text> field?

thanks.

[fenway]

but in my country the default is dd-mm-yyyy

then how i gonna to do ...if i wanna let user key in dd-mm-yyyy in <input type=text> field?

thanks.

Use a date picker and format the string internally... if you must keep it that way, use the STR_TO_DATE() mysql function and specify a format string.

[zgkhoo]

what is date picker?

[fenway]

A fancy HTML widget that displays calendar-looking things and translates this into an sql-ready date for you.

[zgkhoo]

ok, got it,

thanks  you very much..