Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @datetime datetime;
- set @datetime = getdate();
- select @datetime;
- select dateadd(year,datediff(year,0,@datetime),0);
- select dateadd(month,datediff(month,0,@datetime),0);
- select dateadd(day,datediff(day,0,@datetime),0);
- select dateadd(hour,datediff(hour,0,@datetime),0);
- select dateadd(minute,datediff(minute,0,@datetime),0);
- select dateadd(second,datediff(second,'2000-01-01',@datetime),'2000-01-01');
- SELECT CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS float)) AS DATETIME)
Add Comment
Please, Sign In to add comment