Archives of the TeradataForum

Message Posted: Thu, 09 Jan 2003 @ 19:51:39 GMT

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

When trying to run the following query via FASTEXPORTor BTEQ on a SOLARIS unix server hitting our Teradata Server, it won't FORMAT the date as requested. Seems to ignore the FORMAT statement.

When run via BTEQ thru our mainframe, it works fine.

Any suggestion??

SELECT WHS_RPT_EFF_DT  (FORMAT 'MM-DD-YYYY') , CLI_ID, WHS_LOAD_DT
  FROM CTDWHK.WHS_CNTR_ARTFACT
   WHERE CLI_ID IN (60095, 60564);

Thanks,

Anthony S. Howe
Certified Teradata Professional
Teradata/DB2 Database Administrator
Highmark Blue Cross/Blue Shield

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