milliseconds

[misuk11]

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

[gamyers]

Look into the TIMESTAMp datatype
http://download-west.oracle.com/docs....htm#sthref135

[misuk11]

unfortunately the database was migrated from Sybase and Im stuck with the underlying datatype so I cant change it to a timestamp.