Archives of the TeradataForum
Message Posted: Mon, 28 Oct 2002 @ 20:31:00 GMT
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
Has anyone done this. In reading the documentation it seems I should be able to do this.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|