Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Cast date to timestamp
From:   Nathan_S_Smith


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.


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