Re: Need help with simple sql syntax
From: Heitor Mikami <m-heitor_at_is.aist-nara.ac.jp>
Date: 1996/04/26
Message-ID: <31809901.41C67EA6_at_is.aist-nara.ac.jp>#1/1
Date: 1996/04/26
Message-ID: <31809901.41C67EA6_at_is.aist-nara.ac.jp>#1/1
Markus Ruggiero 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---
>
> --
> e-mail: mruggiero_at_access.ch
I suppose you want somethin like this:
SQL> select * from myTable where timeField < (sysdate - 14);
-- Heitor Mikami (m-heitor_at_is.aist-nara.ac.jp) Nara Institute of Science and Technology - Japan WWW: http://db-www.aist-nara.ac.jp/~m-heitor/Received on Fri Apr 26 1996 - 00:00:00 CEST