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

Rishi,

I referred to the thread:

www.teradataforum.com/teradata/20040213_152551.htm

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:

www.teradataforum.com/l030515a.htm

Hope this will help you finish the conversion.

Regards,

Victor


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

Attachments

Library

Quick Reference