All Forums Database
TeraDBATMV 1 post Joined 05/08
20 Oct 2009
is it possible to add to the subseconds (precision seconds) in a timestamp

I have run this

select interval 000001 second + current_timestamp (6) , current_timestamp;
2009-10-20 13:32:54.110000+00:00 2009-10-20 13:32:53.110000+00:00


to add to the seconds, however I want to add to the precision seconds in a time stamp and have been unable to find a way.
Has anyone done this?

You must sign in to leave a comment.