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@xxxxxx ---------------------------------------------------------------
