Recent content by jdobyns

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))

I get the same results you do.

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

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...

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))

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...

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...

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?

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...

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

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.

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

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.

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...

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