Archives of the TeradataForum
Message Posted: Mon, 07 Jan 2002 @ 12:23:42 GMT
Subj: | | Re: Exporting time |
|
From: | | Stuart MacMillan |
Dave,
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 '.'
|