Calculating Difference between Two dates in terms of Hours.

Posted by vishalneeraj-24503 under Sql Server category on 9/30/2014 | Points: 40 | Views : 774

If you want to find out the difference in terms on Hours,just divide the above result by 3600

SELECT (UNIX_TIMESTAMP('2013-11-09 00:00:00') - 
        UNIX_TIMESTAMP('2012-10-07 00:00:00'))/3600 from table_name;

Bookmark It

Latest Code Snipptes