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


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

Original text of this message