Home » SQL & PL/SQL » SQL & PL/SQL » SEARCHING BETWEEN TWO DATES
SEARCHING BETWEEN TWO DATES [message #703] Wed, 27 February 2002 07:12 Go to next message
Antoni
Messages: 8
Registered: February 2002
Junior Member
HI

IF I HAVE THIS:

TABLE WEEK

COLUMN WEEK_CODE VARCHAR2
COLUMN INI_DATE DATE
COLUMN END_DATE DATE

HOW CAN I KNOW WHICH IS THE WEEK CODE THAT HAS THE SYSDATE BETWEEN THE INI_DATE AND THE END_DATE

SELECT WEEK_CODE FROM WEEK WHERE SYSDATE IS BETWEEN INI_DATE AND END_DATE; ?

THANKS A LOT
Re: SEARCHING BETWEEN TWO DATES [message #704 is a reply to message #703] Wed, 27 February 2002 07:19 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
your query seems fine to me. what is the problem by the way.
Re: SEARCHING BETWEEN TWO DATES [message #706 is a reply to message #703] Wed, 27 February 2002 09:02 Go to previous message
monir
Messages: 22
Registered: February 2002
Junior Member
REMOVE "IS" BEFORE "BETWEEN" MEANS
SELECT WEEK_CODE FROM WEEK WHERE SYSDATE BETWEEN INI_DATE AND END_DATE;
GOOD LUCK
Previous Topic: pls-00306
Next Topic: How to make connections to different dbs from PL/SQL
Goto Forum:
  


Current Time: Thu Mar 28 08:15:08 CDT 2024