Postgres Pro
Downloads
Home   >   mailing lists

Timestamps in Views - Mailing list pgsql-general

From Alex
Subject Timestamps in Views
Date
Msg-id 3F978C39.3080907@meerkatsoft.com
Whole thread Raw
Responses Re: Timestamps in Views  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Hi,
I  use a data formatting in views  (to_char(last_update, 'YYYY-MM-DD
HH:MM:SS') as last_update and noticed that the last update returned is
the creation date of the view or not the actual value of the
last_update.(last _update is a timestamp).

What do I need to do to display the actuall value?

Thanks
Alex

pgsql-general by date:

Previous
From: Peter Childs
Date:
Subject: Re: Trigger
Next
From: Mark Kirkwood
Date:
Subject: Re: Recomended FS (correction)