Sunday, January 30, 2011

How do you set default date setting in BTEQ?


How do you set default date setting in BTEQ?
Answer

There are two default date setting in BTEQ.  They have to be set after logging on to the session

set session dateform = ANSIDATE ;  /*format is yyyy-mm-dd */                
set session dateform = integerdate ; /* format is yy/mm/dd   -teradata date format */

No comments:

Post a Comment