Re: LIKE Clause with dates?

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Tue, 22 Jun 1999 16:11:58 +0100
Message-ID: <376fa577.0@145.227.194.253>

Based on the famous emp table

  1 select hiredate from emp
  2* order by 1
SQL> / HIREDATE

---

17-DEC-80
20-FEB-81
22-FEB-81
02-APR-81
01-MAY-81
09-JUN-81
08-SEP-81
28-SEP-81
17-NOV-81
03-DEC-81
03-DEC-81
23-JAN-82
19-APR-87
23-MAY-87

To get a range, only those items between 01-FEB-1981and 28-FEB-1981....

  1 select hiredate from emp where to_char(hiredate,'MM/DD/YYYY')   2* like '02/'||'%'||'/1981'
SQL> / HIREDATE

---

20-FEB-81
22-FEB-81 HTH Mark

MADEIRA SALLY wrote in message <376FA357.90E46D78_at_home.com>...
>Actually AsofDate is 3/31/99
>so what I need is any date that falls
>in between 3/1/99 and 3/31/99 but
>I do not want the users to enter to
>paramenter values just one
>so it would be LIKE '3/%/99'
>

<snip> Received on Tue Jun 22 1999 - 10:11:58 CDT