Re: How to involve time to a Date column?

From: <owais_anjum_at_my-deja.com>
Date: Fri, 10 Sep 1999 05:13:34 GMT
Message-ID: <7ra41p$lr9$1@nnrp1.deja.com>

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

Use oracle conversion function to_char if the incoming field is already a date e.g.

OWAIS> Select to_char(SysDate,'DD-MON-YYYY-HH:MM:SS') today from dual;

TODAY

---

10-SEP-1999-10:09:17 Good Luck

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