Hi,

> 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.

Firebird doesn't "format" it's dates, it outputs binary date values that
are formatted by the client.

Several "external function libraries" include date-value formatting
functions, see:
http://ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_udf_libs


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com