Thursday, 25 October 2012

How do you set default date setting in BTEQ? | Teradata Interview Questions

There are two default date setting in BTEQ. They have to be set after logging on to the session
They are
Set session dateform = ANSIDATE; /*format is yyyy-mm-dd */
Set session dateform = integerdate; /* format is yy/mm/dd -teradata date format */

No comments: