From: | Vinayak <vinpokale(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Problem with DATE |
Date: | 2015-01-13 06:42:54 |
Message-ID: | 1421131374401-5833708.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
I have checked the below description in one post:
If the timestamp parameter is given, the jdbc does not know if it is to be
used timestamp or timestamptz. The jdbc driver passes it to the server as an
unknown data type letting the server figure out what to do with it.
Example:
timestampcol = ? or if you're inserting into a timestamp field so the server
can determine the datatype of parameter being used at, in this case since
its just being sent back to the user the server cannot determine the data
type.
so we need to typecast it.
"SELECT ?::timestamp"
Is the same problem for date type also?
-----
Regards,
Vinayak,
--
View this message in context: http://postgresql.nabble.com/Problem-with-DATE-tp5833008p5833708.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2015-01-13 11:45:56 | Re: Problem with DATE |
Previous Message | Vinayak | 2015-01-13 04:27:50 | Re: Problem with DATE |