On Sun, 6 Nov 2016 22:59:27 -0500, Ryan Culpepper <ry...@ccs.neu.edu> wrote:
>I believe the db library is correct: "2016-05-01 05:00:00Z" and >"2016-05-01 00:00:00-05" refer to the same point in time. Oops! You're right. I was thinking backwards about how the difference would manifest. Thank you for the smack in the head, and apologies for being stupid. I think I will return the text form anyway - in addition to the binary timestamp - so that my logs are easier to read. Having the zone correct is easier for me to parse mentally. >See also the notes on PostgreSQL timestamptz here: >http://docs.racket-lang.org/db/notes.html#%28part._postgresql-timestamp-tz%29 I'm aware of the quirks with Postgresql's timestamptz. The requirement in this case is that the queries use local zone (equivalent) times. The users have to specify the times of interest and they should not need to know where the server is (logically) located. >Ryan Thanks, George -- You received this message because you are subscribed to the Google Groups "Racket Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to racket-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.