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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MrHelpMe

  1. MrHelpMe

    Help with YeartoDate and Last12months

    Thanks.
  2. MrHelpMe

    Help with YeartoDate and Last12months

    Besides thank you 1 million times it works great. It seems like I have much reading to do on the powers of sysdate and trunc. As for using the union I was planning on doing this in case statements. Do you see a problem? Also, since I realized I did not mention it but you did it your prior...
  3. MrHelpMe

    Help with YeartoDate and Last12months

    Below is what you requested SantaMufusa describe hpd_helpdesk; Name Null? Type ---------------------------------------- CASE_ID_ NOT NULL VARCHAR2(15) SUBMITTED_FOR VARCHAR2(30) ARRIVAL_TIME NOT NULL NUMBER(15) ASSIGNEE_LOGIN_NAME...
  4. MrHelpMe

    Need 2 solutions, parameter or no parameter.

    Thanks again LKBrwnDBA. Your help is always appreciated.
  5. MrHelpMe

    Help with YeartoDate and Last12months

    O.k. Still can't believe one line of code to transform epoch into human readable time:) This is what I have been looking for everywhere. Thanks for this. The sad part is that I I tried what you suggested SantaMufasa and still receiving ORA-01830: date format picture ends before converting...
  6. MrHelpMe

    Help with YeartoDate and Last12months

    Hello again, Yes my grammatical errors are all over this forum:) In my original post I was just trying to give you an idea about what I was trying to do and was improperly naming functions and tables. Your are correct in saying that my function name is total different in my most recent post...
  7. MrHelpMe

    Help with YeartoDate and Last12months

    Sorry SantaMufasa, Actually it was a mistype. The table is hpd_helpdesk So it would be For Last 12 Mths select * from hpd_helpdesk where convert_to_epoch(arrival_time) between last_day(add_months(sysdate, -12)) + 1 and sysdate; and For Year to date select * hpd_helpdesk table where...
  8. MrHelpMe

    Help with YeartoDate and Last12months

    Hello experts, Need help figuring out YeartoDate and Last12Months syntax. I'm trying experts, trying my best. YearToDate = is it select * from table where convert_to_epoch(arrival_time) between TRUNC(SYSDATE,'YEAR') and sysdate; Last12Months select * from table where...
  9. MrHelpMe

    Need 2 solutions, parameter or no parameter.

    Sorry again, I am having one of those days. I figured it out. Just remove the parameter and all is good. I should have looked at it before I wrote the email. Anyways, if you have anything for epoch I would definitely be appreciated.
  10. MrHelpMe

    Need 2 solutions, parameter or no parameter.

    Thanks LKBrwnDBA, Wow that is great!!!!! What if I didn't want to add a parameter and just wanted to find out last weeks data without the parameter prompt. Also, I know I am pushing it, but do you know of anything for epoch conversion. The create date in your select needs to be converted...
  11. MrHelpMe

    Need 2 solutions, parameter or no parameter.

    Hello again experts, Has anyone had any luck on this. Please your help is appreciated. Thanks again.
  12. MrHelpMe

    Need 2 solutions, parameter or no parameter.

    Well Anand, I tried to copy and paste the code with no luck. I'm still not sure on the function part. Doesn't the function need to be create and deployed first before it can be used. Sorry excuse my ignorance but just trying to understand what is happening. Thanks again for replying Anand.
  13. MrHelpMe

    Need 2 solutions, parameter or no parameter.

    Oh experts, I am finally on my way with Oracle. I've tossed everything I know about SQL Server and strictly focusing on Oracle. So I need help with the following. I have created a package with a procedure and I need to know how to find all data for the prior week starting from Sunday to...
  14. MrHelpMe

    Oracle package and stored procedure

    Hi LkBrwnDBA You did help me as you lead me in the right direction. I posted a message on the crystal reports forum and synapsvampire helped me. Please refer to thread766-1219880. I switched my connection to use native oracle driver and so far so good. Runs perfectly. So all the experts...
  15. MrHelpMe

    Oracle stored procedure and crystal reports 9.0

    Ah yes, Now I understand Synapsevapire. I'm not sure where my head is today. You are referring to the oracle server(create New Connection) part in crystal reports directly bypassing the ODBC connection. Now I understand. I had to install the drivers from the crystal CD inorder to get this...
See more

Part and Inventory Search

Back
Top