【笔记】Teradata 时间类型转换

case when
            substr(
             CAST((timestamp_col
               (FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)'))
              AS VARCHAR(26))
             ,18,2) > 59
       then substr(
             CAST((timestamp_col
               (FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)'))
              AS VARCHAR(26))
             ,1,17)
            || '59'
            || substr(
              CAST((timestamp_col
                (FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)'))
               AS VARCHAR(26))
             ,20)
       else
            CAST((timestamp_col
               (FORMAT 'YYYY-MM-

DDBHH:MI:SS.S(6)'))
              AS VARCHAR(26))
   end

sel

(

cast ( trns_strt_ts as date ) -1 )

||

' ' || substr ( CAST (( trns_strt_ts ( format 'YYYY-MM-DDBHH:MI:SS.S(6)' )) AS VARCHAR ( 26 )) , 12 , 8 ) AS trns_strt_ts

from r_actl_trns where fr_loc_id = 'S21'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23155850/viewspace-662670/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23155850/viewspace-662670/