Re: converting dates to string

Article View: borland.public.vdbase.data.sql

Article #106

Back to borland.public.vdbase.data.sql Previous Next

#106

From: tt
Date: Fri, 15 Jan 1999 00:00

15 lines
1136 bytes

steve,
i did it with CAST:

... CAST( OrderDate AS CHAR( 12 )) ) AS NewField...

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.

thanks again.
thomas trautwein

Technical Details

Message-ID: <369FC314.ABA351AD@trautwein.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<3699120D.76142F68@trautwein.com> <36995690.7C61@sierratel.com> <369A4B85.6D70E039@trautwein.com> <369a533b.11488027@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,374a1c05f0f1b280
X-Google-Attributes: gidff5a1,public
From: tt <thomas@trautwein.com>
Subject: Re: converting dates to string
Date: 1999/01/15
Message-ID: <369FC314.ABA351AD@trautwein.com>
X-Deja-AN: 433127102
Content-Transfer-Encoding: 7bit
References: <3699120D.76142F68@trautwein.com> <36995690.7C61@sierratel.com> <369A4B85.6D70E039@trautwein.com> <369a533b.11488027@forums.inprise.com>
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message