Forum OpenACS Q&A: Re: UTC EST, we all TZ for UTC
3: Re: UTC EST, we all TZ for UTC (response to 1)
Posted by Darren Ferguson on 10/03/03 04:37 PM
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.