Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Working on Date

AbhiShahJun 24 2013 — edited Jun 24 2013

Greetings,

{code}

Version-9i

select * from account where add_date>='01-apr-2013'

{code}

In above code 01-apr-2013 is hard coded. I want to code it(e.g. using date functions on sysdate) where date and month remain constant where as Year would be the current year.

Thanks in advane
This post has been answered by Frank Kulash on Jun 24 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2013
Added on Jun 24 2013
1 comment
150 views