Post reply

Forum Date Format

  • March 17, 2007 at 12:24 pm

    #61885

    I noticed that the forum date format is DD/MM/YYYY (15/03/2007 05:26:00).

    Is this a recent change or maybe a mistake?

    If you want to go with an international date format, why not use the ISO format, YYYY-MM-DD HH:MM:SS?

     

     

  • March 17, 2007 at 6:11 pm

    #695584

    It used to be the other way, the way the US uses it. I wonder if the switch-over is due to moving servers from the US to UK?

     

    K. Brian Kelley
    @kbriankelley

  • March 17, 2007 at 6:50 pm

    #695594

    As a followup, looks like Steve and crew are aware of the issue:

     

    http://blogs.sqlservercentral.com/blogs/steve_jones/archive/2007/03/17/1474.aspx

     

    K. Brian Kelley
    @kbriankelley

  • March 17, 2007 at 7:50 pm

    #695596

    We're digging in. It has to be something with the forum software. All the other dates in ASP and on other sites are working in US format. Servers are set to US format, MST, but not working for some reason.

    We'll be on it first thing Mon am with the vendor.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • March 19, 2007 at 7:59 am

    #695703

    FWIW, those of us in the ROW (rest of the World) would like to see something other than the US format. For dates in the first twelve days of every month, we have to guess what date is meant. Only the International (yyyy-mm-dd) is self-describing and explicit. So it would be cool if you would use it. Even the ROW format dd-mm-yyyy leaves you guessing.

    The International format also sorts properly even when in character format!!

    (Canadian Lurker)

  • March 19, 2007 at 9:36 am

    #695750

    Interesting. I did no even notice the dates seeing as I am more intrested in the content.  Not being a web operson in any way shape or form ... is there not a way to have it displayed on the web pages based on the individual computer's defalt date settings ? I'm sure that this would satisfy everyone. After all behind the scenes in the database the storage is just plain ole 'datetime' ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • March 19, 2007 at 9:38 am

    #695751

    I admit to being confused for first 12 days of each month with the US and ROW formats, so make that 2 votes from Canada for the Internalional format (yyyy-mm-dd), eh!

    Besides: it's easiest to ramp up my memory with what changes least often, the year, and work up to those pesky days.

  • March 20, 2007 at 1:09 pm

    #696021

    This is a SQL Server site....so the DATE TIME format should be YYYYMMDD HH:SS:MM.

    At least that's my 2 cents.

    -SQLBill

  • March 20, 2007 at 1:56 pm

    #696035

    Stardate, anyone?

     

    K. Brian Kelley
    @kbriankelley

  • March 21, 2007 at 7:01 am

    #696130

    If you want to follow the ISO8601 standard, then it's:

    YYYY-MM-DD HH:MM:SS

    (Might want to flip your minutes and seconds around there, SQLBill )

  • March 21, 2007 at 2:50 pm

    #696259

    ARGH! I needed sleep that day - or maybe I WAS asleep.

    -SQLBill

  • March 21, 2007 at 2:53 pm

    #696262

    non ECC RAM ... hmmm ... parity hits ... hmmm ...

    penny-wise and pound foolish

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • March 22, 2007 at 7:12 am

    #696351

    Greetings to all you great members,

    Speaking about date format, I am in a little problem. I made a dataset and I want to use a query that gives this meaning:

    Select * from (TableName) where birthdate = Nothing

    I mean the Birthdate column is empty. Which expression replaces the word "Nothing" here.

    Thanks in advance.

  • March 22, 2007 at 9:13 am

    #696403

    SELECT * FROM (TableName) WHERE birthdate IS NULL

     

    K. Brian Kelley
    @kbriankelley

  • March 22, 2007 at 9:56 am

    #696422

    Before anything, I want to express my thanks for your quick answer.

    I appreciate your help it is of great value to me.

    Again thank you very much.

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

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