How to involve time to a Date column?

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 Received on Thu Sep 09 1999 - 07:03:18 CDT