SQL*Plus (MOSC)

MOSC Banner

Select month from a date

edited Jun 14, 2017 5:00AM in SQL*Plus (MOSC) 2 commentsAnswered

Dear All,

im trying to get the date from a date :

in toad it worked but when i use it in the report builder it give an error

the function used was

EXTRACT(MONTH FROM   TO_DATE(ppa.date_earned, 'DD-MON-RR')) < '6'

ppa.date_earned is the field that exist in pay_payroll_actions table

could you please advise how to extract the month & use it in report builder

thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center