Archives of the TeradataForum

Message Posted: Mon, 14 Jan 2008 @ 13:55:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>