date formatting question - Mailing list pgsql-novice

From richard terry
Subject date formatting question
Date
Msg-id 200807031509.10142.rterry@gnumed.net
Whole thread Raw
Responses Re: date formatting question
List pgsql-novice
Hi,

I'm using gambas to save some data to the database, and use the date from a
textbox to write to the database in format 'dd/mm/yyyy', however when I look
at the database using pgadmin3 , the date is stored as eg 2008/10/02
yyyy/dd/mm.

If I re-display it with  a formatting option like:
Format(referral.date, "dd/mm/yyyy")    then it looks ok in my program

does it matter that is 'round the wrong way' in the database, or is there some
way to tell the database to do it the other way around.

Thanks in anticipation.

richard



pgsql-novice by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Concurrent COPY commands
Next
From: Dmitry Melekhov
Date:
Subject: please explain vacuum with WAL