Display Oracle NLS settings with "select * from nls_database_parameters;"
PARAMETER VALUE ------------------------------ ---------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P15 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM PARAMETER VALUE ------------------------------ ---------------------------------------- NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_NCHAR_CHARACTERSET WE8ISO8859P15 NLS_RDBMS_VERSION 8.1.7.0.0 ----- Original Message ----- From: "Robert S. Sfeir" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 17:23 Subject: Re: Oracle date tip > Joe Germuska wrote: > > > At 6:02 PM -0500 2/19/04, Andy Malakov wrote: > > > >> Brad, > >> > >> I do not think it is OJB/JDBC problem. > >> > >> What is strange about your mail is the fact that NLS_DATE_FORMAT > >> fixed the problem - instead of NLS_TIMESTAMP_FORMAT. Since you > >> applied JavaDate2SqlTimes converter - all your dates at JDBC level > >> should have been converted to java.sql.Timestamp. > >> > >> Please do not be confused by the way P6SPY displays generated JDBC > >> query (it may be approximate). > > > > > > Oracle doesn't have a TIMESTAMP type; its "DATE" encompasses SQL TIME, > > TIMESTAMP, and DATE. > > > No I think you misunderstood the meaning of TIMESTAMP with Oracle in > this case. With MySQL for example Timestamp column is just that a > timestamp from the DB, nothing you can insert into, like an auto date > column. In Oracle timestamp contains the date AND time in the field, > where as the date field contains just the date. > > R > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
