Article View: borland.public.interbase.opensource
Article #194Re: How to get a substring from a cast SELECT?
From: Nando
Date: Tue, 15 Nov 2005 21:36
Date: Tue, 15 Nov 2005 21:36
30 lines
1720 bytes
1720 bytes
Thanks for your posting. "Dan Palley" <dan@trams.com> escribi๏ฟฝ en el mensaje news:437a505f@newsgroups.borland.com... > "Nando" <nando@nowhere.com> wrote in message > news:437a46cc$1@newsgroups.borland.com... >> Hi, >> >> I'm trying to get a substring from a date field using SELECT >> CAST(DateField AS CHAR(12)) but I can't find the way for doing so. >> > > Can you give us an example of what output you're trying to get? I assume What I'm trying to get are only the las two digits of the year from the DateField. > you're using IB 6 Open Edition. Yes, I'm using version 6.0.2.0 > > Have you looked at the EXTRACT function? > Not yet, but I'm going to do it right now. > Dan >
Technical Details
Message-ID:
<437a549a@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<437a46cc$1@newsgroups.borland.com> <437a505f@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,4bbeb00d679b3321 X-Google-Attributes: gid106772,public X-Google-Language: ENGLISH,ASCII Reply-To: "Nando" <nando@nowhere.com> From: "Nando" <nando@nowhere.com> Newsgroups: borland.public.interbase.opensource References: <437a46cc$1@newsgroups.borland.com> <437a505f@newsgroups.borland.com> Subject: Re: How to get a substring from a cast SELECT? Date: Tue, 15 Nov 2005 16:36:06 -0500 Lines: 32 Organization: Sistema MED X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 201.245.108.85 Message-ID: <437a549a@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1132090522 201.245.108.85 (15 Nov 2005 13:35:22 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail