Archives of the TeradataForum

Message Posted: Mon, 28 Oct 2002 @ 20:31:00 GMT

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

I have an interval value that contains 3 20:16 which = 3 days, 20 hours and 16 minutes

I can pull out the hour and minutes and would like to pull the day, but when I try to extract the Day portion I receive an error.

5407 Invalid operation on an ANSI datetime or Interval value.

,extract(hour from diff_time) returns 20
,extract(minute from diff_time) return 16

Has anyone done this. In reading the documentation it seems I should be able to do this.

Thanks

Joan

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