Get the Time Part of a Date/Time Value

Posted by Vishalneeraj-24503 under Sql Server category on 5/24/2015 | Points: 40 | Views : 1237

SELECT GETDATE(),CAST(CAST(GETDATE() AS FLOAT) - FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME);

2015-04-07 15:32:28.100
1900-01-01 15:32:28.097

Bookmark It

Latest Code Snipptes