Question: We receive a file from an external provider. One of the columns contains a timestamp in the form "05/01/2014 09:25:41 AM EDT". I am trying to insert this into a TIMESTAMP WITH TIME ZONE column with the following SQL:

`INSERT INTO table VALUES (to_timestamp_tz('05/01/2014 09:25:41 AM EDT', 'MM/DD/YYYY HH12:MI:SS AM TZR TZD'));`

That is when I get `ORA-1882: timezone region not found`. I've also tried specifying this like

`INSERT INTO table VALUES (to_timestamp_tz('05/01/2014 09:25:41 AM EST EDT', 'MM/DD/YYYY HH12:MI:SS AM TZR TZD'));`

but then I get `ORA-1857: not a valid time zone`.

Anyone have an idea how I can insert this? We are running Oracle 11.2.0.3. I can see in `v$timezone_names` that EST and EDT both appear to be valid tzabbrev for tzname 'America/New York'.

EDIT:

It appears that if I substitute EST5EDT for EDT (and CST6CDT, MST7MDT, and PST8PDT for CST, MST, and PST, respectively) , I can get the behavior I need. The problem with this is that I need to know what these substitutions are in advance so I can code around them. I still need to know how to handle potential daylight savings time issues with other timezones.

Answer: 
* Server-sided: Runs on server (like Node.js)
* Client-sided: Runs in browser
* Core: The set of functionality available to all javascript engines
Without knowing the book, I can't tell you what is the meaning of `CoreJavaScript`, but in what concerns to the first two the difference is:

Client side javascript as the name says, is javascript code, running on the client side, a typical scenario of this is, when you access a website, and you run javascript code. The code being executed is being executed on the clients machine. This is why it's called client side javascript.

**About the second**, server side javascript, is javascript code running over a server local resources, it's just like C# or Java, but the syntax is based on JavaScript, a good example of this is Node.JS, with Node.JS you write javascript to program on the server side, and that code can be seen as normal C#, C, or any other server side language code.

With server-side code, you can still send javascript to the client-side, but there is a great diference between both, because the client side code is restricted to the clients machine resources, in terms of computing power and permissions. For example client-side javascript can't access the clients hard disk, while with server side you can access your server hard disk without any problem.

**UPDATE**

I've read a bit of the book, and `Core JavaScript` is about the JavaScript language per se (JavaScript Reference), i.e, the syntax, the statements, the function definitions, it's the basics of the language in general.

Imagine you are reading about C# or Java, before writing about Sockets Programming, WebServices, etc, the book is giving the reader an insight of the language first, in terms of it's capabilities, ways to create functions, arrays, and so forth.