All Forums Analytics
adityasoni26 1 post Joined 01/13
23 Jan 2013
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?

Qaisar Kiani 337 posts Joined 11/05
29 Jan 2013

No it shouldn't...

Adeel Chaudhry 773 posts Joined 04/08
04 Feb 2013

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

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.