In response to RPK <rpk.general@xxxxxxxxx>: > > I am using pgsql 8.2.3 on windows XP. I noticed that dates are store in > 'Date' columns of a table in "yyyy-mm-dd" format whereas I want to store it > in "dd-MMM-yyyy" format. Can I change this? They're not stored in that format, they're just displaying in that format. Here's a good place to start reading: http://www.postgresql.org/docs/8.2/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT -- Bill Moran http://www.potentialtech.com