Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Nov 2004 @ 10:54:32 GMT


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


Subj:   Date Format in BTEQ
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 16, 2004 17:28 -->

I have created SQL that runs perfectly fine in Queryman but when I paste the same code into BTEQ (or do a BTEQ Export) I get an invalid date error.

In my SQL I am pulling the date from the dbc.tvmfields.fieldstatistics and having it formatted as YYYY-MM-DD. This is the same date that when pasted into BTEQ gives me an error. If I format the same date now to look like DD-MMM-YYYY I do not get the error in BTEQ but now one in Queryman.

Can someone help, I am hoping that there is a . setting in BTEQ that allows me to use the same date format no matter where I run the SQL. I don't want to have to have 2 sets of SQL that do the same thing.


Thanks,


P.S. Yes I know it is Teradata SQL Assistant now, just faster to type queryman.



     
  <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