date formatting question

Поиск
Список
Период
Сортировка
От richard terry
Тема date formatting question
Дата
Msg-id 200807031509.10142.rterry@gnumed.net
обсуждение исходный текст
Ответы Re: date formatting question
Список 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 по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: Concurrent COPY commands
Следующее
От: Dmitry Melekhov
Дата:
Сообщение: please explain vacuum with WAL