Archives of the TeradataForum

Message Posted: Wed, 28 Jan 2004 @ 13:18:34 GMT

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

Hi,

I am trying to update following but I am getting error 'invalid operation on an Ansi Datetime

my column is timestamp(6)

Update cdd.cddextractcontrol
   Set CDDdatastartfromdatetime = '28-01-2004 06:25:29.540000'
   Where cddextractname = '9W'

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