Archives of the TeradataForum

Message Posted: Wed, 04 Apr 2012 @ 09:03:30 GMT


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

Subj:		Joining TIMESTAMP vs DATE

From:		sathesh.kumar

Hi,

I am joining a timestamp column with a date column in two env.( UAT & PROD) The issue is in UAT env the timestamp column is simplicitly converted to date and in PROD env the reverse is happening ie.. Date is implicitly getting converted to timestamp with 00:00:00 appended.

Because of this I am not getting the data in PROD the same as in UAT.

Kindly help

NOTE : AM using Teradata v13