ANSI SQL

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • Date arithmetic in Crystal SQL help

    0 answers - 296 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    Does anyone know the appropriate syntax for doing the pl/sql equivilent of: WHERE DATE_V >= SYSDATE - 364/365.
    I am aware of the CurrentDate function and have tried several incarnations of code but none seem to work. Google only returns one semi close reference to what I want to do.

Re: Date arithmetic in Crystal SQL help


max 4000 letters.
Your nickname that display:
In order to stop the spam: 6 + 5 =
QUESTION ON "ANSI SQL"

DATABASE TECH