Re: Problem with DATE
| От | Dave Cramer |
|---|---|
| Тема | Re: Problem with DATE |
| Дата | |
| Msg-id | CADK3HHKogHhRauJ9w9Dr=H_qinbaZcc6v6ZLXYnAuaxLmLz0xg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with DATE (Vinayak <vinpokale@gmail.com>) |
| Ответы |
Re: Problem with DATE
Re: Problem with DATE |
| Список | pgsql-jdbc |
No there is no similar problem for Date as there is only one date type in postgresql. If all you need is date then you should able to use that
On 13 January 2015 at 01:42, Vinayak <vinpokale@gmail.com> wrote:
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.htmlSent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
В списке pgsql-jdbc по дате отправления: