Re: Need help with simple sql syntax

In article <4m05ir$p0q_at_newsbf02.news.aol.com>, sspiars_at_aol.com says...
>
>
>SQL> select * from myTable where timeField < 'today - 14 day
>s'
>
>How do I correctly specify 'today - 14 days'? I get all sort
>s of error
>messages.
>
>Thanks for helping
>
>---markus---
>
>--
>e-mail: mruggiero_at_access.ch
>
>I believe it is something like this: (sysdate -14 days).

I think you can try sysdate -14
kcyeung_at_mmm.com.hk Received on Mon Apr 29 1996 - 00:00:00 CEST