-
(Oracle) Data between 2 dates
Hi,
(ORACLE) I am given a date variable of 'ActivateDate' and I need to create a query in which I only get back data where the 'ActivateDate' is in the previous month from the current sysdate.
For example, if I run the query now I need to get data back in which the 'ActivateDate' is between April 1 12:00:00 AM and April 30 11:59:59 PM. Any suggestions on how to do this as I am not sure of the syntax?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|