Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 24 Aug 2001 @ 12:05:49 GMT

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

Subj:   Re: Using Time(0)
From:   Ulrich Arndt

Hi Michael,

The following should work:

create volatile table a
 date_value date format 'YYYYMMDD',
 time_value time(0)
on commit preserve rows;

insert into a values

select time_value, date_value,
cast (date_value as timestamp(0))
        + extract(hour from time_value) * Interval '1' hour
        + extract(minute from time_value) * Interval '1' minute
        + extract(second from time_value)* Interval '1' second
from a

Using the table above,

select max(cast(time_value as char(14)) !! cast(date_value as char(14)))
from a

also works. What is the exact definition of the date and time fields in the DDL?

Hope that helps


  <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