Dates in SQL

Article View: borland.public.vdbase.data.sql

Article #240

Back to borland.public.vdbase.data.sql Previous Next

#240

From: John Staub
Date: Wed, 13 Jan 1999 00:00

23 lines
1238 bytes

I have an SQL statement that I've struggled through that I need to add a
date type function to.  The SQL statement is:
select * from afcert.dbf where (sent = false) and (sealno is not null) and
(crtmld is not null) and (wrtn is not null) and (prac is not null) and
(wrtpass = true) and (pracpass = true)

There is a date field in the table (crtmld is the field) that I would like
to test.  Basically I want to know if (crtmld + 60 < date()) and if so,
include it.  I understand SQL does not support the date() function, but does
anyone know of an equivalent in SQL?  I've tried a variety of approaches to
no avail.

Thanks,

John


--
Staub & Associates, Inc.
(850) 913-8488
http://www.staubassociates.com
Buy your books, etc. online at
http://www.staubassociates.com/bkstore.htm

Technical Details

Message-ID: <77j1h0$sll12@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e21b85d41667a82e,start
X-Google-Attributes: gidff5a1,public
From: "John Staub" <bmds@send_me_nothing_worldnet.att.net>
Subject: Dates in SQL
Date: 1999/01/13
Message-ID: <77j1h0$sll12@forums.borland.com>
X-Deja-AN: 432272861
Organization: Staub & Associates, Inc
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Newsgroups: borland.public.vdbase.data.sql