Archives of the TeradataForum

Message Posted: Fri, 24 Dec 2004 @ 11:26:15 GMT

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

I am facing a problem with the following given query.

     SELECT
           atrr.audit_date,
           atra.audit_date,
            (cast(cast(ATRR.audit_date as FORMAT 'yyyy-mm-dd hh:mi:ss') as
     date) - cast(cast(ATRA.audit_date as FORMAT 'yyyy-mm-dd hh:mi:ss') as
     date)),
            CASE
               WHEN (2 - (cast(cast(ATRR.audit_date as FORMAT 'yyyy-mm-dd
     hh:mi:ss') as date) - cast(cast(ATRA.audit_date as FORMAT 'yyyy-mm-dd
     hh:mi:ss') as date))) < 0 THEN 'N/A'
               ELSE (2  - (cast(cast(ATRR.audit_date as FORMAT 'yyyy-mm-dd
     hh:mi:ss') as date) - cast(cast(ATRA.audit_date as FORMAT 'yyyy-mm-dd
     hh:mi:ss') as date)))
           END
      FROM T_DWSRAD1DB. TE22AC1_Audit_trail     ATRR,T_DWSRAD1DB.
     TE22AC1_Audit_trail ATRA
     where ATRR.proc_id = ATRA.proc_id and ATRR.proc_id = 10

Audit_date datatype is timestamp which holds the value "2004-11-19 10:01:00.000000" and another values is "2004-11-22 15:35:00.000000".

we are using the same field for finding the days diff and hours diff and etc.

we are getting the days difference by executing the above query but we also need to get the hours diff and etc.

What is the procedure to get the days difference and hours difference and etc using the above given query?

Thanks in advance.

Venkataramanamurthy T
Tata Consultancy Services Limited

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