Sponsored Content
Full Discussion: how to get number of seconds
Top Forums UNIX for Advanced & Expert Users how to get number of seconds Post 44241 by captainzeb on Tuesday 2nd of December 2003 05:12:34 PM
Old 12-02-2003
Thanks to all for the perl help. I don't have perl on my servers so found a program on the net, compiled it and did this:

#setup the datetime variables to get last night at 23:59:59
cc=`date +"%C"`
yy=`date +"%y"`
mm=`date +"%m"`
dd=`date +"%d"`
hh=23
mi=59
ss=59

#assign the parameters to the variable
newtime="$mm $dd $cc$yy $hh $mi $ss"

#get the number of seconds since 1970 for tonight at 23:59:59
newseconds=`./seconds $newtime`

#get last night's seconds at midnight by subtracting one day from #midnight
let midnight=$newseconds-86400

#append the delete statement, with the system time, to the sql #script
echo "delete from oas_pvt_empty_order_data where expiration_date < $midnight;">> delete_contracts.sql
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get lines in 5 seconds

Hello everybody, how i can get how many lines are writed in a file in the last 5 seconds? For ezample i have 'file1' that is filled by a process automatically and i neet to know how many lines with the word 'EXACTO' were filled the last 5 seconds, can somebody help me? I try with: tail -f... (16 Replies)
Discussion started by: Lestat
16 Replies

2. UNIX for Dummies Questions & Answers

seconds to hh:mm:ss

Any sleek way to convert seconds to hh:mm:ss format . I know it can be done by mod and divide . Looking for a one liner if possible . Example 3600 seconds = 01:00:00 3601 seconds = 01:00:01 (2 Replies)
Discussion started by: akrathi
2 Replies

3. HP-UX

Ticks in seconds.

Hello all, Is there any thumb rule or aproximation of the equivalence in second of one tick? Thank you in advance. (1 Reply)
Discussion started by: mig28mx
1 Replies

4. Shell Programming and Scripting

Convert Seconds to hh:mm:ss

Hi All I need to convert a number of fields in a record from seconds to hh:mm:ss ( or possibly hhh:mm:ss ). I'm guessing awk is the way to go . File has multiple records and each record contains 101 fields - can awk handle that ? The seconds values will be in fields 3 - 101 and could be 0. ... (4 Replies)
Discussion started by: Mudshark
4 Replies

5. UNIX for Dummies Questions & Answers

Number of leap seconds

Is there a function call in std library or unit command that returns the number of current leap seconds? GG (4 Replies)
Discussion started by: NAVTime
4 Replies

6. UNIX for Dummies Questions & Answers

Sorting and wc -l w.r.t seconds

I have file with below data 00:00:00 00:00:00 00:00:00 00:00:01 00:00:01 00:00:01 00:00:01 00:00:01 00:02:01 00:02:01 00:02:01 so on till 23:59:59 I want count of seconds for each hour and minutes say for 00:00:00 its 3 and 00:00:01 its 5 and 00:02:01 its 3 and so on... (8 Replies)
Discussion started by: mirwasim
8 Replies

7. Shell Programming and Scripting

Compare fraction number and convert duration to seconds

Hi friends, I have a file with contents below: 01.m4a 00:14:45.82, 01.mp4 00:03:46.05, -659.770000 05.m4a 00:27:43.51, 05.mp4 00:27:45.10, 1.590000 06.m4a 00:11:39.73, 06.mp4 00:11:44.60, 4.870000 If 5th column value more than 3 or less than -3 then I should get its name (from first... (2 Replies)
Discussion started by: magnus29
2 Replies

8. Shell Programming and Scripting

Time in seconds on AIX 4.3.2.0

Hi to everybody again i Need your help, i wasting hours but can't find a solutuin for my Problem. I am not an expert with AIX script programming. I have a csh script and i need the time in seconds but since i have an old AIX the Option -%s doesnot exist with the date command. I seach in Google... (13 Replies)
Discussion started by: Nadielosabra
13 Replies

9. Shell Programming and Scripting

Converting seconds to minutes

Hello everyone, I calculate in my bash script the different between two timestamps in seconds. The next step would be to get the difference in minutes, and there is my Problem:AnzahlUeberstunden=$(( $(date -d "$JAHR-$MONAT-$TAG $ArbeitEnde" +%s) - $(date -d "$JAHR-$MONAT-$TAG... (6 Replies)
Discussion started by: Chaos_Lord
6 Replies
AUVIRT(8)						  System Administration Utilities						 AUVIRT(8)

NAME
auvirt - a program that shows data related to virtual machines SYNOPSIS
auvirt [ OPTIONS ] DESCRIPTION
auvirt shows a list of guest sessions found in the audit logs. If a guest is specified, only the events related to that guest is consid- ered. To specify a guest, both UUID or VM name can be given. For each guest session the tool prints a record with the domain name, the user that started the guest, the time when the guest was started and the time when the guest was stoped. If the option "--all-events" is given a more detailed output is shown. In this mode other records are shown for guest's stops, resource assignments, host shutdowns and AVC and anomaly events. The first field indicates the event type and can have the following values: start, stop, res, avc, anom and down (for host shutdowns). Resource assignments have the additional fields: resource type, reason and resource. And AVC records have the following additional fields: operation, result, command and target. By default, auvirt reads records from the system audit log file. But --stdin and --file options can be specified to change this behavior. OPTIONS
--all-events Show records for all virtualization related events. --debug Print debug messages to standard output. -f, --file file Read records from the given file instead from the system audit log file. -h, --help Print help message and exit. --proof Add after each event a line containing all the identifiers of the audit records used to calculate the event. Each identifier con- sists of unix time, milliseconds and serial number. --show-uuid Add the guest's UUID to each record. --stdin Read records from the standard input instead from the system audit log file. This option cannot be specified with --file. --summary Print a summary with information about the events found. The summary contains the considered range of time, the number of guest starts and stops, the number of resource assignments, the number of AVC and anomaly events, the number of host shutdowns and the number of failed operations. -te, --end [end-date] [end-time] Search for events with time stamps equal to or before the given end time. The format of end time depends on your locale. If the date is omitted, today is assumed. If the time is omitted, now is assumed. Use 24 hour clock time rather than AM or PM to specify time. An example date using the en_US.utf8 locale is 09/03/2009. An example of time is 18:00:00. The date format accepted is influenced by the LC_TIME environmental variable. You may also use the word: now, recent, today, yesterday, this-week, week-ago, this-month, this-year. Today means starting now. Recent is 10 minutes ago. Yesterday is 1 second after midnight the previous day. This-week means starting 1 second after midnight on day 0 of the week determined by your locale (see localtime). This-month means 1 second after midnight on day 1 of the month. This-year means the 1 second after midnight on the first day of the first month. -ts, --start [start-date] [start-time] Search for events with time stamps equal to or after the given end time. The format of end time depends on your locale. If the date is omitted, today is assumed. If the time is omitted, midnight is assumed. Use 24 hour clock time rather than AM or PM to specify time. An example date using the en_US.utf8 locale is 09/03/2009. An example of time is 18:00:00. The date format accepted is influ- enced by the LC_TIME environmental variable. You may also use the word: now, recent, today, yesterday, this-week, this-month, this-year. Today means starting at 1 second after midnight. Recent is 10 minutes ago. Yesterday is 1 second after midnight the previous day. This-week means starting 1 second after midnight on day 0 of the week determined by your locale (see localtime). This-month means 1 second after midnight on day 1 of the month. This-year means the 1 second after midnight on the first day of the first month. -u, --uuid UUID Only show events related to the guest with the given UUID. -v, --vm name Only show events related to the guest with the given name. EXAMPLES
To see all the records in this month for a guest auvirt --start this-month --vm GuestVmName --all-events SEE ALSO
aulast(8), ausearch(8), aureport(8). AUTHOR
Marcelo Cerri IBM Corp Dec 2011 AUVIRT(8)
All times are GMT -4. The time now is 06:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy