Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.


Shrihari Saraf

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