Can I pass in a frozen time as a setting into postgresql and not have clock drift?
You could abuse a placeholder variable:

SET request.time = '2019-11-21 09:00:00';


Then you can use current_setting('request.time') in your queries to retrieve the string.