Archives of the TeradataForum

Message Posted: Wed, 18 Nov 2009 @ 10:05:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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?

Regards

Shrihari Saraf

	<Prev	Next>		<<First	<Prev	Next>	Last>>