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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 1,539, Visits: 8,136
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: Today @ 4:32 AM
Points: 558, Visits: 1,460
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: Yesterday @ 5:40 PM
Points: 5,930, Visits: 8,180
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: Yesterday @ 9:54 AM
Points: 2,092, Visits: 1,695
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: Monday, July 14, 2014 9:47 AM
Points: 2,919, Visits: 2,525
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: Thursday, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
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: Thursday, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
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