Archives of the TeradataForum
Message Posted: Tue, 17 Nov 2009 @ 14:52:02 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|