Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group