Hello All,
I was having a look on threads on the Forum about time calculation but didn't find exactly this issue.
For instance, if we have these 2 dates, begin & end :
20100430235830
20100501000200
Is there anyway, awk, ksh, perl to calculate the difference in sec and get for... (6 Replies)
Hello All,
I have a problem calculating the time difference between start and end timings...!
the timings are given by 24hr format..
Start Date : 08/05/10 12:55
End Date : 08/09/10 06:50
above values are in mm/dd/yy hh:mm format.
Now the thing is, 7th(08/07/10) and... (16 Replies)
Hi,
Below is the backup file name (includes date & time) :
exp_trx_tables_18_Oct_2010_10_59_00.dmp
Extracted date and time from the file name as below using the below "awk"command:
date 18-Oct-2010 and time 10:59:00
echo "$fname" | awk -F"_" '{printf "Records will be restored as on... (1 Reply)
I have start and finish date in the following format -
Start Date: 5/21/2010 9:14:00 AM
End Date : 5/24/2010 7:23:00 AM
I need to get the time difference in the following format :mm or . Any help would be really appreciated.
Thank you! (3 Replies)
Hi,
I am trying to use the script as under :
echo "Please input the string (APC) in the format (APC=x-yyy-z):"
read a
for i in m1 m2 m4 m5 m6
do
cat /m12/$i/12* | grep -B 1 -A 1 inaccessible | gawk '/'$a'/{print $6,$7,$8,x};{x=$3" "$4}' | awk NF > temp
cat /m122/$i/12* | grep -B 1 -A 1... (0 Replies)
================================================================================
Request ID GMDCOM TIME GMDRRS TIME COM-RRS
================================================================================
<36812974> Tue Oct 1 13:32:40 2013 Tue Oct 1 20:36:42 2013... (1 Reply)
Request ID GMDCOMTM GMDRRSTIME GMDRESTIME
<36812986> : : :I want to display the date -time difference in other fields. Above I have given for only 1 record. I want to calculate for all the records.
(GMCOMTM - GMDRRSTM) ,(GMDRRSTM-GMDRESTM) and... (5 Replies)
There are 2 dates,
Tue Oct 1 13:40:19 2013
Sun Sept 30 10:26:23 2013
I have multiple dates like the above one. How do I calculate the date time difference and display in another column in Shell script. Please help. (3 Replies)
Hi Everyone,
We are having an issue with date and date -u in our AIX Systems.
We have checked environment variable TZ and /etc/environment and however, we could not rectify the difference.
>date
Thu Mar 19 22:31:40 IST 2015
>date -u
Thu Mar 19 17:01:44 GMT 2015
Any clue... (5 Replies)
Hello,
In HP-UX how to find the date time difference ?
Start time: 28-APR-2019 21:36:01
End time : 29-APR-2019 00:36:04
----------------------
Difference is
----------------------
Much appreciate any pointer or view on this.
... (3 Replies)
Discussion started by: Siva SQL
3 Replies
LEARN ABOUT PHP
getdate
GETDATE(3) 1 GETDATE(3)getdate - Get date/time information
SYNOPSIS
array getdate ([int $timestamp = time()])
DESCRIPTION
Returns an associative array containing the date information of the $timestamp, or the current local time if no $timestamp is given.
PARAMETERS
o $timestamp
- The optional $timestamp parameter is an integer Unix timestamp that defaults to the current local time if a $timestamp is not
given. In other words, it defaults to the value of time(3).
RETURN VALUES
Returns an associative array of information related to the $timestamp. Elements from the returned associative array are as follows:
Key elements of the returned associative array
+----------+--------------------------------------+---+
| Key | | |
| | | |
| | Description | |
| | | |
| | Example returned values | |
| | | |
+----------+--------------------------------------+---+
| | | |
|"seconds" | | |
| | | |
| | Numeric representation of seconds | |
| | | |
| | | |
| | 0 to 59 | |
| | | |
| | | |
|"minutes" | | |
| | | |
| | Numeric representation of minutes | |
| | | |
| | | |
| | 0 to 59 | |
| | | |
| | | |
| "hours" | | |
| | | |
| | Numeric representation of hours | |
| | | |
| | | |
| | 0 to 23 | |
| | | |
| | | |
| "mday" | | |
| | | |
| | Numeric representation of the day of | |
| | the month | |
| | | |
| | | |
| | 1 to 31 | |
| | | |
| | | |
| "wday" | | |
| | | |
| | Numeric representation of the day of | |
| | the week | |
| | | |
| | | |
| | 0 (for Sunday) through 6 (for Satur- | |
| | day) | |
| | | |
| | | |
| "mon" | | |
| | | |
| | Numeric representation of a month | |
| | | |
| | | |
| | 1 through 12 | |
| | | |
| | | |
| "year" | | |
| | | |
| | A full numeric representation of a | |
| | year, 4 digits | |
| | | |
| | Examples: 1999 or 2003 | |
| | | |
| | | |
| "yday" | | |
| | | |
| | Numeric representation of the day of | |
| | the year | |
| | | |
| | | |
| | 0 through 365 | |
| | | |
| | | |
|"weekday" | | |
| | | |
| | A full textual representation of the | |
| | day of the week | |
| | | |
| | | |
| | Sunday through Saturday | |
| | | |
| | | |
| "month" | | |
| | | |
| | A full textual representation of a | |
| | month, such as January or March | |
| | | |
| | | |
| | January through December | |
| | | |
| | | |
| 0 | | |
| | | |
| | Seconds since the Unix Epoch, simi- | |
| | lar to the values returned by | |
| | time(3) and used by date(3). | |
| | | |
| | System Dependent, typically | |
| | -2147483648 through 2147483647. | |
| | | |
+----------+--------------------------------------+---+
EXAMPLES
Example #1
getdate(3) example
<?php
$today = getdate();
print_r($today);
?>
The above example will output something similar to:
Array
(
[seconds] => 40
[minutes] => 58
[hours] => 21
[mday] => 17
[wday] => 2
[mon] => 6
[year] => 2003
[yday] => 167
[weekday] => Tuesday
[month] => June
[0] => 1055901520
)
SEE ALSO date(3), idate(3), localtime(3), time(3), setlocale(3).
PHP Documentation Group GETDATE(3)