Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Dec 2001 @ 16:26:21 GMT


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


Subj:   Date & time of statistics
 
From:   Geoffrey Rommel

The question of how to extract the date & time of statistics from dbc.tvfields.fieldstatistics has come up a few times on this list. I would just like to point out that, instead of writing some gnarly CASE or INDEX expressions, you could define a little table to translate the dates in BYTE(4) format to ordinary DATEs. You could do something similar with the times. Out of perversity, not to mention my employer's restrictions, I won't divulge the details of how to do this, but I have done it and it works nicely.

--wgr



     
  <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