Database Administration (MOSC)

MOSC Banner

the time of my system is 10:00 and my database is 09:00 the difference is 1 hour

edited Mar 20, 2011 3:30PM in Database Administration (MOSC) 11 commentsAnswered
 Hello,

     The time of my system is 10:00 and my database is 09:00 the difference is 1 hour.
Is the problem of my database parameter ?

If it's the problem of my database, how can I change and what is the the parameter that I have to update.

thank you for your help.

regards

JP

My parameters is :

select * from v$nls_parameters;


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
AMERICAN

NLS_TERRITORY
AMERICA

NLS_CURRENCY
$


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA

NLS_NUMERIC_CHARACTERS
.,

NLS_CALENDAR
GREGORIAN


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RR

NLS_DATE_LANGUAGE
AMERICAN

NLS_CHARACTERSET
UTF8

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center