MySQL Forums :: Newbie :: Curdate() returning one day old date


Advanced Search

Curdate() returning one day old date
Posted by: Pradeep Kumar Sharma ()
Date: May 11, 2011 11:50PM

Hi,

When I m trying the get today date in mysql it is showing one day old date. Even I already checked the date from control penal. it is 12-May-2011.

Why my "select date()" returning wrong date. what could be the setting at mysql level.

select curdate() ---- 2011-05-11

Thanks in Advance
Pradeep

Options: ReplyQuote


Subject Written By Posted
Curdate() returning one day old date Pradeep Kumar Sharma 05/11/2011 11:50PM
Re: Curdate() returning one day old date Madhusmita Pradhan 05/13/2011 12:16AM
Re: Curdate() returning one day old date Rick James 05/13/2011 09:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.