Archives of the TeradataForum

Message Posted: Wed, 11 Jan 2006 @ 22:24:53 GMT

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

Apply ANSI INTERVAL offsets, then make the result a date:

     e.g. CAST((MyTimestamp - INTERVAL '2' DAY) AS DATE) for two days prior
     or CAST((MyTimestamp - INTERVAL '20' HOUR) AS DATE) for 20 hours prior

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