Hi Martin,

> Hi. Could anyone help me please. I've got date stored as three
> integers - day, month and year. Now I've added new date column and I
> am looking for any function (using FireBird, dialect 3) which can
> convert theese integers into date type.
> Thanks.

How about this (as an example):

select cast('01/' || '02' || '/2003' as date)
from rdb$database

So this should work as well:

select cast(1 || '/' || 2 || '/' || 2003 as date)
from rdb$database

I guess you get the idea.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com