Re: How to involve time to a Date column?

From: Ben Ryan <benryan_at_my-deja.com>
Date: Fri, 10 Sep 1999 05:01:20 GMT
Message-ID: <7ra3as$le5$1@nnrp1.deja.com>

CREATE TABLE junk (x DATE);

INSERT INTO junk

VALUES (TO_DATE('14:00:00 10-SEP-1999','HH24:MI:SS DD-MON-YYYY')); COMMIT; SELECT TO_CHAR(x,'HH24:MI:SS DD-MON-YYYY') FROM x;

In article <37D7A206.BB001020_at_interactive.net>, Ninon <ninon_at_interactive.net> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 10 1999 - 00:01:20 CDT