Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2012 @ 20:20:12 GMT


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


Subj:   Re: How to Convert a VARCHAR date into TIMESTAMP(0) format
 
From:   Nimmala, Meher

Below might be simpler....

     SELECT CAST('12032012 02:23:45' AS TIMESTAMP(0) FORMAT 'MMDDYYYYbHH:MI:SS'); SELECT CAST
     ('2012-09-25 20:49:59' AS TIMESTAMP(0) FORMAT 'yyyy-mm-ddBhh:mi:ss'); SELECT CAST
     ('20090310181010' AS TIMESTAMP(0) FORMAT 'YYYYMMDDHHMISS');

Thanks

Meher



     
  <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: 28 Jun 2020