Archives of the TeradataForum

Message Posted: Tue, 04 Dec 2007 @ 21:13:24 GMT

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

If you want dates like that to show up in SQL Assistant (Generally these are 'fake nulls', or 'unknown', so displaying blank is as good as an 'invalid' date) you can change the 'Display dates in this format' option on the General tab of the Options screen.

     Select the option 'YYYY-MM-DD'. (Second option)

This requires version 7.2, or higher, of SQL Assistant.

Excerpt from Help file:

YYYY-MM-DD - is the default ODBC date display format. This is the only format that will display dates having a year less than 100.

Mike Dempsey
Teradata Client Tools

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