Archives of the TeradataForum
Message Posted: Sun, 16 Mar 2003 @ 20:35:13 GMT
Sorry to beat this to death but...
I have '0001-01-01' dates on the database which is causing an overflow on the interval. I am trying to use case logic to no avail:
select date '2003-01-31' as month_end, orgnl_srv_dt,
Any ideas why case logic won't work on an interval the way it is coded above? Any suggestions on how to fix the case?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|