Re: Support for DATETIMEOFFSET

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