Re: Selecting timestamp from Database

Поиск
Список
Период
Сортировка
От Richard Harley
Тема Re: Selecting timestamp from Database
Дата
Msg-id 550656EB-8669-420C-8454-485C068EB8EF@scholarpack.com
обсуждение исходный текст
Ответ на Re: Selecting timestamp from Database  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Selecting timestamp from Database
Список pgsql-general
Дерево обсуждения
It's

    Column    |            Type             |                             Modifiers                             
--------------+-----------------------------+-------------------------------------------------------------------
 attendanceid | integer                     | not null default nextval('attendance_attendanceid_seq'::regclass)
 entered      | date                        | not null default ('now'::text)::date
 timeperiod   | character(2)                | 
 timestamp    | timestamp without time zone | default now()





On 8 Apr 2013, at 14:48, Adrian Klaver <adrian.klaver@gmail.com> wrote:

On 04/08/2013 06:45 AM, Richard Harley wrote:
I am running the query straight through PSQL so there are no other programs or adapters.

The field definition is just 'timestamp'.

From psql what do you get if you do?:

\d attendance


I did try that as well - no luck :)

Rich

--
Adrian Klaver
adrian.klaver@gmail.com

В списке pgsql-general по дате отправления: