Re: How to change the date in a postgres database via JDBC

[Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>]

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

Attachment: signature.asc
Description: This is a digitally signed message part