Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rOracle JDBC drivers and setting NLS_DATE_FORMAT in a logon trigger doesn't work
psst did you hear what "Andre van Winssen \(andrew\)" <andrew-no-spam-
svp_at_info.nl> said
> yes, this works .. in Oracle. But our javacode attempts to be
> database independent, so localizations (like NLS) must be as
> transparant for the application as possible.
>
> thanks for the input.
>
> Andre
>
couldn't you use a PreparedStatement set the date with a parameter. Since
date are longs your has to driver will do the conversion for you so it
shouldn't matter what format the date is stored in.
-- Joe "I bent my wookie" - Ralph WiggumReceived on Mon Mar 18 2002 - 13:40:34 CST