 |
 |
Archives of the TeradataForum
Message Posted: Mon, 03 May 2004 @ 13:57:09 GMT
| Subj: | | Re: How do i extract time out of a datetime field |
| |
| From: | | Dieter Noeth |
Geoffrey Rommel wrote:
| | Two little comments on Jeff's paper. In the first example, the third '-' should be a blank. Also, the sentence "The timestamp data type
does not have a format command" may be confusing to some. I suggest: "Teradata requires the format 'yyyy-mm-dd hh:mm:ss' for timestamps; year,
month, and so on must be arranged in exactly that order." | |
And you can specify your own format for Time/Timestamp in V2R5...
Dieter
| |
