🚀 go-pugleaf

On Fri, 15 Jan 1999 23:37:09 +0100, tt <thomas@trautwein.com> wrote:

>steve,
>i did it with CAST:
>
>... CAST( OrderDate AS CHAR( 12 )) ) AS NewField...

Good.

>it works fine. although the documentation says that it only returns dates in
>us-format i get them in european-format the way i want. 1900 date values are
>returned as 2-digit-values ("31/12/98"), 2000 values come with 4 digits
>("31/12/2001").
>
>the only differencs to geman dates is, that we use dots instead of slashes. i
>could change this with a lot of code but i leave it as it is.

In local SQL, DATE and TIMESTAMP *literals* must be in the US format.
Column values are another matter. The format in which column values (or
other types of returned dates) will be in are predicated on other factors.
Primarily, this is the format selected at the Windows or application level
for displaying date values.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "I do most of my writing sitting down.
Technical Publications              That's where I shine."
INPRISE Corporation                         -- Robert Benchley (1889-1945)
http://www.inprise.com/delphi