My Oracle Support Banner

RDBPROD: How to retain second precision (fraction value) when passing a DATE VMS column into RDBMS (Doc ID 565571.1)

Last updated on AUGUST 07, 2018

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.2 and later
Oracle Rdb Server on OpenVMS - Version 7.2 and later
Information in this document applies to any platform.


Goal

When transferring data from an Rdb table into an RDBMS table, how can the millisecond values from a DATE VMS column be retained in the transfer?

Currently the time value is being truncated down to seconds.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.