Article View: borland.public.interbase.sql
Article #11177Re: IB SQL reference
From: justdoro
Date: Sat, 07 Dec 2002 22:33
Date: Sat, 07 Dec 2002 22:33
14 lines
1487 bytes
1487 bytes
Jerri Schrijver wrote:
> Where can i find the SQL reference book for IB that explains how to extract
> year and month from a date?
Extracting from a date example:
select extract(year from current_timestamp),
extract(month from current_timestamp)
from rdb$database;
IB 6 doc:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download#DOCS
Technical Details
Message-ID:
<3df27726@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3df23e40@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,a7a70252fc270045 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-07 14:39:43 PST Date: Sat, 07 Dec 2002 17:33:15 -0500 From: justdoro <justdoro@attbi.com> User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: IB SQL reference References: <3df23e40@newsgroups.borland.com> In-Reply-To: <3df23e40@newsgroups.borland.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 12.245.211.122 Message-ID: <3df27726@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039300390 12.245.211.122 (7 Dec 2002 14:33:10 -0800) Lines: 15 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail