When sending timestamps to PGSL, you have to do this:
SimpleDateFormat df = new SimpleDateFormat("EEE MMM dd hh:mm:ss.S yyyy
z");
sql.append("WHERE dateField =
'").append(df.format(someJavaDate)).append("'");
That's for the default date formatting on the servet. You can also
change that format on the server, but I don't know how.
-Nissim
christopher baus wrote:
>
> I am considering postgreSQL for my turbine backend, but I seem to be having
> problems with timestamping of user logins. It seems the JDBC driver doesn't
> like the the time stamp format turbine is giving it, and throws an exception
> when it requeries the last login time stamp.
>
> Anyone else seeing this?
>
> ~christopher
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
