Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: LIKE Clause with dates?
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'
MADEIRA SALLY wrote:
>
> I have a procedure with paramaters of
>
> Procedure GetParticipations(AsOfDate IN DATE)
>
> The date is usually the last date of the month.
>
> I would like to create a LIKe Clause so that my WHERE
> statement specifies all records WHERE DatePart LIKE
> '3'..%..'99'
>
> The AsOfDate being '3/31/1999'
>
> How would that be accomplished!
>
> Thanks in Advance
> Sally
Received on Tue Jun 22 1999 - 09:49:37 CDT