From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | "cristi" <cristi(at)dmhi(dot)ct(dot)ro>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Date format |
Date: | 2002-04-15 15:51:43 |
Message-ID: | web-1370653@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-15 17:44:23 | Re: SQL-Dump and refertial Integrity |
Previous Message | Josh Berkus | 2002-04-15 15:46:46 | Re: data order problem |