On Tue, Jul 06, 2004 at 01:27:29AM +0200, B.W.H. van Beest wrote:
> 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?
SELECT ... WHERE timestamp_field < 'certain timestamp';
You may need an explicit cast to timestamp in the constant, like
cast('certain timestamp' as timestamp)
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El día que dejes de cambiar dejarás de vivir"
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
