is it possible to add to the subseconds (precision seconds) in a timestamp
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Teradata Database » is it possible to add to the subseconds...
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


is it possible to add to the subseconds... Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
TeraDBATMV
Posted 10/20/2009 3:27:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/20/2009 5:14:55 PM
Posts: 1, Visits: 7
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?
Post #17115
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 5:50pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.063. 6 queries. Compression Disabled.