> >> 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. It does. /Magnus
