Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[b]Adding millisecond to a date[/b]

387318Aug 1 2003 — edited Aug 3 2003
Hi,
I am creating a view out of a table and one of the view column is based on two table columns: one is a date/time column and the other is an integer column(containing milliseconds) in the table.

My question is, how do i add the milliseconds to the date.
i tried using Date + Interval, but the interval only takes seconds.

Please note that the integer column containing milliseconds could be greater than 1000.

Thanks,
Vasu

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2003
Added on Aug 1 2003
3 comments
770 views