CDBI and Oracle dates

[prev] [thread] [next] [Date index for 2004/11/24]

Does anyone know how I can insert date _and_ time information into an
Oracle DATE field?

I'm working with an Oracle 9.2.0.4.0 database table's DATE field using
CDBI.  Since Oracle expects a specific date format, DD-MMM-YY, I can
convert a date to that string format, and save it, but I then lose the
time information.  

Any thoughts on a workaround?

-Josh


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail