Archives of the TeradataForum

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

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

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>>