« August 2012 | Main | November 2012 »

September 10, 2012

Casting and formatting dates in PostgreSQL

select to_char(to_timestamp(now()::abstime::int4), 'Day DD Month YYYY HH24:MI:SS') as "The Day Today"

Posted by pj at 09:04 PM | Comments (0)