The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> Datepicker cant be saved into mysql db
ishan
post 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 ?
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 29th March 2024 - 07:01 AM