Need help with simple sql syntax
From: Markus Ruggiero <mruggiero_at_access.ch>
Date: 1996/04/24
Message-ID: <mruggiero-2404960831140001_at_gatezh5-27.access.ch>#1/1
Date: 1996/04/24
Message-ID: <mruggiero-2404960831140001_at_gatezh5-27.access.ch>#1/1
Please bear with me, I always thought I know sql - now I have my doubts.
Simple interactive query to access records with a particular VMS date
field beeing at least 14 days in the past. What is the correct syntax?
(Oracle Rdb, former DEC Rdb)
SQL> select * from myTable where timeField < 'today - 14 days'
How do I correctly specify 'today - 14 days'? I get all sorts of error messages.
Thanks for helping
---markus---
-- e-mail: mruggiero_at_access.chReceived on Wed Apr 24 1996 - 00:00:00 CEST