Skip site navigation (1) Skip section navigation (2)

Re: Date format

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 (view raw or flat)
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




In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2002-04-15 17:44:23
Subject: Re: SQL-Dump and refertial Integrity
Previous:From: Josh BerkusDate: 2002-04-15 15:46:46
Subject: Re: data order problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group