Subscribe to this blog
Briefcase
Print
We all use dates as DBA’s in fact we use them all the time, every single day even without realising it. I often use T-SQL to show me the difference between dates, but this particular script I like because it gives me a countdown to RIAT, so on a bad day or even on a good day for that matter I can see just how long, or little time is left until we set off once again J
Here is a script I use for fun;
/*
-----------------------------------------------------------------
Fun with dates
-----------------------------------------------------------------
For more SQL resources, check out SQLServer365.blogspot.com
-----------------------------------------------------------------
You may alter this code for your own purposes.
You may republish altered code as long as you give due credit.
You must obtain prior permission before blogging this code.
THIS CODE AND INFORMATION ARE PROVIDED "AS IS"
-----------------------------------------------------------------
*/
-- Set database context
USE master;
GO
-- Declare variables
DECLARE @startTime DATETIME
DECLARE @endTime DATETIME
DECLARE @Seconds INT
-- Set date range
SET @startTime = GETDATE()
SET @endTime = '20130719 04:30'
-- Get the difference in seconds
SELECT @Seconds = DATEDIFF(ss, @startTime,@endTime);
-- Return how long left
SELECT 'T Minus ' + CONVERT(VARCHAR(10), ( @Seconds / 86400 )) + ' Days '
+ CONVERT(VARCHAR(10), ( ( @Seconds % 86400 ) / 3600 )) + ' Hours '
+ CONVERT(VARCHAR(10), ( ( ( @Seconds % 86400 ) % 3600 ) / 60 ))
+ ' Minutes ' + CONVERT(VARCHAR(10), ( ( ( @Seconds % 86400 ) % 3600 )
% 60 )) + ' Seconds and counting!';
GO
Enjoy!
Chris
Loading comments...