Query based on date/time field

From: "William McCracken" <will(at)sitestar(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Query based on date/time field
Date: 1998-08-04 14:09:31
Message-ID: 000601bdbfb1$80503a60$1304e426@loopy.sitestar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

I am new to SQL and was wondering how I would go
about selecting records from my database based on
the age of a date/time stamp.

For example if I wanted to select records older than
12 hours or 1 day.

Any help would be appreciated.

Thanks,

Will McCracken

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Maarten Boekhold 1998-08-04 14:28:21 Re: [HACKERS] How do I construct a varlena?
Previous Message Oliver Elphick 1998-08-04 10:07:54 How do I construct a varlena?

Browse pgsql-sql by date

  From Date Subject
Next Message Vadim Mikheev 1998-08-04 14:16:42 Re: [SQL] Which index is better for join operations
Previous Message Chris Williams 1998-08-04 13:44:48 Which index is better for join operations