Re: converting dates to string

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

Article #118

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

#118

From: ccc34145
Date: Tue, 19 Jan 1999 00:00

19 lines
1160 bytes

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...
>
>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").
>

Thomas, 

Did you try using commands like Set Date German Or Set Mark To "."
before the sql statement to avoid the slashes?

Ivar B. Jessen

Technical Details

Message-ID: <36a495e3.1916152@forums.inprise.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> <369FC314.ABA351AD@trautwein.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: ccc34145@vip.cybercity.dk
Subject: Re: converting dates to string
Date: 1999/01/19
Message-ID: <36a495e3.1916152@forums.inprise.com>
X-Deja-AN: 434417463
References: <3699120D.76142F68@trautwein.com> <36995690.7C61@sierratel.com> <369A4B85.6D70E039@trautwein.com> <369a533b.11488027@forums.inprise.com> <369FC314.ABA351AD@trautwein.com>
Organization: Another Netscape Collabra Server User
Reply-To: bergishagen@it.dk
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message