Archives of the TeradataForum
Message Posted: Mon, 14 Jan 2008 @ 13:55:44 GMT
<-- Anonymously Posted: Mon, 14 Jan 2008 07:44 -->
The FORMAT 'HH:MI:SSBT' should be correct. Are you certain the field is of type TIME? (Do SHOW TABLE to be certain.) What DBMS release?
Note also that VARCHAR(10) only allows enough space for the single letter A or P, not AM or PM.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|