All Forums General
cnukokerla 2 posts Joined 06/15
05 Jun 2015
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

dnoeth 4628 posts Joined 11/04
05 Jun 2015

Hi Srini,
try
start_time + duration_microseconds * interval '0000 00:00:00.000001' day to second

Dieter

cnukokerla 2 posts Joined 06/15
06 Jun 2015

Thanks Dieter
 
 

You must sign in to leave a comment.