Re: Need help with simple sql syntax

In article <mruggiero-2404960831140001_at_gatezh5-27.access.ch>, Markus Ruggiero <mruggiero_at_access.ch> wrote:
>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---
>

Markus

select * from myTable where timeField < sysdate - 14

Mike

Michael O'Rourke                   INTERNET: mxorour_at_bcbso.com        
BlueCross BlueShield of Oregon     TELEPHONE: 503-273-4602