Re: Timestamps in Views

From: Richard Huxton <dev(at)archonet(dot)com>
To: Alex <alex(at)meerkatsoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamps in Views
Date: 2003-10-23 14:34:12
Message-ID: 200310231534.12464.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 23 October 2003 09:07, Alex wrote:
> 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).

It doesn't sound likely - could you provide the view definition and a couple
of lines of output?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-10-23 14:39:57 Re: Setting up DSPACE for Postgres access
Previous Message Stephan Szabo 2003-10-23 13:54:13 Re: Trigger