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-
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