Subject | Re: Date Extraction |
---|---|
Author | John Craig |
Post date | 2006-05-09T02:54:57Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
Also, is there a slick way to get a textual version of the month or
weekday? January rather than 1, and so on?
John
> >So, are goodies like this documented in your The Firebird Book?
> > > EXTRACT (MONTH FROM mydate)
> > > or DAY, YEAR..
> >
> IB 6.0. So Firebird has always had it. The parts you can extract are
> YEAR | YEARDAY| MONTH | DAY | WEEKDAY (from a DATE type)
> and HOUR | MINUTE | SECOND (from a TIME type). You can extract any
> of them from a TIMESTAMP type.
>
Also, is there a slick way to get a textual version of the month or
weekday? January rather than 1, and so on?
John