|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/12/2008 4:42:20 AM
Posts: 1,
Visits: 5
|
|
I 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 advance
sarvan
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 8/27/2008 6:21:47 AM
Posts: 36,
Visits: 69
|
|
Hi,
Sql assistant always shows date column in the format 'mm/dd/yyyy'
Regards,
GRR
|
|
|
|