MySQL Forums
Forum List  »  MySQL Query Browser

Converting a 10 char date to Standard date for MsSQL
Posted by: ian smith
Date: June 03, 2010 10:16AM

My MS Sql uses the standard format '2010-03-30 15:29:45.403' as its date format. The database i received from a customer has the date format '1237497245' For the MySQL database, i understand this is nice for PHP but now i need to switch it over threw a query for Visual Studio to read it properly.I tried a bunch of functions but none to any prevail.

Long Story short '1237497245' --> '2010-03-30 15:29:45.403' date format in a SQL query.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Converting a 10 char date to Standard date for MsSQL
June 03, 2010 10:16AM


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.