Re: converting dates to string

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

Article #122

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

#122

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

26 lines
1381 bytes

no. i'll try.

thank you,
thomas trautwein

ccc34145@vip.cybercity.dk schrieb:

> 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: <36A50075.7EFE4501@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> <369FC314.ABA351AD@trautwein.com> <36a495e3.1916152@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/19
Message-ID: <36A50075.7EFE4501@trautwein.com>
X-Deja-AN: 434564532
Content-Transfer-Encoding: 7bit
References: <3699120D.76142F68@trautwein.com> <36995690.7C61@sierratel.com> <369A4B85.6D70E039@trautwein.com> <369a533b.11488027@forums.inprise.com> <369FC314.ABA351AD@trautwein.com> <36a495e3.1916152@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