Hi,
is it possible to convert a date field into a datetime field. I've got this error :

-1262 Non-numeric character in datetime or interval.

on

create procedure "informix".ins_notimportant(
p_date VARCHAR(50)) -- date parameter
DEFINE l_datetime like tablename.datetimefield;

LET l_datetime = p_date;
...

In this procedure, I have to insert a date field into a datetime field. I tried extend() but it don't seems to work... can somebody help ?

thanks

Hi,

Please check you program or SPL.

This conversion is posible.
Consider following example:

create raw table notimportant
( colchar varchar(50)
)
insert into notimportant
select columnvarchar from anytable

This run fine.

Gustavo

I've got error -1262 when i try to put a date in a datetime variable.

when i try

Let l_datetime = l_date;
(datetime year to day) (date)

this line generates the error -1262... I can try :

SELECT extend(p_date, year to day)
INTO l_datetime
FROM dual;

Where dual have only 1 row and It gives me the same error!

Hi,

Ok, please test with:
SELECT MDY(p_date)
INTO l_datetime
FROM dual

Gustavo.

Thanks a lot, MDY() works...

LET l_datetime = current;

--return OS time

--format "2004-05-18 14:58:58"