Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

New Year's Eve Expand / Collapse
Author
Message
Posted Wednesday, January 1, 2014 10:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
Revenant (12/31/2013)

I thought it was understood that QotDs assume default SQL Server installation settings - if we veered off into region-specific settings, QotDs would have to have a dozen lines of code before you would get to the gist of the question.


+1




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1526919
Posted Thursday, January 2, 2014 12:08 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, December 18, 2014 10:56 AM
Points: 3,417, Visits: 2,035
Nice question to end the year with. I have had to monkey around with dates this way before so it seemed quite familiar to me!
Post #1527252
Posted Sunday, January 5, 2014 10:40 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:57 PM
Points: 518, Visits: 646
Nice and Easy..!!

But Why This (B) option: "select bdateadd( ss, -1, datediff(yy, 0, @ThisDate) + 1 )" Is it a Typing Mistake, or what.?
Post #1527967
Posted Monday, January 6, 2014 3:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:57 AM
Points: 13,640, Visits: 11,511
Nice one, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1528015
Posted Tuesday, January 7, 2014 2:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 18, 2014 10:22 AM
Points: 1,830, Visits: 6,646
Revenant (12/31/2013)I thought it was understood that QotDs assume default SQL Server installation settings - if we veered off into region-specific settings, QotDs would have to have a dozen lines of code before you would get to the gist of the question.


My SQL Server instance was installed with default settings, and has British date format. Presumably the default settings vary according to region?

It was obvious that US format was assumed though, as there was no option for 'error' or 'none of the above'.
Post #1528392
Posted Wednesday, January 8, 2014 3:24 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 19, 2014 11:55 AM
Points: 1,848, Visits: 590
nice question..
Thanks Steve.
Post #1528821
Posted Friday, January 31, 2014 6:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 3:24 AM
Points: 1,144, Visits: 299
nice and easy
Post #1536757
Posted Sunday, February 9, 2014 12:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 7:02 PM
Points: 2,157, Visits: 879
I'm disappointed that the question used the "datetime" data type. This has clearly been replaced by Date, Time and Datetime2. Obviously some of the established forum members can't move on.

Regards
David
Post #1539552
Posted Monday, February 10, 2014 9:20 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 10:43 PM
Points: 49, Visits: 145
I agree about moving forward with the newer temporal data types, but the old datetime has some nice features, like zero as an int will implicitly cast to 1900-01-01 00:00:00. The new ones don't do that. It's also frustrating that you can't do things like @MyDatetime2 = @MyDate + @MyTime; a glaring oversight if you ask me.


Sincerely,
Daniel
Post #1540033
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse