Ericson Smith <[EMAIL PROTECTED]> writes: > I realized I made a mistake in that initial email (should have said 12am > instead of pm). However, I tried:
>>> set local time zone 'EST5EDT'; > SET >>> select now(); "set local" was probably not what you wanted to use here. Per the man page: Note that SET LOCAL will appear to have no effect if it is executed outside a BEGIN block, since the transaction will end immediately. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org