Article View: borland.public.interbase.opensource
Article #196Re: How to get a substring from a cast SELECT?
From: Dan Palley
Date: Tue, 15 Nov 2005 23:28
Date: Tue, 15 Nov 2005 23:28
12 lines
1322 bytes
1322 bytes
"Nando" <nando@nowhere.com> wrote in message
news:437a55bc$1@newsgroups.borland.com...
>> Have you looked at the EXTRACT function?
>
>
> By the way,
>
> I'cant find the EXTRACT function. Where is it? How to use it?
select extract(year from issuedate) from invoice
Dan
Technical Details
Message-ID:
<437a6f7b$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!meganewsservers.com!feeder2.on.meganewsservers.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<437a46cc$1@newsgroups.borland.com> <437a505f@newsgroups.borland.com> <437a55bc$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,4bbeb00d679b3321 X-Google-Attributes: gid106772,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Dan Palley" <dan@trams.com> Newsgroups: borland.public.interbase.opensource References: <437a46cc$1@newsgroups.borland.com> <437a505f@newsgroups.borland.com> <437a55bc$1@newsgroups.borland.com> Subject: Re: How to get a substring from a cast SELECT? Date: Tue, 15 Nov 2005 15:28:24 -0800 Lines: 14 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 66.102.131.249 Message-ID: <437a6f7b$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1132097403 66.102.131.249 (15 Nov 2005 15:30:03 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!meganewsservers.com!feeder2.on.meganewsservers.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail