Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2003 @ 13:50:40 GMT


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

Subj:		Updating a timestamp

From:		Karen Gebhard

I am having trouble updating a timestamp column with a constant value. I've tried everything I can think of and get either a 5404 or a 5407. Here is the query in one of my attempts (the format on the table column is yyyy-mm-dd hh:mm:ss):

update prlurefresh.t_sran
set ts_recactdate = (cast ('1900-10-01 00:00:00' as timestamp)) (format 'yyyy-mm-dd hh:mm:ss')
, ts_recdeactdate = (cast ('4000-09-30 00:00:00' as timestamp)) (format 'yyyy-mm-dd hh:mm:ss')

Any ideas?

Karen Gebhard