Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Xenophobe74

    using NVL and date fields

    Thanks Gary and thanks lbass. Both replies were helpful. lbass, I used the second option in your reply and it worked awesome. Thanks again for the help.
  2. Xenophobe74

    using NVL and date fields

    Here is a query I write in SQL*Plus that gives me exactly what I need in a report I am creating: select l.messaging_id,l.name,l2.name,p.pager_id, o.START_DATE, o.END_DATE, o.REMARK, from listing l, listing l2, on_call_assignment o, pager_assignment p where l.MESSAGING_ID =...
  3. Xenophobe74

    XI Current Date Time range

    That's exactly what I needed. Thanks for taking the time to respond so quickly. I try to figure things out on my own before disturbing the masses. I am a Oracle Database guy that has been thrown into creating Crystal Reports and Crystal is a little like learning a new language :( Thanks for...
  4. Xenophobe74

    XI Current Date Time range

    Hey guys, I am a newbie to this site and hope someone can point me in the right direction. I am creating a report that requires the output to report on any changes made to a system for the current date between the times of 8:00 AM and 3:30 PM. I am trying to use a function that will...

Part and Inventory Search

Back
Top