[sbch]

New to dream in code looking for some assistance with some code
If run a query today looking for items with an enddate of anyday next month

Date_Ended last_day ( to_char ( sysdate) ,+1 'dd/mm/yyyy' ) || '00:00:00', 'dd/mm/yyyy hh24:mi:ss' ) and last_day ( to_char ( add_months/sysdate + 1, 'dd/mm/yyyy' ) || '23:59:59', 'dd/mm/yyyy hh24:mi:ss' )

what am I doing wrong

This post has been edited by sbch: 17 June 2009 - 09:12 PM

[no2pencil]

Hello sbch, & welcome to Dream In Code!

Looking forward to seeing you around the forums, & becoming a part of our community

[CamoDeveloper]

Welcome, I just recently joined too but would love to help you if I can. See you around.

~Camo

[firebolt]

sbch, on 18 Jun, 2009 - 02:09 PM, said:

New to dream in code looking for some assistance with some code
If run a query today looking for items with an enddate of anyday next month

Date_Ended last_day ( to_char ( sysdate) ,+1 'dd/mm/yyyy' ) || '00:00:00', 'dd/mm/yyyy hh24:mi:ss' ) and last_day ( to_char ( add_months/sysdate + 1, 'dd/mm/yyyy' ) || '23:59:59', 'dd/mm/yyyy hh24:mi:ss' )

what am I doing wrong

Hi and welcome to DIC.
Ask your question in a specific language forum. DIC has great members which will gladly help you. Enjoy!

[life.san]

Hello All,


I have just joined DIC. Found it very nice and help full. Will try to provide and get help from the members.

Good Luck..

Sandeep

[jjsaw5]

Welcome to Dream.In.Code


I would like to point you in the direction of our site rules. SITE RULES

Please take the time to read over these rules to see how the forums are run.



When posting a question or a problem, please remember the more information that you provide us with about your issue the better we will be able to help you solve it!

If you have any questions or concerns please do not hesitate to contact myself or another staff memeber, and we will be more then happy to answer any questions you might have.

Thanks for joining Dream.In.Code!

-Justin