How to change the date in a postgres database via JDBC

From: niromon <morin(dot)arnaud(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: How to change the date in a postgres database via JDBC
Date: 2010-02-24 17:00:12
Message-ID: 27714250.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Hi,

I need to build a JUnit test that involes to change the date of the database
during the test.
I know how to do that with Oracle :
ALTER SYSTEM SET fixed_date = '2003-01-01-10:00:00';

But I work with Postgres now and I've found nothing about it on the web.

Someone can help me ?

have a nice day.

Arnaud
--
View this message in context: http://old.nabble.com/How-to-change-the-date-in-a-postgres-database-via-JDBC-tp27714250p27714250.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-02-24 19:58:24 Re: How to change the date in a postgres database via JDBC
Previous Message Albe Laurenz 2010-02-24 08:47:22 Re: COPY problem in JDBC driver