Re: Select Character + Numeric

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

Article #715

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

#715

From: Romain Strieff [TeamB]
Date: Wed, 19 Aug 1998 00:00

15 lines
1124 bytes

In article <35d52c67.8565065@forums.inprise.com>, 
koterski@NOSPAMborland.com grudgingly admits...
> 
> The CAST function takes two parameters: the value to be converted (column,
> literal, or calculated value) and the data type to which the value is to be
> converted. In the case of the CHAR data type, you *must* supply a length
> specification. For example:
> 
>   SELECT Name || CAST(NumberField AS CHAR(10))
>   FROM YourTable
> 
Does that also work for extracting the date-portion alone of a datetime 
field?
-- 
Romain Strieff [TeamB]

Technical Details

Message-ID: <MPG.104494b1d02e6edb98b06f@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>

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/19
Message-ID: <MPG.104494b1d02e6edb98b06f@forums.borland.com>
X-Deja-AN: 382605581
References: <6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net> <6qkgsd$ofg7@forums.borland.com> <35d52c67.8565065@forums.inprise.com>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message