Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Nov 2009 @ 10:05:04 GMT


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


Subj:   Re: Query on date format
 
From:   Shrihari Saraf

Hi,

Thanks for the update. It is possible without using cast can this be achieved. The reason for this is customer can have different date format set for their database and the SQL's used in our application is not database specific most of the SQL's are ANSI standard. We have parameter file where we can specify the date format. Currently for Oracle what we do is we check the parameter file and execute the command

     ALTER SESSION SET NLS_DATE_FORMAT='MM-DD-YYYY'

The above command fulfill our requirement. Is Teradata having similar command?


Regards

Shrihari Saraf



     
  <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: 23 Jun 2019