DATETIME 1

  • Comments posted to this topic are about the item DATETIME 1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • great question (if you didnt run the t-sql)....certainly whipped by butt today 🙂

    lesson learned.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • bitbucket, you are thereby appointed an SQLServerCentral sneak in residence. 🙂

    Thanks for an interesting QotD!

  • Revenant (12/6/2011)


    bitbucket, you are thereby appointed an SQLServerCentral sneak in residence. 🙂

    Thanks for an interesting QotD!

    Why thank you for the compliment. And when you try my next QOD scheduled for publication 14 Dec 2011 - why you might even want to repeat that appointment or give me another one such as

    "Chief SQLServerCentral sneak in residence."

    Oh a question for you ... should I add that title to my signature block?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Great question, but the answer is language dependant since outside the us at first glance '01-08-2011' reads 1st of August 😉

  • Good question. At first glance I had a hunch there was something sneaky about it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thank you for the question

    Iulian

  • ma-516002 (12/7/2011)


    Great question, but the answer is language dependant since outside the us at first glance '01-08-2011' reads 1st of August 😉

    Fully agree--thus I'd always be in favor of ISO 8601 notation of YYYY-MM-DD (2010-01-08, aka international date) when writing dates without the month's name in it.

    Thanks for a good and easy question :-).

  • First I got 53,30,1,32 - but soon realised you're using an ambiguous date format.

    Thanks for the question:

    Week 53 is quite a common occurrance where I work, so it came as no surprise that SQL Server has started implementing it. I may simplify some of our procedures that calculate week 53 if this iso_week function fits our requirements.

  • Nice question, learned about iso_week.

    It would have been better if the dates were in ISO format, but that's just a detail.

    You could derive the answer immediately if you just found the week for the 1st of January of 2010, so it isn't even necessary to look at the rest of the question 🙂

    edit: and there were certainly no problems with the font size of the question 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • <sigh>

    When will people finally learn that the US date format is NOT universal??

    For a large majority of the world, the correct answer is 53, 31, 1, 32.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Hugo Kornelis (12/7/2011)


    <sigh>

    When will people finally learn that the US date format is NOT universal??

    For a large majority of the world, the correct answer is 53, 31, 1, 32.

    And there are many of us in the US that wish we used the same system as most others - just makes more sense. Now, about the metric system .....

    Also, BitBucket, thanks for the question. I was weak on iso_week, but no longer thanks to you!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Learned something new today. Thanks for the great question.

    http://brittcluff.blogspot.com/

  • nice question!!!

    thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • ma-516002 (12/7/2011)


    Great question, but the answer is language dependant since outside the us at first glance '01-08-2011' reads 1st of August 😉

    Yes, this is a lesson we learn quite quickly (the hard way) if ever we have to port our application from one language or country to another.

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply