Archives of the TeradataForum

Message Posted: Thu, 26 Jul 2007 @ 14:52:58 GMT

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

thanks all for your replays

With now decimal(18,0) cast or with the cast by every NumValueswN I get also the invalid date error. When i exclude this columns, then i get a result. But im not sure if everything is correct. Here is the output:

     DatabaseName TableName ColumnName ColumnCount StatsType StatsVersion
     SampleSize NumRows  NumValues NumNulls ModeFreq
     kurs_db      dropme    d          1           C         2            100
     1.23E+18 1         0.00E+00 1
     kurs_db      dropme    i          1           C         2            100
     1        1         0.00E+00 1
     kurs_db      dropme    ts         1           C         2            100
     1        1         0.00E+00 0.00E+00

I created the table and inserted the timestamps, here is the output from the select:

     ColumnName STATisticts
     D707071A0A08386302000000000000000000000000000000010000000000000020043600
     D7070719151800000000000020043600D70707191518000000000000000000000000F03F
     000000000000F03F
     d
     D707071A0A08393402000000000000000000000000000000010001000000000081E97DF4
     1022B14381E97DF41022B143000000000000F03F000000000000F03F000000000000F03F
     81E97DF41022B143
     i
     D707071A0A083A0002000000000000000000000000000000010001000000000000000000
     0000F03F000000000000F03F000000000000F03F000000000000F03F000000000000F03F
     000000000000F03F

its not exactly the same what you get.

thanks for your help.

Dani

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