--- In firebird-support@yahoogroups.com, "kokok_kokok" <kokok_kokok@...> wrote:

>
> Using Firebird 2.0, how can I format a date to yyyymmdd?
>
> For example Jan 15 2009 -> 20090115
>
> My first approach has been using EXTRACT(YEAR FROM BirthDate) || EXTRACT(MONTH FROM BirthDate) || EXTRACT(DAY FROM BirthDate)
> but it does not work for me because I need to lead zeros and I cannot find how do it. Maybe there is a direct function.
>
> Thanks
>

select
extract(year from cast('today' as date))
|| substring(cast(cast((100 + extract(month from cast('today' as date))) as integer) as varchar(100)) from 2 for 2)
|| substring(cast(cast((100 + extract(day from cast('today' as date))) as integer) as varchar(100)) from 2 for 2)

from rdb$database