29 Jul 2011 11:45 AM #1
Datefield format + mysql
As you know, to keep a date in mysql this should have the format Y-m-d. I really want to show the date format d-m-Y. I wonder if anyone can tell me if there is any way to handle this with ext or should I convert the date to mysql format before saving accepts?.
I appreciate any help you can offer.
29 Jul 2011 1:01 PM #2
31 Jul 2011 6:13 AM #3
Thanks for responding.
The problem is that if I use the format d-m-Y will not store well in the mysql database.
To save mysql must be in Y-m-d format. And I need the date is displayed to the user in the format d-m-Y.
31 Jul 2011 11:09 PM #4
You can format the date before inserting in DB.
1 Aug 2011 12:04 AM #5
Send date in timestamp format instead of dealing with format.--