Re: Select Character + Numeric

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

Article #722

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

#722

From: Romain Strieff [TeamB]
Date: Thu, 20 Aug 1998 00:00

14 lines
1235 bytes

In article <35e002ea.5594602@forums.inprise.com>, 
skoterski@NOSPAMinprise.com grudgingly admits...
> >Does that also work for extracting the date-portion alone of a datetime 
> >field?
> 
> Kinda. It does not extract so much as truncate. A DATE or TIMESTAMP type
> column can be converted to DATE. The time portion of the TIMESTAMP column
> is simply lopped off. Conversely, a DATE column converted to TIMESTAMP
> acquires a default time (12:00:00 AM). In the example below, DT is a
> TIMESTAMP column and D a DATE type column.
----
Thanks.
-- 
Romain Strieff [TeamB]

Technical Details

Message-ID: <MPG.10463816675a7e6c98b08b@forums.borland.com>

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

References:

<6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net> <6qkgsd$ofg7@forums.borland.com> <35d52c67.8565065@forums.inprise.com> <MPG.104494b1d02e6edb98b06f@forums.borland.com> <35e002ea.5594602@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e0ca2689a5358a7a
X-Google-Attributes: gidff5a1,public
From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB])
Subject: Re: Select Character + Numeric
Date: 1998/08/20
Message-ID: <MPG.10463816675a7e6c98b08b@forums.borland.com>
X-Deja-AN: 382988605
References: <6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net> <6qkgsd$ofg7@forums.borland.com> <35d52c67.8565065@forums.inprise.com> <MPG.104494b1d02e6edb98b06f@forums.borland.com> <35e002ea.5594602@forums.inprise.com>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message