InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 20:34:54 GMT20http://www.teradata.com/teradataforum/Topic11411-1-1.aspxHi,Sql assistant always shows date column in the format 'mm/dd/yyyy'Mon, 12 May 2008 07:03:29 GMTGraohttp://www.teradata.com/teradataforum/Topic11411-1-1.aspxI have created a table like this, CREATE MULTISET TABLE SADM_UTST_ETLBASE_INDIA.datecheck ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( dat DATE FORMAT 'YYYY-MM-DD') PRIMARY INDEX ( dat );when i am trying to insert statement insert into datecheck values('2004-02-03'),date values getting inserted in the format 02/03/2007,i dont know why its happening like this...Any help would be appreciated...thanks in advanceMon, 12 May 2008 00:40:58 GMTsarvan135