Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 17 Nov 2009 @ 14:52:02 GMT


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


Subj:   Query on date format
 
From:   Shrihari Saraf

Hi All,

I have a problem while inserting the date value in different format than the database date format.

I have a table

     CREATE TABLE TEST.Test_date
          (Date_test DATE FORMAT 'YYYY-MM-DD')

Through some application I ll be getting the date format as MM/DD/YYYY. The insert command will be

     Insert into test.test_date values( 11/17/2009 )

The above insert will fail. I want to know how we can change the date format in runtime. In oracle we can do this using alter session set data format command.

Please let me know how to do this.


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: 27 Dec 2016