Thread: Date format

Cristi,

Please stick to posting your questions on the NOVICE list, rather than
NOVICE and SQL.

> I try to set up PG7.1.3
> The date format now is yyyy-mm-dd
> How can I start it in date format mm-dd-yyyy?
>
> in posgresql file  I have:
> .......-p /usr/bin/postmaster start -o -i > dev/null 2>...........

You can't.  Dates will always display in Unix standard format when
being SELECTed raw from the table.

If you want to see something different, you need to use the to_char
function when you select the date column:
http://www.postgresql.org/idocs/index.php?functions-formatting.html

-Josh Berkus