Solved

Oracle

Posted on 2013-05-30
9
427 Views
Last Modified: 2014-04-02
Can someone look at my attached screen shot and explain to me what -08:00 truly means in terms of a system timestamp on a Oracle 11g database?  Does this mean that we are 8 hours of GMT?
Timestamp.jpg
0
Comment
Question by:akdreaming
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 23

Expert Comment

by:tailoreddigital
ID: 39209441
Yes,  -08:00 represents the timezone in relation to GMT.   It's another way to say Pacific Time.  So the local time is based in,
timezone
0
 

Author Comment

by:akdreaming
ID: 39209455
Well, we are in Alaska.....on our own time zone.  We are one hour behind Pacific time.  Does it look right?
0
 
LVL 23

Expert Comment

by:tailoreddigital
ID: 39209477
Is the database on a system in Alaska? Or could it be remote?

I just ran across this about Alaska's timezone,

"Effective 2007, the local time changes from AKST to AKDT at 02:00 LST to 03:00 LDT on the second Sunday in March and returns at 02:00 LDT to 01:00 LST on the first Sunday in November."

It sounds like it might use -08 between March and November.

FYI,
http://en.wikipedia.org/wiki/Alaska_Time_Zone
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:akdreaming
ID: 39209500
Yes, everything we have running is in the Alaska timezone.  Nothing hosted outside of Alaska.  The issue we are having is we use an application called Appworx, which runs off of a Oracle database.  The server the Oracle database is running on was upgraded to 11g from 10g.  Appworx seemed to run fine.  Appworx is basically a batch job scheduler.  Then we upgraded the server itself from Windows 2003 Server to Windows 2008R2.  Appworx is having issues.  Can login to application but some jobs are failing due to some sort of timing issue.  Date stamp on database is correct.  Time on server is correct.  Before any of these upgrades, there was no issue with Appworx or timing issues.  We've never had to do anything concerning the timezone subject concerning our database.
0
 
LVL 23

Expert Comment

by:tailoreddigital
ID: 39209534
I don't have any experience with Appworx.    I did a bit of researching on this issue but nothing comes up.    Hopefully another expert with the right experience can help.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39209645
>>Windows 2003 Server to Windows 2008R2
I'd be double-checking the time/locale settings on the servers - my memory on this is vague but there were some changes in Windows regarding handling daylight savings as well
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39209696
Also check out this:  Setting the Database Time Zone

http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch4datetime.htm#NLSPG262
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 39209708
your database server's operating system timezone is set with a -8 hour offset from UTC/GMT

The time zone offset reported by systimestamp has nothing to with the database time zone, which should always be +0:00.

I have no idea why Oracle allows you to set or query that value since there is no value in doing so, and they even note in their own documentation, as slightwv pointed out, that you should just leave it alone at +0:00
0
 

Expert Comment

by:manny17
ID: 39973412
Yes, that's the timezone wrt to GMT
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question