I have two DB's on Two Different servers
server1 :
values current date
09/03/2007
insert into session.DateTable values DATE ('09/22/2007'); -- works fine
server 2:
values current date
03/09/2007
insert into session.DateTable values DATE ('09/22/2007'); --fails
and i have to change it to
insert into session.DateTable values DATE ('22/09/2007');
why the default format are different when the DB's have same codeset and territory code ??
..........db2 dates always confuses me......
