Received: from mail.sitestar.com (root@mail.sitestar.com [38.228.4.18]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA11716 for ; Tue, 4 Aug 1998 10:09:06 -0400 (EDT) Received: from loopy.sitestar.com (loopy.sitestar.com [38.228.4.19]) by mail.sitestar.com (8.8.5/8.8.6) with SMTP id KAA07721 for ; Tue, 4 Aug 1998 10:06:29 -0400 From: "William McCracken" To: Subject: Query based on date/time field Date: Tue, 4 Aug 1998 10:09:31 -0400 Message-ID: <000601bdbfb1$80503a60$1304e426@loopy.sitestar.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2232.26 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Importance: Normal 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