Home > mailing lists

format date retrieved from database - Mailing list pgsql-php

From	Naomi Fullam
Subject	format date retrieved from database
Date	March 23, 2001 18:30:34
Msg-id	200103232030.UAA27942@student.cs.ucc.ie Whole thread Raw
Responses	Re: format date retrieved from database (Michael Fork <mfork@toledolink.com>) Re: format date retrieved from database (Michael Fork <mfork@toledolink.com>)
List	pgsql-php

Tree view

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

pgsql-php by date:

From: "Dan Wilson"
Date: 22 March 2001, 19:05:33
Subject: Re: Converting POSTGRESQL timestamp to UNIX timestamp

From: Michael Fork
Date: 23 March 2001, 18:42:25
Subject: Re: format date retrieved from database

format date retrieved from database - Mailing list pgsql-php

Previous

Next