MySQL Forums
Forum List  »  Knowledge Base

mysql conversion function
Posted by: jack sparrow
Date: June 18, 2009 07:03AM

I am getting when converting the function
This is my statement

SELECT CONVERT('01/01/1970', DATETIME);
O/p is NULL

When i change the date it's working

SELECT CONVERT('1970/01/01', DATETIME);
1970-01-01 00:00:00

I want the same output for the above statement .
Can someone help me out.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql conversion function
3884
June 18, 2009 07:03AM
1824
June 19, 2009 09:49AM


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.