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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Date format


  • From: Dylan Fogarty-MacDonald <dylan(dot)fm(at)gmail(dot)com>
  • To: pgsql-novice(at)postgresql(dot)org
  • Subject: Date format
  • Date: Mon, 31 Jul 2006 15:23:26 +1000
  • Message-id: <44CD93CE.1000403@gmail.com> <text/plain>

Hi,

I have two fields of column type 'date' from which I want to output a formatted date (with PHP).

I understand that MySQL would use DATE_FORMAT and appropriate %M, %D commands. I am having trouble finding the equivalent PostgresQL commands. I am using PG 7.3.4.

I have found the template patterns for the conversions. I want it to be in this format:

Day, DD Month YYYY

I do not know the function to format this so.

if to_date() converts a string to date, what converts/formats date to string?

Thankyou very much.

-Dylan Fogarty-MacDonald
dylan(dot)fm(at)gmail(dot)com



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group