Обсуждение: How to change the date in a postgres database via 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.

On Wed, 2010-02-24 at 09:00 -0800, niromon wrote:

> 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';

(If I understood your question correctly: )

If you use now() *in a transaction*, time won't change:

test=# BEGIN ;
BEGIN
test=# SELECT now();
              now
-------------------------------
 2010-02-24 19:15:02.212511+02
(1 row)

test=# SELECT pg_sleep(5);
 pg_sleep
----------

(1 row)

test=# SELECT now();
              now
-------------------------------
 2010-02-24 19:15:02.212511+02
(1 row)

test=#

I don't know any other way to use a fixed date.

--
Devrim GÜNDÜZ, RHCE
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz