[thelist] Date and Time issue Worldwide

[Rob Smith]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

I hate to bring this back up, but here's a new twist to the scheme. I've
tried most data formats you've suggested. I agree, even though I'm American,
with the DD/MM/YYYY format, Just makes sense. However, I'm using SQL Server
7 w/Enterprise Manager as my interface with them (if you're familiar).

I entered the date:

4/15/02 --> 4/15/2002
5/8/02 --> 5/8/2002
15/4/02 --> 4/15/2002  hmmm...
13/8/02 --> 8/13/2002

It appears as we all don't have a choice in the matter. UNLESS there is a
way to configure the date/time settings format there. I've looked for a good
15 minutes on Microsoft, Google (Elmer fudd :-p), codeanimal and still
haven't found the answer. Does the following snippet seem familiar:
<snip>SET DATE FORMAT TO "dd/mm/yyyy" </snip>. I haven't seen the
documentation in the manuals about this.

Merci,

Rob


Howdy,

>> ... as this format is the least misunderstood

> oh?
>
> i suppose the 23th follows the 22st?

(groan)  I'm tired, leave me alone  :P

>>If I have to shorten it, then I use  23-Jan-02
>
>
> quick, is 30-Feb-28 valid?
>
> don't shorten it

Very true.  30-Feb-28 is the 28th of Feb, 2030 when looked at it with
Japanese standards.
^M^