Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 May 2003 @ 19:00:24 GMT


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


Subj:   Re: Time Stamp in Teradata
 
From:   Dieter Nöth

Anomy Anom wrote:

  I need to store timestamp after small interval in sequence. I also login and logout every time and I am is using Current_timestamp(0) function.. some time I start getting different times...  



Do you mean you submit a

"select timestamp_column from table"

and the result set is not ordered?

Rows are not ordered by Primary Index values in Teradata, so a new row is not appended after the "last" row. So if you select without ORDER BY you'll always end up with an unordered result set. This is different to most other RDBMSes.

Btw, it only looks unordered, rows *are* perfectly ordered by ROWID. You just won't recognize it due to hashing.


Dieter



     
  <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: 27 Dec 2016