Archives of the TeradataForum

Message Posted: Mon, 11 Jul 2011 @ 14:52:30 GMT

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

Hi,

It is not necessary to cast a DATE column to a TIMESTAMP data type to select the DATE value column and insert into a TIMESTAMP column. Teradata will automatically convert the date.

Since the DATE column has no timestamp value, the time part of the column will default to 12 am.

I believe the problem with your original query is the use of the literal rather than an actual date column. If you cast an actual DATE column to TIMESTAMP, the insert works as well.

Nathan

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