ormation here:
>
> https://docs.oracle.com/javase/7/docs/api/java/sql/Date.html
>
> milliseconds since January 1, 1970 00:00:00.000 GMT.
>
> Turn on/up logging in Postgres and run a query with that java.sql.Date
> object. I am betting that what you will see in the logs is an integ
eries like this and I would
like to know why it happens and if I can make it work changing the query
and not the code.
2017-02-10 15:38 GMT-05:00 rob stone :
> Hello Roberto,
> On Fri, 2017-02-10 at 10:17 -0500, Roberto Balarezo wrote:
> > Hi, I would like to know why this is happen
:
> On 02/10/2017 07:17 AM, Roberto Balarezo wrote:
>
>> Hi, I would like to know why this is happening and some advice if there
>> is a way to solve this problem:
>>
>> I have a query like this:
>>
>> |select COALESCE(duedate, ? + 1) from invoices order
date with one day added. So the query is correct.
2017-02-10 16:33 GMT-05:00 Arjen Nienhuis :
>
>
> On Feb 10, 2017 8:11 PM, "Roberto Balarezo" wrote:
>
> Hi, I would like to know why this is happening and some advice if there is
> a way to solve this problem:
Hi, I would like to know why this is happening and some advice if there is
a way to solve this problem:
I have a query like this:
select COALESCE(duedate, ? + 1) from invoices order by duedate desc limit 10;
where ? is a query parameter. I’m using JDBC to connect to the database,
and sending par
Hi,
I was trying to clean a database by deleting records of some of its tables.
But in our model we have a table that is heavily referenced, that is, many
tables reference this particular table by foreign key constraints. We don't
have foreign key indexes, so executing a delete from mytable takes
