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
>