MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Date calculations with Varchar fields
Posted by: William Chiquito
Date: October 18, 2008 04:24PM

Hi mark,

Try: 
SELECT DATEDIFF(CONVERT(outdate, DATETIME), CONVERT(indate, DATETIME)) AS DaysDiff FROM tablename;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Date calculations with Varchar fields
5607
mark zollo
October 13, 2008 03:11PM
Re: Date calculations with Varchar fields
2453
William Chiquito
October 18, 2008 04:24PM


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.