Archives of the TeradataForum
Message Posted: Mon, 07 Jan 2002 @ 12:23:42 GMT
thanks for the quick reply but it's not quite what I want. I need the '.' in the export data, not ':' .
The background is I'm trying to create part of a DB2 time stamp value prior to loading to lovely DB2.
DB2, unlike Teradata, needs a time stamp as 'CCYY-MM-DD-hh.mm.ss.ssssss'
Think I'll just substring the result of the formatted char(15) time value and put it back together with '.'
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|