Article View: borland.public.interbase.opensource
Article #193Re: How to get a substring from a cast SELECT?
From: Dan Palley
Date: Tue, 15 Nov 2005 21:15
Date: Tue, 15 Nov 2005 21:15
14 lines
1393 bytes
1393 bytes
"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 you're using IB 6 Open Edition. Have you looked at the EXTRACT function? Dan
Technical Details
Message-ID:
<437a505f@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<437a46cc$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> Subject: Re: How to get a substring from a cast SELECT? Date: Tue, 15 Nov 2005 13:15:39 -0800 Lines: 16 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: <437a505f@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1132089439 66.102.131.249 (15 Nov 2005 13:17:19 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail