|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Finding records less than three days old |
|
From: |
Steven Turetzky |
|
Date: |
3/24/1999 4:15:19 PM |
|
IP: |
192.63.145.149 |
Don,
...If you are using Oracle, this should work, assuming a field called TIMESTAMP of type DATE that contains the date on which the record was created:
SELECT field1, field2, ...
WHERE SYSDATE - TIMESTAMP < 3
"SYSDATE" is Oracle's representation of the current date/time. Hopefully, this will help you translate the SQL into one appropriate for the DB engine you use.
...Hope this helps.
......Steve |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
