Postgres Running in Docker Container: Change current time, now() to custom date time

0
votes

I have a postgres timescale database running in docker. For the purposes of api testing I want SELECT NOW() to return lets say 2010-12-01 23:00:44.851242 +00:00. Basically every time I start up the container I want it to think the current date is some time in December 2010.

How can I achieve this? I cant seem to find any command to set current time in postgres. Do I need to change the system time in the docker container before the database shows up? Is that even something I can do?

postgresqldockertimescaledb
Hi Scott I found a heap of suggestions in this Stack Overflow question in case any of these work for you. stackoverflow.com/questions/29556879/… I think Postgres would use the server time? - greenweeds