Search Postgresql Archives

Re: Store dates in database in different format

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to RPK <rpk.general@xxxxxxxxx>:
> 
> I am using pgsql 8.2.3 on windows XP. I noticed that dates are store in
> 'Date' columns of a table in "yyyy-mm-dd" format whereas I want to store it
> in "dd-MMM-yyyy" format. Can I change this?

They're not stored in that format, they're just displaying in that format.

Here's a good place to start reading:
http://www.postgresql.org/docs/8.2/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT

-- 
Bill Moran
http://www.potentialtech.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux