|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert Unix Time to Standard Time | mrlayance | Shell Programming and Scripting | 7 | 04-23-2009 03:19 PM |
| Convert Epoch Time to Standard Date and Time & Vice Versa | DrivesMeCrazy | Shell Programming and Scripting | 5 | 02-07-2009 01:40 AM |
| Convert milliseconds to standard time | chiru_h | Shell Programming and Scripting | 1 | 07-19-2007 02:45 PM |
| How to Convert scientific notation to normal ? | maheshsri | Shell Programming and Scripting | 2 | 01-05-2006 01:33 PM |
| Convert from standard epoch time from a shell script? | LordJezo | Shell Programming and Scripting | 4 | 09-19-2005 12:48 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-20-2009
|
||||
|
||||
How do you convert scientific time to standard
Hi All, I'm new to this forum, and appreciate any assistance with my issue. I have a shell script that logs into an oracle DB and runs a sqlplus query. Everything works great except for the time I get. I'm new to shell so bare with me. What would be the code and where do I place it? My results are this myjob1 1.1915E+12 I need it to be seen as myjob1 hh:mm:ss: MM/DD/YY Here is my code Code:
#!/usr/bin/sh
sqlplus -S myusername/mypassword@MYDATABASE <<eof> myfile
set heading off feedback off verify off
select JOB.JOBNAME, JOBRUN.ENDTIME from JOB, JOBRUN where JOB.JOBID = JOBRUN.JOBID and JOB.JOBNAME in ('myjob1');
exit
EOF
‘
Thanks for any help |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
