Hi,
I am trying to insert a timestamp into a datetime field on SQL Server using a stored procedure in DataMigrator. Does anybody have an example of how you format a datetime value to pass through? I have attempted this by trying to concatenate &DATE and &TOD, but I keep getting an error saying that this is in the incorrect format.

Thanks!

This works for me in Oracle:

-SET &TOD_H = EDIT(&TOD,'99');
-SET &TOD_M = EDIT(&TOD,'$$$99');
-SET &TOD_S = EDIT(&TOD,'$$$$$$99');
-SET &TOD_HMS = &TOD_H | &TOD_M | &TOD_S;
-SET &TS = &YYMD | &TOD_HMS;
-TYPE TS: &TS

SQL SQLORA
INSERT INTO OWNER.TABLENAME
(DATE_FIELD)
VALUES (TO_TIMESTAMP('&TS.EVAL','YYYYMMDDHH24MISS'))
;
END
-RUN

Ah - didn't think about splitting it up into individual elements - but good idea
I'll let you know if I find a one-liner to do this too.

Thanks!

Darren

I was reading this "old" issue and I wondered if this works already, otherwise you might be able to let this done by the SQL proces itself.
I think you can define a default value on the database that automatically insert the datetime to the actual value unless you enter an other value.

good luck

If anybody needs this - I've managed to figure it out.
Darren 1 : iWay 0


-*Create the timestamp variable in the correct format for SQL Server to use
-SET &TIME = EDIT(&TOD,'99:$99:$99')||'.000';
-TYPE &TIME

-SET &DAY = EDIT(&YYMD,'9999-99-999');
-SET &TS = &DAY||&TIME;

Darren 1: 0 iWay


-*Create the timestamp variable in the correct format for
-*SQL Server to use
-SET &TIME = EDIT(&TOD,'99:$99:$99')||'.000';
-TYPE &TIME

-SET &DAY = EDIT(&YYMD,'9999-99-999');
-SET &TS = &DAY||&TIME;