Re: How to change the date in a postgres database via JDBC - Mailing list pgsql-jdbc

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