Datepicker cant be saved into mysql db |
Datepicker cant be saved into mysql db |
ishan |
Apr 11 2011, 02:31 AM
Post
#1
|
Novice Group: Members Posts: 26 Joined: 23-November 06 Member No.: 1,070 |
Hi,
Using jquery datepicker,I have the format of the date returned from Datepicker as (yy-mm-dd) which returns the string as 2011-04-22. When I want to INSERT it in the MySQL table in the column with datatype as DATE, I get 0000-00-00 saved. Browsing through SO, I found suggestions about FROM_UNIXTIME, but this gives me the date as 1970-01-01. Any help ? |
Lo-Fi Version | Time is now: 25th April 2024 - 01:30 AM |