Archives of the TeradataForum

Message Posted: Sat, 10 Jan 2009 @ 08:46:44 GMT


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

Subj:		Re: More precision needed for interval day

From:		Joseph D silva

The data type "interval day to second" has a max limit of day(4).

What are my options if I need to store a bigger number of days? I am calculating the interval as a difference between 2 timestamps.

How about joining the date portion of the time stamp to the calendar table and subtracting the day_of_calendar ?


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

Archives

2009 Indexes

Last Modified: 15 Jun 2023