 |
 |
Archives of the TeradataForum
Message Posted: Thu, 23 Feb 2006 @ 22:54:22 GMT
| Subj: | | Re: Odd error - Invalid operation on an ANSI Date/Time |
| |
| From: | | Joe Celko |
| | This seems a bit odd tough to have to cast to character, substring, and then cast back to time(0). Is there another way? | |
You are mopping the floor, instead of fixing the leak. Add a constrant that keeps your temporal data in a format that works for you instead of
letting it vary. Think DDL and DML. I would also use a BETWEEN predicate to make the code easier to maintain and read.
| |
