Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: strange behaviour using to_char to return daynumber
No, it doesn't. If you don't set anything you'll get Windows specific
defaults.
Just run
select * from nls_session_parameters
/
in sqlplus from the client and verify them with the servers settings.
I found out when I ran into a case of
create table blablad(timestamp date default '31-12-00')
This assumed the default dateformat was dd-mm-yy. It was on the client.
It wasn't on the server.
Boy, I had fun. My import failed completely.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Apr 24 2006 - 09:30:15 CDT