Hi all,

I have character(16) column in the format : cyymmddhhmmssttt where:
– c = century (1 = 21st century)
– yymmdd = year, month, day
– hhmmssttt = hours, minutes, seconds, milliseconds

And i would like to write a trigger which will fill date and time columns with the appropriate values derived from the string.

Can someone help me how to build the trigger which will cut the input string and fill the data into the columns ???

Thank you in advance ...

Jan

you will have to work with substr
insert into ..... values (substr(oldcol,2,2)||'-'||substr(oldcol,4,2)||'-'.......