Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 04 Jan 2008 @ 17:58:54 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Model Timestamp or (DATE and TIME)
From:   Anomy Anom

<-- Anonymously Posted: Fri, 4 Jan 2008 08:35 -->

I need to capture timestamp information - call this column x.

Should I model it as TIMESTAMP(n) or use 2 columns : DATE and TIME(n)

What are the pros and cons?

Here are some usage considerations :

Only the date part, x (date), may be used in joins between tables.

This column will be used in WHERE clauses. The WHERE clause can be in either format

1) WHERE x (date) between 2 date literals

2) WHERE x (timestamp) between 2 timestamp literals

This column will also be used in PPI (with intervals of 1 day or 1 month).

Is there any case when TIMESTAMP(n) will perform better than DATE+TIME(n)? I see none. Irrespective of usage patterns, I am leaning towards always modeling it as DATE+TIME(n), and in the view I would join these 2 to expose as TIMESTAMP(n) (in addition to DATE and TIME(0)).

Thank you

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020