Jeremy Morton <admin@game-point.net> writes:
> At just about every development shop I've worked for, I've seen
> developers use methods to get a local DateTime - both in the DB and in
> the code - such as DateTime.Now, and throw it at a DateTime field.
> Heck, even I've occasionally forgotten to use .UtcNow. With
> DateTimeOffset.Now, you can't go wrong. You get the UTC time, and the
> offset. I've taken to using it 100% of the time. It's just really handy.
It sounds like what you are describing is a client-side problem, not
a server issue. If you have such a thing in the client code, why
can't it readily be mapped to timestamptz storage in the server?
regards, tom lane