Archives of the TeradataForum
Message Posted: Wed, 18 Nov 2009 @ 10:05:04 GMT
Thanks for the update. It is possible without using cast can this be achieved. The reason for this is customer can have different date format set for their database and the SQL's used in our application is not database specific most of the SQL's are ANSI standard. We have parameter file where we can specify the date format. Currently for Oracle what we do is we check the parameter file and execute the command
ALTER SESSION SET NLS_DATE_FORMAT='MM-DD-YYYY'
The above command fulfill our requirement. Is Teradata having similar command?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|