Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 07 Sep 2011 @ 07:45:00 GMT

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

Subj:   Re: Hours Subtraction
From:   Badnikar, Amogh

This should solve your problem

     SELECT CAST(CAST(('2011-09-07' ||' '|| '10:57:31') AS VARCHAR(20) )
        AS TIMESTAMP(6)) - INTERVAL '06' HOUR 2011-09-07 04:57:31.000000


Amogh Badnikar

  <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: 15 Jun 2023