Xref: alice comp.databases.oracle.misc:40687 comp.databases.oracle.server:65210
Path: alice!news-feed.fnsi.net!enews.sgi.com!logbridge.uoregon.edu!newsfeed.icl.net!newsfeed.icl.net!nntp.news.xara.net!xara.net!gxn.net!news.good.net!cyclone.interactive.net!reader1.interactive.net!not-for-mail
Message-ID: <37D7A206.BB001020@interactive.net>
From: Ninon <ninon@interactive.net>
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: How to involve time to a Date column?
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
Lines: 15
Date: Thu, 09 Sep 1999 08:03:18 -0400
X-Trace: reader1.interactive.net 936921916 216.107.140.54 (Thu, 09 Sep 1999 20:05:16 EDT)
NNTP-Posting-Date: Thu, 09 Sep 1999 20:05:16 EDT

Hi there,

Could somebody tell me how to involve time in a Date column?
The default format is like "09-Sep-1999". I could use it but just need
time involved too.

I tried to use JDBC's Timestamp whose format is like
1999-9-9 12:00:00.000, just same as the dates selected from my table,
but got an error message "literal doesn't match format string".

Thanks a lot!

-Ninon