Timestamps in Views

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamps in Views
Date: 2003-10-23 08:07:21
Message-ID: 3F978C39.3080907@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Kirkwood 2003-10-23 08:09:51 Re: Recomended FS (correction)
Previous Message Peter Childs 2003-10-23 07:16:27 Re: Trigger