Date and time manipulation in Teradata
A tutorial article on how to handle date and time variables in Teradata (including discrapancies listing between V2R4 and V2R5). It contains information on timestamp data type sys_calendar.calendar, date intervals calculations and more. Clear examples help...
http://www.teradataforum.com/l040409a.htm
A tutorial article on how to handle date and time variables in Teradata (including discrapancies listing between V2R4 and V2R5). It contains information on timestamp data type sys_calendar.calendar, date intervals calculations and more. Clear examples help...http://www.teradataforum.com/l040409a.htm
String operations in Teradata
A tutorial article on how to handle character variables (strings) in Teradata SQL. The tutorial show how to concatenate strings, convert strings to hexadecimal value using CHAR2HEXINT function, locating characters in a string (INDEX, POSITION functions),...
http://readvitamin.com/2007/08/08/string-manipulations-in-teradata-sql/
A tutorial article on how to handle character variables (strings) in Teradata SQL. The tutorial show how to concatenate strings, convert strings to hexadecimal value using CHAR2HEXINT function, locating characters in a string (INDEX, POSITION functions),...http://readvitamin.com/2007/08/08/string-manipulations-in-teradata-sql/