Subject Re: [firebird-support] Three integers to date
Author Nick Upson
update table1
set new_datecol = cast (cast(day as char) ||'.'||cast(month as
char)||'.'||cast(year as char) as date)


>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