|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
