OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » FIND MONTHS (11.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FIND MONTHS [message #671171]

Thu, 16 August 2018 10:25

megha25
Messages: 2
Registered: August 2018

Junior Member

User enters the FROM and TO fields.
FROM: MAY-18
TO: JUL-18

How to retrieve rows in that date range from the below query?

DEFAULT_PERIOD_NAME IS VARCHAR2(15).

select default_period_name from gl.gl_je_batches where
DEFAULT_PERIOD_NAME BETWEEN 'MAY-18' AND 'JUL-18';
I would like to see MAY-18, JUN-18,JUL-18 as the result.

Thanks,
Megha

Report message to a moderator

[Message index]

		FIND MONTHS By: megha25 on Thu, 16 August 2018 10:25
		Re: FIND MONTHS By: BlackSwan on Thu, 16 August 2018 10:30
		Re: FIND MONTHS By: megha25 on Thu, 16 August 2018 10:32
		Re: FIND MONTHS By: Michel Cadot on Thu, 16 August 2018 10:35
		Re: FIND MONTHS By: BlackSwan on Thu, 16 August 2018 10:39
		Re: FIND MONTHS By: Bill B on Thu, 16 August 2018 11:08
		Re: FIND MONTHS By: EdStevens on Fri, 17 August 2018 07:47
		Re: FIND MONTHS By: joy_division on Thu, 16 August 2018 12:47
		Re: FIND MONTHS By: EdStevens on Fri, 17 August 2018 07:48
		Re: FIND MONTHS By: Michel Cadot on Thu, 16 August 2018 10:31
		Re: FIND MONTHS By: EdStevens on Fri, 17 August 2018 07:50
		Re: FIND MONTHS By: Bill B on Fri, 17 August 2018 07:53

Previous Topic:	Teradata To Oracle MOD Function
Next Topic:	SQL to Subtract X workdays from a date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:05:40 CDT 2024