I have a timestamp DateTime value.
I must insert it in a table with 3 Integer columns

year: Integer, month: Integer, Day: Integer (3 colums)

Can I do

insert into MyTable (Year, Month, Day) values (exctract (year from :PDateTime), exctract
(month from :PDateTime)), exctract (day from :PDateTime))

Denis,

> Can I do
>

Apart from some typos, yes.
Here it is with the correct syntax:

insert into MyTable (Year, Month, Day)
values(
extract(year from :PDateTime),
extract(month from :PDateTime),
extract (day from :PDateTime)
)

I'm assuming you are using this statement in a TDBISAMQuery component,
PDateTime is an ftDateTime parameter and you want to insert one single
row each time you execute the query.

--
Fernando Dias
[Team Elevate]