Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Duncan Pryde » Dating for DBAs
Add to briefcase
37 posts, Page 2 of 4
««1234»»»

Dating for DBAs Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
BrainDonor
Posted Wednesday, April 06, 2011 1:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:57 AM
Points: 1,400, Visits: 6,891
Nice question - the links are particularly useful.

BrainDonor
Linkedin
Post #1089067
Chris Houghton
Posted Wednesday, April 06, 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: Thursday, May 16, 2013 9:12 AM
Points: 557, Visits: 1,356
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
cdiebolt
Posted Wednesday, April 06, 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: Wednesday, May 08, 2013 7:34 AM
Points: 886, Visits: 283
Add one more european developer!
I didn't know that the 2nd answer is dateformat dependent.


Post #1089086
cengland0
Posted Wednesday, April 06, 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
Hugo Kornelis
Posted Wednesday, April 06, 2011 2:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 5,235, Visits: 7,038
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
Richard Warr
Posted Wednesday, April 06, 2011 3:31 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 1,606, Visits: 1,089
Good question. Being in London (where we speak a 'foreign' version of English) helped to get it right.
Post #1089116
cdiebolt
Posted Wednesday, April 06, 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: Wednesday, May 08, 2013 7:34 AM
Points: 886, Visits: 283
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
sjimmo
Posted Wednesday, April 06, 2011 6:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 2,863, Visits: 2,466
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
Duncan Pryde
Posted Wednesday, April 06, 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: Today @ 6:35 AM
Points: 3,046, Visits: 1,303
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
Duncan Pryde
Posted Wednesday, April 06, 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: Today @ 6:35 AM
Points: 3,046, Visits: 1,303
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
37 posts, Page 2 of 4
««1234»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.