On Thu, Apr 15, 2021 at 09:58:23AM -0400, Bruce Momjian wrote: > On Thu, Apr 15, 2021 at 04:45:44PM +0300, warst...@list.ru 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
