Hi ,
MySQL store date as YY-MM-DD , something like this 2009-04-15 . So you need to do the appropriate function to convert it . You can use the explode method
list($month, $date, $year) = explode("/", $data);
and combine and store in MySQL .
Cheers
Hari K T
http://www.harikt.com/
http://ijust4u.blogspot.com/
--- On Tue, 28/4/09, rai.suman <sumanraic001@xxxxxxxxx> wrote:
From: rai.suman <sumanraic001@xxxxxxxxx>
Subject: PHP-MYSQL Date Help
To: php-objects@xxxxxxxxxxxxxxx
Date: Tuesday, 28 April, 2009, 10:34 AM
Hello Everyone!
How is life there, Hope everything is cool and fine.
Actually, I have a problem:
1) I have a Date column in MySQL database.
I insert date from HTML form in 27-04-2009 (dd-mm-yyyy) format.
But in mysql database it stores wrong data like (2704-02-02) like this.
How it happen.
Anybody can help me ?
How to convert MySQL date and PHP DATE ??
Regards & Thank You,
Suman K. Rai
Now surf faster and smarter ! Check out the new Firefox 3 - Yahoo! Edition http://downloads.yahoo.com/in/firefox/?fr=om_email_firefox
[Non-text portions of this message have been removed]
