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 Chriss Miller 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 jdobyns

  1. jdobyns

    sysdate usage in where clause

    Here is the code that will not go back past 8:50 am select tag_ref_no, in_out, to_char(c_dt,'mm/dd/yyyy hh:mi:ss'), transaction_no from api_Scale where c_dt between trunc(sysdate) +(6/24) -1 and (trunc(sysdate) +(6/24))
  2. jdobyns

    sysdate usage in where clause

    I get the same results you do.
  3. jdobyns

    sysdate usage in where clause

    Here is the output from select tag_ref_no, to_char(c_dt,'MM/DD/YYYY, hh:mm:ss') from api_Scale where c_dt >= sysdate -2 http://www.box.net/shared/ybzcevpltv
  4. jdobyns

    sysdate usage in where clause

    The server only serves information in EST since it was built, we do not have any offices that require any other Time Zones. I hope I am answering your question. I am curious because I can go forward but not backwards. If I put in any value 1/24,2/24,3/24 etc, I always get 8:50, if I go...
  5. jdobyns

    sysdate usage in where clause

    select tag_ref_no, in_out, to_char(c_dt,'mm/dd/yyyy hh:mi:ss'), transaction_no from api_Scale where c_dt between trunc(sysdate) +(6/24) -1 and (trunc(sysdate) +(6/24))
  6. jdobyns

    sysdate usage in where clause

    SQL> select to_char(trunc(sysdate) +(6/24) -1,'yyyy-mm-dd hh24:mi:ss') Yesterday_Morning 2 ,to_char(trunc(sysdate) +(6/24),'yyyy-mm-dd hh24:mi:ss') This_Morning 3 from dual; YESTERDAY_MORNING THIS_MORNING ------------------- ------------------- 2009-02-19 06:00:00 2009-02-20...
  7. jdobyns

    sysdate usage in where clause

    I can not figure out how to edit the above post, I apologize. I made the following changes: select tag_ref_no, in_out, to_char(c_dt,'mm/dd/yyyy hh24:mi'), transaction_no from api_Scale where c_dt between trunc(sysdate) +(6/24) -1 and (trunc(sysdate) +(6/24)) and I got all the records from...
  8. jdobyns

    sysdate usage in where clause

    Thank you so much for the quick answer! The only problem I have now is the query does not return any rows. I checked the table and there is date in there from 6am this morning to 6am yesterday morning. Is there something else I am not doing correctly?
  9. jdobyns

    sysdate usage in where clause

    I want to be able to run a query everyday beginning at 6am this morning to 6am yesterday morning. The query will always be run after 6am manually via Excel. We are running a 9i Oracle database. I have been unable to get the syntax correct. Here is a description of the table. Name Null? Type...
  10. jdobyns

    Internet access is intermittent

    Sorry I meant reboot of the workstations. Thanks for all your help so far by the way.
  11. jdobyns

    Internet access is intermittent

    As far as I can tell, it fixes itself. I beleive a reboot will also cure it but I am never there exactly when the problem is happening and I have to rely on office staff.
  12. jdobyns

    Internet access is intermittent

    Local resources are ok, just going out to the internet, ie. HTTP, POP3, IMAP, etc.
  13. jdobyns

    PIX Configuration problems

    Could you provide your config, I am thinking it has to do with your NAT transversal. I had this same problem about a year ago.
  14. jdobyns

    Internet access is intermittent

    Here is my problem. I have a 506e PIX I manage for a customer. Sometimes in the morning the internal network will not go out to the internet for email, http, etc. However at the same time there is a VPN tunnel that comes in from the internet that does not have a problem connecting. I can...
  15. jdobyns

    ASA Does nothing but internet and point to point

    No sir! I am using windows ping and Putty ssh client. There are no DENYS or errors in the syslog.
See more

Part and Inventory Search

Back
Top