Regarding Inserting Date values

UDA

Regarding Inserting Date values

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

1 REPLY
Enthusiast

Re: Regarding Inserting Date values

Hi,

Sql assistant always shows date column in the format 'mm/dd/yyyy'