From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | niromon <morin(dot)arnaud(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: How to change the date in a postgres database via JDBC |
Date: | 2010-02-24 19:58:24 |
Message-ID: | 1267041504.2019.715.camel@hp-laptop2.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | shilpa r | 2010-02-25 08:11:57 | path and classpath settings |
Previous Message | niromon | 2010-02-24 17:00:12 | How to change the date in a postgres database via JDBC |