On 04/03/2007 18:56, Garry Saddington wrote:
>> # select now();
>> now
>> -------------------------------
>> 2007-03-04 18:07:54.626267+01
>> (1 row)
>>
>> Which is precisely what I expect.
> Which is precisely what I get, but I want 04-03-2007.
Ahh! Then you need to use to_char(). The datestyle setting in
postgresql.conf differentiates *only* between European and American date
formats - i.e. the relative order of day and month. It doesn't set the
exact output format.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------