Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group