DATE_FORMAT in postgresql
If I modify your
Select DATE_FORMAT(date_time, '%b %e, %Y, %T') from table_name
to
Select DATE_FORMAT(now(), '%b %e, %Y, %T')
it will return Aug 21, 2012, 16:51:30
.
You can do the same thing in Postgresql:
Select to_char(now(), 'Mon-dd-YYYY,HH24:MM:SS')
will return you Aug-21-2012,16:08:08
Hope your problem is sort out.
Use to_char():
http://www.postgresql.org/docs/current/static/functions-formatting.html
I don't know what '%b %e, %Y, %T'
produces as an output (and you didn't supply a sample output), so I cannot give you the equivalent format mask for Postgres.
The following produces an ANSI date:
select to_char(date_time, 'yyyy-mm-dd hh24:mi:ss')from table_name;
Try this
SELECT to_char(date_time, 'dd.mm.YYYY') from table_name