Skip site navigation (1) Skip section navigation (2)

How to filter on timestamps?

From: "B(dot)W(dot)H(dot) van Beest" <bwvb(at)xs4all(dot)nl>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to filter on timestamps?
Date: 2004-07-06 18:37:49
Message-ID: 40eaf12a$0$48959$e4fe514c@news.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-sql

I have a table where one of the columns is of type 'TIMESTAMP'

How can I do a query to filter on the TIMESTAMP value, e.g. to obtain 
all rows earlier than a certain time stamp?

Regards,

Responses

pgsql-sql by date

Next:From: Mike RylanderDate: 2004-07-07 03:28:30
Subject: Re: How to filter on timestamps?
Previous:From: Bruce MomjianDate: 2004-07-06 17:26:17
Subject: Re: Why no exprs in format string to RAISE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group