Re: Date Formatting

From: hodges(at)xprt(dot)net
To: tansley(at)law(dot)du(dot)edu, pgsql-novice(at)postgresql(dot)org
Subject: Re: Date Formatting
Date: 2002-05-05 22:34:03
Message-ID: 3CD550EB.14544.1554EEB@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

This may give you what you need:

date("M d Y H:i:s",$timestamp)

On another note, is there a builtin command to change
time display from 19:00 to 7:00 pm?

Tom Hodges

On 3 May 2002 at 13:31, Tom Ansley wrote:

> I am writing timestamps to file and the formatting is currently 2002-06-06
> 00:00:00.0. Is there a function to only write the date and also to format it
> something like MM/dd/yyyy ?
>
> Thanks
>
> Tom
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Masaru Sugawara 2002-05-06 04:11:30 Re: Transaction Question
Previous Message Aarni Ruuhimäki / Megative Tmi / KYMI.com 2002-05-05 14:52:54 Re: