Re: Is there a way to change current time?

[Justin Pryzby <pryzby@xxxxxxxxxxxxx>]

On Thu, Apr 15, 2021 at 09:58:23AM -0400, Bruce Momjian wrote:
> On Thu, Apr 15, 2021 at 04:45:44PM +0300, Warstone@xxxxxxx wrote:
> > Hi,
> >  
> > Is there any way to set time that CURRENT_TIMESTAMP and/or now() will give next
> > time? (We need it only for testing purposes so if there is any hack, cheat,
> > etc. It will be fine)
> 
> No, it gets the time from the operating system.

You could overload now():

postgres=# CREATE DATABASE pryzbyj;
postgres=# \c pryzbyj
pryzbyj=# CREATE SCHEMA pryzbyj;
pryzbyj=# CREATE FUNCTION pryzbyj.now() RETURNS timestamp LANGUAGE SQL AS $$ SELECT 'today'::timestamp $$;
pryzbyj=# ALTER ROLE pryzbyj SET search_path=pryzbyj,public,pg_catalog;
pryzbyj=# SELECT now();
now | 2021-04-15 00:00:00

-- 
Justin