Article View: borland.public.vdbase.data.sql
Article #831Re: datetime
From: Romain Strieff [TeamB]
Date: Fri, 24 Jul 1998 00:00
Date: Fri, 24 Jul 1998 00:00
22 lines
1079 bytes
1079 bytes
In article <35B82F26.51CA@medic.ukm.my>, zag@medic.ukm.my grudgingly admits... > how to handle informix datetime field in BDE > Handle? With SQL? SELECT EXTRACT(YEAR FROM HIRE_DATE) FROM EMPLOYEE From the Online help: Local SQL supports the EXTRACT() function for isolating a single numeric field from a date/time field on retrieval using the following syntax: EXTRACT (<extract field> FROM <field name>) where <extract_field> can be one of: YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND. In local SQL, EXTRACT() does not support the TIMEZONE_HOUR or TIMEZONE_MINUTE clauses. -- Romain Strieff [TeamB]
Technical Details
Message-ID:
<MPG.1022a53f15e0f7e698b00e@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35B82F26.51CA@medic.ukm.my>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e9971370cc8cf784 X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: datetime Date: 1998/07/24 Message-ID: <MPG.1022a53f15e0f7e698b00e@forums.borland.com> X-Deja-AN: 374510310 References: <35B82F26.51CA@medic.ukm.my> Organization: TeamB Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql