Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Joseph Shraibman wrote:
>> So what happens if you have an old os with a new postgresql install?
>> Will CURRENT_TIMESTAMP always return the correct value even if the
>> system 'date' command is showing the wrong time?
> Yes.
Unless the user changes the system's clock setting (ie, its notion of
the current UTC time) so that what he sees from "date" looks right.
Also, what about Windows? I'm not clear whether Windows tries to keep
system time in UTC or not. Even if it does, it'd be vulnerable to the
same pilot-error problem.
regards, tom lane