Thread View: borland.public.interbase.sql
8 messages
8 total messages
Started by Jerri Schrijver
Sat, 07 Dec 2002 18:30
IB SQL reference
Author: Jerri Schrijver
Date: Sat, 07 Dec 2002 18:30
Date: Sat, 07 Dec 2002 18:30
6 lines
1040 bytes
1040 bytes
Where can i find the SQL reference book for IB that explains how to extract year and month from a date? TIA, Jerri
Re: IB SQL reference
Author: 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
Re: IB SQL reference
Author: Bill Todd
Date: Sun, 08 Dec 2002 00:18
Date: Sun, 08 Dec 2002 00:18
18 lines
1346 bytes
1346 bytes
It is in the Language Reference for 6.5 and 7 and the final docs for 6. On Sat, 7 Dec 2002 19:30:53 +0100, "Jerri Schrijver" <j.schrijver@nisba.com> wrote: >Where can i find the SQL reference book for IB that explains how to extract >year and month from a date? > >TIA, > >Jerri > -- Bill (TeamB) (TeamB cannot respond to questions received via email)
Re: IB SQL reference
Author: Craig Stuntz TeamB
Date: Mon, 09 Dec 2002 18:18
Date: Mon, 09 Dec 2002 18:18
18 lines
1620 bytes
1620 bytes
In article <3df27726@newsgroups.borland.com>, justdoro@attbi.com says... > IB 6 doc: > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download#DOCS > FWIW: This is just a pointer to the beta documentation for IB 6 on the Borland site, which doesn't include EXTRACT. If you need up-to-date IB docs, you need to buy the IB Media Kit (around $50 from http://shop.borland.com). -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Re: IB SQL reference
Author: justdoro
Date: Tue, 10 Dec 2002 03:08
Date: Tue, 10 Dec 2002 03:08
12 lines
1635 bytes
1635 bytes
Craig Stuntz [TeamB] wrote: > This is just a pointer to the beta documentation for IB 6 on the > Borland site, which doesn't include EXTRACT. If you need up-to-date IB > docs, you need to buy the IB Media Kit (around $50 from > http://shop.borland.com). Thanks. Borland doesn't have a download for this? Bummer. Is it available within the IB 6.5 trial download? (Guess there's one way to find out....)
Re: IB SQL reference
Author: Ivan Prenosil
Date: Tue, 10 Dec 2002 14:48
Date: Tue, 10 Dec 2002 14:48
9 lines
1335 bytes
1335 bytes
> Where can i find the SQL reference book for IB that explains how to extract > year and month from a date? If you do not want to buy IB Media Kit, then you can find explanation of EXTRACT function in IB6 Migration Guide (can be downloaded from Borland site). -- Ivan http://www.volny.cz/iprenosil/interbase
Re: IB SQL reference
Author: Craig Stuntz TeamB
Date: Tue, 10 Dec 2002 15:30
Date: Tue, 10 Dec 2002 15:30
12 lines
1465 bytes
1465 bytes
In article <3df55ab1@newsgroups.borland.com>, justdoro@attbi.com says... > Is it available within the IB 6.5 trial download? > No. -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Re: IB SQL reference
Author: Craig Stuntz TeamB
Date: Tue, 10 Dec 2002 18:25
Date: Tue, 10 Dec 2002 18:25
13 lines
1550 bytes
1550 bytes
In article <3df61e2f@newsgroups.borland.com>, prenosil@ms.anet.cz says... > If you do not want to buy IB Media Kit, then you can find explanation of EXTRACT > function in IB6 Migration Guide (can be downloaded from Borland site). > Also, EXTRACT is standard SQL and is mentioned in many texts. -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads