Re: [GENERAL] date_trunc - not sure what is wrong, but it confuses me.

2011-08-24 Thread dexdyne
thanks. I hadn't used psql before, PgAdmin had been all I needed. You are right, \df does give the full info, and I do believe the manual isn't clear enough. TVM David -- View this message in context: http://postgresql.1045698.n5.nabble.com/date-trunc-not-sure-what-is-wrong-but-it-confuses-me-

[GENERAL] date_trunc - not sure what is wrong, but it confuses me.

2011-08-19 Thread dexdyne
I'm tearing my hair out trying to understand time zones. I want to use date_trunc to find the start and end of last day, week, month at a remote site. I looked at the date_trunc docs and they say function date_trunc(text, timestamp) Return Type timestamp Description Tr