Re: Date Format

From: Ben Clewett <B(dot)Clewett(at)roadrunner(dot)uk(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Date Format
Date: 2003-04-08 14:50:29
Message-ID: 3E92E1B5.9060201@roadrunner.uk.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

I see...

Found the reference:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functions-formatting.html

to_char(my_timestamp, 'DD/MM/YY')

This looks really exactly what I want, thanks!

Ben

Tom Lane wrote:
> Ben Clewett <B(dot)Clewett(at)roadrunner(dot)uk(dot)com> writes:
>
>>Has any member developed any way of having a more elaborate formats.
>
>
> There's always to_char() ... it's pretty ugly but can format a date
> practically any way you want.
>
> regards, tom lane
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-04-08 14:50:43 Re: How does PG know when a database is being accessed ?
Previous Message Robert Treat 2003-04-08 14:50:22 Re: upgrade

Browse pgsql-novice by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-04-08 15:33:01 Re: Triggers
Previous Message Robert Treat 2003-04-08 14:48:08 Re: [ADMIN] function to determine size of a table (or even row)