update table1
set new_datecol = cast (cast(day as char) ||'.'||cast(month as
char)||'.'||cast(year as char) as date)

(untested)

>From: Martin <moirae@...>

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

_________________________________________________________________
Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile