add microsecond field to timestamp field

General

add microsecond field to timestamp field

i have a table that has two columns

start_time (time stamp) and duration_microseconds (decimal)

i want to end_time column which has like 

start_time+duration_microseconds

please help me out

Regards,

Srini

2 REPLIES
Senior Apprentice

Re: add microsecond field to timestamp field

Hi Srini,

try

start_time + duration_microseconds * interval '0000 00:00:00.000001' day to second

Re: add microsecond field to timestamp field

Thanks Dieter