Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   FORMAT Problem
 
From:   Tony Howe

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023