code_junkie

Floor a date in SQL server

Nov 10th, 2011
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. declare @datetime datetime;
  2. set @datetime = getdate();
  3. select @datetime;
  4. select dateadd(year,datediff(year,0,@datetime),0);
  5. select dateadd(month,datediff(month,0,@datetime),0);
  6. select dateadd(day,datediff(day,0,@datetime),0);
  7. select dateadd(hour,datediff(hour,0,@datetime),0);
  8. select dateadd(minute,datediff(minute,0,@datetime),0);
  9. select dateadd(second,datediff(second,'2000-01-01',@datetime),'2000-01-01');
  10.  
  11. SELECT CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS float)) AS DATETIME)
Add Comment
Please, Sign In to add comment