Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Apr 2004 @ 17:10:21 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Converting time in miliseconds to TIEMSTAMP in teradata
From:   Victor Sokovin


  I referred to the thread:  


  in this forum. I want the same thing as asked by Dheeraj and I followed the same approach suggested by Victor in this thread. With this I could achieve the date part using SYS_CALENDAR.CALENDAR view, but still not able to get the time part. Can anyone help??  

I thought that the date part was the most difficult in such calculations! To get the time part is relatively easy because the remainder left after the division is within the INTERVAL data type. It means you can CAST it to timestamp using the built-in conversion mechanisms in Teradata and don't need any special formulae.

As I am away from TD until Monday I would not want to produce the exact example without being able to check the syntax but I would like to redirect you to a few examples suggested by Dieter in

www.teradataforum.com/teradata/20030729_092004.htm .

They show how to convert INTERVAL to TIMESTAMP in the context very similar to yours. As Dieter noted, please be aware that the exact syntax might slightly vary for your release.

There is also an excellent overview of dates and times by Geoffrey Rommel:


Hope this will help you finish the conversion.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023