Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CG_dude
Starting Member
3 Posts |
 Posted - 2009-08-27 : 20:50:02
|
| Hi, I'll try to be short on my question. I'm am new to Oracle. My company use a sybase database that runs business jobs. Currently we run SQL queries from Perl to gather time information on the jobs. Now we have an application that is using Oracle. The server it is on, doesn't have perl, so I am using a shell script to login to sqlplus and run a query for a job and it's end time. I have accomplished this. However, here is the 2 problems I am having.1. The query reults are returned in Scientific time, I'm able to convert that to EPOCH time in the SQL syntax, however, it comes back with a 13 digit time, instead of 10. The last 3 digits are zero. How can you remove the last 3 digits in the query or convert the 13 digits to Human Time. Right now when you see the select statement, I am doing a to_char to get it to EPOCH time.2. How to only show the latest time in the query and not show ALL job end times from it's past runs. Here is my shell script, and I do realize this maybe a select statement syntax solution to one or both, but the UNIX time stamp is puzzling.#!/usr/bin/shsqlplus -S username/password@JAWSPROD <<eof> myfileset heading off feedback off verify offselect JAWS_APP.JAWSJOB.JOBNAME, to_char(JAWS_APP.JOBRUN.ENDTIME) from JAWS_APP.JAWSJOB, JAWS_APP.JOBRUN where JAWS_APP.JAWSJOB.JOBID = JAWS_APP.JOBRUN.JOBID and JAWS_APP.JAWSJOB.JOBNAME in ('pa_box_settle');exitEOF‘Thanks for any help or guidence. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-08-27 : 20:53:20
|
| SQL Team is a Microsoft SQL Server site, and we sometimes handle .Net questions. We really don't handle Oracle or Perl (or Unix). You'll be able to get a better answer here (for the Oracle stuff anyway):http://dbforums.com/ |
 |
|
|
|
|
|
|
|
SQLPLUS query in Oracle / Converting time