patrick_at_gwiasda.de wrote:
> Hi,
>
> I have an Database Link over ODBC and have Problems to get the fraction
> of the seconds from the remote database.
> I found in the help of Oracle that the Timesstamp is affected by the
> HS_NLS_TIMESTAMP_FORMAT parameter.
>
> I Have set
>
> HS_NLS_TIMESTAMP_FORMAT = yyyy-mm-dd hh:mi:ss.ff
> HS_FDS_CONNECT_INFO = XXXXXXXX
> HS_FDS_TRACE_LEVEL = 9
>
> in my initXXXXXX.ora but this parameter gives me an error if I try to
> test the link.
>
>
> Any Hints ?
>
>
> mfg
>
> Patrick Gwiasda
>
Format MASK.. so, quotes required?
HS_NLS_TIMESTAMP_FORMAT = 'yyyy-mm-dd hh:mi:ss.ff'
And timestamps usually come in millisecs, microsecs or nanosecs, the
formats would be 'yyyy-mm-dd hh:mi:ss.ff3', 'yyyy-mm-dd hh:mi:ss.ff6',
and 'yyyy-mm-dd hh:mi:ss.ff9', respectively.
'yyyy-mm-dd hh:mi:ss.ff6' is the default for a timestamp, ie,
datatype timestamp == timestamp(6).
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Dec 23 2005 - 14:17:39 CST
