| Subject | Re: [firebird-support] Extracting year, month, day, hour, etc... |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-02-29T23:21:14Z |
At 11:49 PM 29/02/2004 +0100, you wrote:
EXTRACT ( {SECONDS | MINUTES | HOUR | DAY | MONTH |YEAR} FROM
<date-time-value> ) [[AS] <field-name>]
If you need strings for days and months (or if you are using IB 5) there
are various external function ("UDF") libraries to cater for your specific
need. FreeUDFLib has several to choose from.
/heLen
>Hello,The EXTRACT() function works everywhere, if numbers are OK for you:
>
>Is there a means, SPs, to extract the different parts from date, timestamp
>or time variables/fields ?
EXTRACT ( {SECONDS | MINUTES | HOUR | DAY | MONTH |YEAR} FROM
<date-time-value> ) [[AS] <field-name>]
If you need strings for days and months (or if you are using IB 5) there
are various external function ("UDF") libraries to cater for your specific
need. FreeUDFLib has several to choose from.
/heLen