question

Fatherjack avatar image
Fatherjack asked

How Long is it to SQLBits8?

This is a question I keep asking myself and have to keep looking at my calendar and counting the weeks. Can anyone suggest a better way of keeping track?
sqlbitsfriday-challengejust-for-fun
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
I have this: DECLARE @LeavingForSQLBits DATETIME DECLARE @SQLBitsStart DATETIME SET @LeavingForSQLBits = SET @SQLBitsStart = SELECT STR(FLOOR(CAST(@LeavingForSQLBits - GETDATE() AS FLOAT)), 5) + ' Day(s) ' + CONVERT(CHAR(8), @LeavingForSQLBits - GETDATE(), 108) AS [Until you leave for SQLBits] , STR(FLOOR(CAST(@SQLBitsStart - GETDATE() AS FLOAT)), 5) + ' Day(s) ' + CONVERT(CHAR(8), @SQLBitsStart - GETDATE(), 108) AS [Until SQLBits starts] go Any other ideas?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
I used to write a little VB application that put a calculator-style countdown in the top left of the screen while I was counting down to particular dates (usually my departure from a job...) The number of seconds until something is quite depressing when I started, but it's good to see it drop by 200k over a weekend...
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ought to convert it to a web app and have it online somewhere ...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.