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: | Raw Message | Whole Thread | 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
>
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 |
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) |