| Subject | Re: [firebird-support] Extracting year, month, day, hour, etc... |
|---|---|
| Author | Jerome Bouvattier |
| Post date | 2004-02-29T23:36:04Z |
Hi heLen,
EXTRACT is what I was looking for.
Thanks !
Jerome
EXTRACT is what I was looking for.
Thanks !
> The EXTRACT() function works everywhere, if numbers are OK for you:--
> EXTRACT ( {SECONDS | MINUTES | HOUR | DAY | MONTH |YEAR} FROM
> <date-time-value> ) [[AS] <field-name>]
Jerome