Re: [racket-users] db: postgresql current_date -> timestamptz

2015-07-20 Thread George Neuner
On 7/20/2015 6:08 PM, Jay Kominek wrote: You might be ending up with different timezones set on the different connections, as libpq clients can automatically set/change some session settings that the racket library does not. I'd try running "show timezone" via both connections, and see what you e

Re: [racket-users] db: postgresql current_date -> timestamptz

2015-07-20 Thread Jay Kominek
You might be ending up with different timezones set on the different connections, as libpq clients can automatically set/change some session settings that the racket library does not. I'd try running "show timezone" via both connections, and see what you end up with. On Mon, Jul 20, 2015 at 12:29

[racket-users] db: postgresql current_date -> timestamptz

2015-07-20 Thread George Neuner
Hi all, I'm found something strange with Racket 6.1.1 and Postgresql (9.3.6): SQL that works differently in a Racket query than in the DB console. I have a table defined as create table blah ( a char(15), b char(15), created timestamp with time zone, expires