date formatting question

From: richard terry <rterry(at)gnumed(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: date formatting question
Date: 2008-07-03 05:09:10
Message-ID: 200807031509.10142.rterry@gnumed.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dmitry Melekhov 2008-07-03 08:20:46 please explain vacuum with WAL
Previous Message Alan Hodgson 2008-07-02 17:02:48 Re: Concurrent COPY commands