Home Page for the TeradataForum


UDF Library: 'stat_dt'

Component: 'readme.txt'

  stat_dt.c >>

Function: stat_dt

Author:   Geoffrey Rommel

Purpose:  This UDF converts the first 4 bytes of a FieldStatistics or
          IndexStatistics column to an ordinary DATE data type. This
          can be used to find the date on which stats were last collected.
          Converting the first 8 bytes to TIMESTAMP is left as an
          exercise for the reader. ;-)


          select stat_dt(FieldStatistics), DatabaseName, TableName, ColumnName
             from DBC.ColumnStats
           where FieldStatistics is not null
           order by 1;

  stat_dt.c >>

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