Get the Time Part of a Date/Time Value

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 172
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

Comments or Responses

Login to post response