Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: strange behaviour using to_char to return daynumber

Re: strange behaviour using to_char to return daynumber

From: <sybrandb_at_yahoo.com>
Date: 24 Apr 2006 07:30:15 -0700
Message-ID: <1145889015.050484.32300@t31g2000cwb.googlegroups.com>


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 DBA
Received on Mon Apr 24 2006 - 09:30:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US