Post reply

QOD 12/18/2003...

  • December 18, 2003 at 6:03 am

    #358779

    Seems like there is something missing from the question as the answers refer to do the above 1,2,3 and 4 then else. Is there something missing from the question?

  • December 18, 2003 at 9:06 am

    #486974

    I got it right! woohooo! I guessed, but I got it right!


    -Ken

  • December 19, 2003 at 12:08 am

    #487146

    Does this solution(set language) not pose problems for inserts for the inserting dates in US format? I would think a trigger to convert the dateformat as applicable would be better.

    Hans Brouwer

    Kind regards,

    Hans Brouwer

    Greetz,
    Hans Brouwer

  • December 19, 2003 at 2:32 am

    #487161

    Hmmm. The working solution is not suggested as an option. IMO, the best solution would be to make sure the date is formatted according to ISO format (yyyymmdd).

    This format is from Microsoft documented to be recognized by SQL Server regardles of any locale settings.

    Best regards,

    Benny Tordrup

  • December 19, 2003 at 4:34 am

    #487175

    Using ISO dates is indeed the best solution, but for some reason I have never met such a standardization in real-life situations.

    The SET LANGUAGE option is superb because many exports are done by persons who export the SQL server ISO dates with their Query Analyzer using the regionale settings of their desktop.

  • December 19, 2003 at 4:35 am

    #487176

    Or Excel dumps

  • December 19, 2003 at 4:37 am

    #487178

    Could it be you guys posting this in yesterday's QOD thread?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 19, 2003 at 4:52 am

    #487179

    Yes they are, and the reason most folks use the language setting as opposed to ISO format with regards to 12/19 QOD is that applications aren't always designed that way. Many companies use DATE() in VB to get the date which is based on the computers regional settings. Since many times there is no user interaction on the date the format is the default. Also, many folks do not understand the ISO format use and when they see displayed they want in their normal format so many times entry just needs to be handle with the format option when delivered but many programmers don't bother.

  • December 22, 2003 at 7:57 am

    #487415

    quote:

    Seems like there is something missing from the question as the answers refer to do the above 1,2,3 and 4 then else. Is there something missing from the question?

    I think when I was writing it I was thinking of the earliest step at which you could finish, so the answers would go (step 1), (steps 1&2), (steps 1,2&3) etc. This might have been too fuzzy, the question was already quite complex.

    I'll be more concise in the next one.

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

Viewing 9 posts - 1 through 8 (of 8 total)

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