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
> Joe,
> >>date are longs
> what do you mean ?
>

a java.util.Date is long of milliseconds since some date.

I always use a PreparedStatement
ps=conn.prepareStatement("insert into tablename (datecolumn) values(?)"); ps.setTimestamp( 1, new Timestampe( new java.util.Date() ) ); ps.executeUpdate();

if you have a string you need to covert to a date you can use java.text.DateFormat or java.text.SimpleDateFormat to parse the String.

-- 
Joe

"I bent my wookie" - Ralph Wiggum