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 ««1234»»»

Dating for DBAs Expand / Collapse
Author
Message
Posted Wednesday, April 6, 2011 1:47 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 1,482, Visits: 8,483
Nice question - the links are particularly useful.

BrainDonor
Linkedin
Blog Site
Post #1089067
Posted Wednesday, April 6, 2011 2:17 AM
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: Wednesday, November 12, 2014 2:23 AM
Points: 558, Visits: 1,491
paul.knibbs (4/6/2011)
Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong?


At least one
Post #1089080
Posted Wednesday, April 6, 2011 2:24 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 25, 2013 7:20 AM
Points: 886, Visits: 285
Add one more european developer!
I didn't know that the 2nd answer is dateformat dependent.



Post #1089086
Posted Wednesday, April 6, 2011 2:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Good question, I lost 2 points but learned something.
Post #1089089
Posted Wednesday, April 6, 2011 2:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 6,098, Visits: 8,367
Nice question! And I just love the punny title.


UMG Developer (4/5/2011)
Nice question, thanks!

How many people actually use the ODBC date literals?

Few, I would hope
Luckily I have seen them before, and I knew which two answers are not correct, so from that I deduced that ODBC dates using yyyy-mm-dd must be language independent.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1089095
Posted Wednesday, April 6, 2011 3:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 2,208, Visits: 1,766
Good question. Being in London (where we speak a 'foreign' version of English) helped to get it right.
Post #1089116
Posted Wednesday, April 6, 2011 3:32 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 25, 2013 7:20 AM
Points: 886, Visits: 285
Hugo Kornelis (4/6/2011)

Few, I would hope

Actually, the ODBC format can be quite useful when you are developing a system fetching data in may different data sources, as you can unify the way you write you dates in your queries. But beside that type of usage, I agree it's probably best to use another syntax.



Post #1089117
Posted Wednesday, April 6, 2011 6:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, November 20, 2014 8:13 AM
Points: 2,917, Visits: 2,536
Excellent question. Got it wrong - but learned a lot.

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #1089203
Posted Wednesday, April 6, 2011 6:39 AM
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: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
I'm glad people are liking the question - thanks for the positive comments everyone.

I was motivated to come up with the question after following a discussion relating to a QotD from a few weeks ago. There was some (at times quite heated!) debate around language-independent date formats, so I thought it would be good material for a question, and hopefully some more discussion.

Incidentally, there's a "second date" scheduled to be published next week, so anything you read in those links could be handy...
Post #1089223
Posted Wednesday, April 6, 2011 7:08 AM
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: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
paul.knibbs (4/6/2011)
Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong?


I'll admit that I deliberately chose '04-28-2011' as a potential answer rather than '28-04-2011', but this was more because I reckoned there might be more people using the first format in their daily lives, rather than being a deliberate attempt to target our friends across the pond. Honest.
Post #1089246
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse