Archives of the TeradataForum
Message Posted: Thu, 10 Jan 2008 @ 11:06:28 GMT
Once you've got the glitches figured out, they can be interesting. I agree with you on the first example, but not on the second one.
Direct casting of a timestamp 6 to a zero would implicitly remove precision. I'm glad the system requires you to do so explicitly. But it's not consistent within Tera as the db does implicitly trims leading and trailing spaces. (Not funny with data coming in from Oracle)
But if you're interested: try to get LENGTH (that works fine in queryman) to work in a FastExport script. You would assume all tools of the same vendor would support the same commands, right? Or discover that casting of a date to a certain format only works when you put TRIM around the statement... (my favourite ;-))
Menno van Tienhoven
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|