<strong>Storage TIME in Oracle </strong>
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Thursday, April 4, 2002 05:45 AM

This is very weird, I have a DATE Oracle datatype. I
want to storage the time also in that register.


I think the DATE format is:


YYYY-mm-dd
00:00:00.0


But I only can record it like this:


04-Apr-2002


Is it possible to record the time
(07:39:56.4) in this field?


If is not possibly, how can I record ONLY the
time?


Thanks


JJ

Report | Quote This | Send private message | Reply | Print

Re: <strong>Storage TIME in Oracle </strong>

Posted By:   Anonymous  
Posted On:   Thursday, April 4, 2002 06:12 AM

When you do your insert or select, make sure you use the setTimeStamp and getTimeStamp methods of the PreparedStatement, because setDate and getDate don't get the time.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact