Teradata Tutorial - Useful Link (note to self)

For useful syntax and notes re Teradata, look here
 http://readvitamin.com/teradata/


To remove leading '0's in Teradata 
select trim(leading '0' from col) from table_A;


Add one day to date field

select cast('28/02/2012' as date format 'dd/mm/yyyy' ) + INTERVAL '1' day;