Home Page for the TeradataForum
 

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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016