Hi there

New to Dream in code

Page 1 of 1

5 Replies - 393 Views - Last Post: 18 June 2009 - 05:03 AM

#1 sbch  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 17-June 09

Hi there

Post icon  Posted 17 June 2009 - 09:09 PM

New to dream in code looking for some assistance with some code :rolleyes:
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


Is This A Good Question/Topic? 0
  • +

Replies To: Hi there

#2 no2pencil  Icon User is offline

  • Toubabo Koomi
  • member icon

Reputation: 5246
  • View blog
  • Posts: 27,062
  • Joined: 10-May 07

Re: Hi there

Posted 17 June 2009 - 09:11 PM

Hello sbch, & welcome to Dream In Code!

Looking forward to seeing you around the forums, & becoming a part of our community :)
Was This Post Helpful? 0
  • +
  • -

#3 CamoDeveloper  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 20
  • View blog
  • Posts: 250
  • Joined: 12-June 09

Re: Hi there

Posted 17 June 2009 - 09:12 PM

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

~Camo
Was This Post Helpful? 0
  • +
  • -

#4 firebolt  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 92
  • View blog
  • Posts: 5,561
  • Joined: 20-February 09

Re: Hi there

Posted 18 June 2009 - 02:11 AM

View Postsbch, on 18 Jun, 2009 - 02:09 PM, said:

New to dream in code looking for some assistance with some code :rolleyes:
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!
Was This Post Helpful? 0
  • +
  • -

#5 life.san  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 18-June 09

Re: Hi there

Posted 18 June 2009 - 03:46 AM

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
Was This Post Helpful? 0
  • +
  • -

#6 jjsaw5  Icon User is offline

  • I must break you
  • member icon

Reputation: 90
  • View blog
  • Posts: 3,060
  • Joined: 04-January 08

Re: Hi there

Posted 18 June 2009 - 05:03 AM

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.

:code:

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
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1