format date retrieved from database

From: Naomi Fullam <fullam(at)student(dot)cs(dot)ucc(dot)ie>
To: pgsql-php(at)postgresql(dot)org
Subject: format date retrieved from database
Date: 2001-03-23 20:30:27
Message-ID: 200103232030.UAA27942@student.cs.ucc.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Hi
I found this function for mysql

SELECT DATE_FORMAT(myDateField, '%d-%m-%Y') FROM myTable

The DATE_FORMAT function allows one to format myDateField as I see fit,
I want to have it in date-month-year format. myDateField is of type
date.

Basically I was just wondering if there is a similar Postgres command?

Thanks in advance!

Naomi

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Michael Fork 2001-03-23 20:42:05 Re: format date retrieved from database
Previous Message Vince Vielhaber 2001-03-22 20:22:42 Re: Refreshing php page every 5 secs WHILE SAVING INFORMATION