Using different date formats

Analytics

Using different date formats

I see that my column is in the date format 'yyyy-mm-dd'. Would it affect processing speed if I were to compare this column with another column or parameter in the format CYYMMDD?

Tags (1)
2 REPLIES
Enthusiast

Re: Using different date formats

No it shouldn't...

Teradata Employee

Re: Using different date formats

Teradata stores the date internally as an integer, so it doesnt affect the comparison or processing speed.