Re: Storing time values via jdbc thin driver
From: <phil_herring_at_yahoo.com.au>
Date: Sun, 30 Nov 2008 16:23:42 -0800 (PST)
Message-ID: <da7df41d-bd1a-42f8-8219-c1b74e905953@35g2000pry.googlegroups.com>
Date: Sun, 30 Nov 2008 16:23:42 -0800 (PST)
Message-ID: <da7df41d-bd1a-42f8-8219-c1b74e905953@35g2000pry.googlegroups.com>
On Nov 29, 9:54 am, "gym dot scuba dot kennedy at gmail"
<kenned..._at_verizon.net> wrote:
> Actually no. Oracle only knows time and date together. In Oracle there is
> no stand alone time data type.
Strictly speaking, that isn't true; the INTERVAL type can be used to specify a time of day without reference to any particular date. (The reason being a time of day is just a period of time - i.e., an interval - since the previous midnight.)
However, not many people would think to use an INTERVAL in this way.
- Phil