Forum OpenACS Q&A: Re: UTC EST, we all TZ for UTC

Posted by Darren Ferguson on
You could try looking at the to_char functionality provided by postgresql. You can remove all that crap by doing the following: select to_char(current_timestamp,'mm-dd-yyyy hh24:mi:ss')::timestamp

This will give you it without all the UTC and offsets.

You can also format it the way you wish it does not have to be the way i have done it.