|
-
milliseconds
has anyone had any experience using dates down to the millisecond level ?
I'm converting an app from sybase to oracle and Im trying to convert
datediff(ss, '1900-01-01 12:00:00:000AM', transhist_duration_tim) * 300 as duration,
to its oracle equivalent like this
((((transhist_duration_tim - TO_DATE('01/01/1900:12:00:00AM', 'dd/mm/yyyy:hh:mi:ssam'))*24) *60) *60) * 300 as duration,
the sybase version calculates down to the millisecond, but how can this be done with oracle ?
im using 10g
tia
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|