 |
 |
Archives of the TeradataForum
Message Posted: Tue, 08 May 2007 @ 09:03:18 GMT
| Subj: | | Re: Format of timestamp in select |
| |
| From: | | Geoffrey Rommel |
| | I understand that I can break the field apart using SUBSTR, but I assumed it can be done with a simple format clause. | |
Unfortunately, it can't. The period has a reserved meaning for Teradata, so you can format the time portion as 'HH:MI:SS.S(6)' but not as
'HH.MI.SS.S(6)'. Bummer!
Maybe you could get the DB2/MVS guys to change their ZPARM so it's the same as Teradata's default format. :-)
Actually, I believe the DB2 unload utility allows you to change the format of exported timestamps, so maybe that would be the best option.
| |
