Archives of the TeradataForum

Message Posted: Mon, 10 Nov 2003 @ 18:23:24 GMT

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

Remember, if you are running your query through QueryMan or some other ODBC reliant application, ODBC will ignore the format clause. If you run through a CLI interface, such as BTEQ (WinBteq) it should work the way you expect.

BTW: you don't need to use cast to use the format clause...

        SELECT date (FORMAT 'MMDDYYYY'), date
        FROM branch;

FYI: The second date column will use either the format stated on the ddl for the branch table, or the system wide default taken from the DBS control record - General Fields #21 (Default Date Format) if the ddl has no format clause.

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