Re: Date Format - Mailing list pgsql-novice

From Ben Clewett
Subject Re: Date Format
Date
Msg-id 3E92E1B5.9060201@roadrunner.uk.com
Whole thread Raw
In response to Re: Date Format  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.Clewett@roadrunner.uk.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
>


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date Format
Next
From: Antti Haapala
Date:
Subject: Re: operator '~~' for types 'inet' and '"unknown"'