HI you can use DATE_FORMAT function of my sql.u can get date in any form u like e.g DATE_FORMAT(table column name,%Y-%M-%D) or DATE_FORMAT(table column name,%D-%M-%Y) it will give u the desire format. u can switch D , M , Y to suite ur requirements. cheers YAKHAN ________________________________ From: Hari KT <kthari85@xxxxxxxxxxx> To: php-objects@xxxxxxxxxxxxxxx Sent: Tuesday, April 28, 2009 7:23:22 PM Subject: Re: PHP-MYSQL Date Help 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@ yahoo.com> wrote: From: rai.suman <sumanraic001@ yahoo.com> Subject: PHP-MYSQL Date Help To: php-objects@ yahoogroups. com 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] [Non-text portions of this message have been removed]
