Re: Storing time values via jdbc thin driver

From: <>
Date: Sun, 30 Nov 2008 16:23:42 -0800 (PST)
Message-ID: <>

On Nov 29, 9:54 am, "gym dot scuba dot kennedy at gmail" <> 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
Received on Sun Nov 30 2008 - 18:23:42 CST

Original text of this message