Re: How to solve probably a very simple DATE problem?

From: <sybrandb_at_hccnet.nl>
Date: Sat, 15 Sep 2007 16:20:02 +0200
Message-ID: <r9qne3t05d4unhl50cf73n4ib6hd8ngs0u@4ax.com>

On Sat, 15 Sep 2007 13:49:46 GMT, "harry" <a_at_abc.com> wrote:

>thanks for that, shows "+01:00" which I assume is because we're in BST?
>
>does that mean though that the values held in DATE fields will be held as
>"00:00"?
>
>this is the bit that's confusing me - are all oracle date/timestamp fields
>anywhere in the world held in the same way & just displayed differently
>depending your location?
>

It appears that all over the world humans are reading from top to bottom, maybe from right to left, but always from top to bottom. Please do NOT reply ABOVE the message (also known as 'top-posting') as that will result in very nasty replies in this forum. Some people won't even respond to you.

Also be aware DATE columns do NOT contain timezone information. The TIMESTAMP datatype does.
The Globalization Manual for your version and/or the SQL referenace manual is the place to read up on this.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Sat Sep 15 2007 - 09:20:02 CDT