07-03-2013
How to convert R$Timestamp in Sql*Plus within a UNIX Shell Script?
Works like a charm! Thank you very much.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
Did anyone know how to use script (e.g. perl) to conver Unix Timestame to real timestame in GMT+8 ?
1245900787 file:/tmp/a/Test/.txt.swp has created
1245900988 file:/tmp/a/Test/.txt.swp has changed
Thu, 25 Jun 2009 11:33:07 GMT+8 file:/tmp/a/Test/.txt.swp has created
Thu, 25 Jun... (4 Replies)
Discussion started by: happyday
4 Replies
2. Shell Programming and Scripting
Hi All,
I have a string like below.
"Mar 31 2009" .
I want to convert this to unix time .
Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009".
Thanks in advance,... (11 Replies)
Discussion started by: girish.raos
11 Replies
3. AIX
Hello,
How do I convert unix timestamp value to 'normal' date format - to get year month and day values ?
Looks like it's easy to do using GNU date (linux systems). But how do I do tthis on AIX ?
I don't want to write C program, any ways to do that using unix shells ?
thanks (1 Reply)
Discussion started by: vilius
1 Replies
4. AIX
hello,
i have an AIX5.3 machine and i am writing a script to display some processes.
inside the script i want to get the time that the process starts and convert it to a unix timestamp.
is there a command that i can use to do that? i search the web but all i found is long scripts and it does... (4 Replies)
Discussion started by: omonoiatis9
4 Replies
5. Shell Programming and Scripting
Hi All,
I have a query with output below
select 'create synonym "'||TABLE_NAME||'" for '||Table_owner||'."'||table_name||'"'||chr(59) from user_synonyms;
==================
create synonym "RV_SBC_SIG" for WFCONTROLLER_TE."RV_SBC_SIG";
create synonym "AQM_TASK" for AWQM_TE."AQM_TASK";... (2 Replies)
Discussion started by: pvmanikandan
2 Replies
6. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
7. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
8. Shell Programming and Scripting
Hello I have a file : file1.txt with the below contents :
237176 test1 test2 1442149024
237138 test3 test4 1442121300
237171 test5 test7 1442112823
237145 test9 test10 1442109600
In the above file fourth field represents the timestamp in Unix format.
I found a command which converts... (6 Replies)
Discussion started by: rahul2662
6 Replies
9. Shell Programming and Scripting
Hello ,
I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by
EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt
Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies
10. Shell Programming and Scripting
Hello All,
I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following:
date -d $mydate +%s
where mydate = 23/12/2016 00:00:00
I am getting following error:
date: extra operand `+%s'
Try `date --help' for more information.
... (1 Reply)
Discussion started by: angshuman
1 Replies
LEARN ABOUT DEBIAN
net::gpsd3::return::unknown::timestamp
Net::GPSD3::Return::Unknown::Timestamp(3pm) User Contributed Perl Documentation Net::GPSD3::Return::Unknown::Timestamp(3pm)
NAME
Net::GPSD3::Return::Unknown::Timestamp - Net::GPSD3 Return Base Class with Timestamp
SYNOPSIS
package XXX;
use base qw{Net::GPSD3::Return::Unknown::Timestamp};
DESCRIPTION
Provides a time, timestamp and datetime methods to a GPSD3 Return object.
METHODS
time
Seconds since the Unix epoch, UTC. The value may have a fractional part of up to .01sec precision.
Note: In 2.96 (protocol 3.4) the TPV->time format changed from unix epoch to W3C, but this method attempts to hide that change from the
user.
Since the POSIX standard for the Unix epoch does not use leap seconds but GPS system does I do not recommend that you use this method for
time display or storage. This method is purely here for backwards compatibility.
timestamp
W3C formated timestamp value either directly from the protocol >= 3.4 or calculated < 3.4. The value may have a fractional part of up to
.01sec precision.
Note: I expect that in protocol 3.5 the value will be passed directly as TPV->timestamp
datetime
Returns a DateTime object
BUGS
Log on RT and Send to gpsd-dev email list
SUPPORT
DavisNetworks.com supports all Perl applications including this package.
Try gpsd-dev email list
AUTHOR
Michael R. Davis
CPAN ID: MRDVT
STOP, LLC
domain=>michaelrdavis,tld=>com,account=>perl
http://www.stopllc.com/
COPYRIGHT
This program is free software licensed under the...
The BSD License
The full text of the license can be found in the LICENSE file included with this module.
SEE ALSO
Net::GPSD3, Net::GPSD3::Return::Unknown, DateTime::Format::W3CDTF, DateTime
perl v5.14.2 2011-12-27 Net::GPSD3::Return::Unknown::Timestamp(3pm)