Re: Need help with simple sql syntax

Try select * from myTable where timeField < sysdate - 14;

Worked for me. This assumes that timeField is formatted date.

Mike Strong
Texas Instruments, Inc Houston
Oracle DBA
(713) 274-3317

In article 2404960831140001_at_gatezh5-27.access.ch, mruggiero_at_access.ch (Markus Ruggiero) writes:
> 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.ch
Received on Wed Apr 24 1996 - 00:00:00 CEST