02-20-2008
diff in date/time ?
the o/p is :
Start Time:
2008-02-19 00:13:16,338
End Time:
2008-02-19 23:43:17,974
How to find the diff in time..........?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
What kind of command can i use to search a directory and subdirectories for all files that do not have the same date? i want to find any files that do not match a date of Sep 13, 2002? Or that have a different owner or group?
Any help appreciated! (2 Replies)
Discussion started by: kymberm
2 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
Can somebody please help me with this.
The date format is in MM/DD/YY HH24:MI:SS
suppose I have a start_date=09/03/02 04:15:02
& Finish date= 09/04/02 07:13:51
I want to find out the difference between the two ie finish_time-start time.
How can I do this.
Morever I want the... (2 Replies)
Discussion started by: rooh
2 Replies
3. UNIX for Advanced & Expert Users
Hi All,
What is the difference b/w last modification time and last updated time.
Thanks
Sweta (1 Reply)
Discussion started by: sweta
1 Replies
4. Shell Programming and Scripting
Input file:
Tue Oct 21 12:56:35 2008 Started
Tue Oct 21 12:56:39 2008 Completed
Tue Oct 21 12:57:25 2008 Started
Tue Oct 21 12:57:32 2008 Completed
Tue Oct 21 12:58:12 2008 Started
Tue Oct 21 12:58:50 2008 Completed
Output required:
Tue Oct 21 12:56:35 2008 Started
Tue Oct 21... (2 Replies)
Discussion started by: uwork72
2 Replies
5. Shell Programming and Scripting
Hello,
i have a variable where the present date is going to save.
and i have another variable where the another date which will of higher value is going to save.
I need to find the difference with respect to date,month and year.
What the need is to send an e-mail if the difference in... (2 Replies)
Discussion started by: nagendramv
2 Replies
6. Linux
Hi,
One script is giving the date which is not contstant. and the need is to compare it with the current one and find the diff. if it is less than 15 days , need to send an e-mail.
Date format coming from the script is October 24, 2055
Thanks (1 Reply)
Discussion started by: nagendramv
1 Replies
7. Shell Programming and Scripting
Hi all ,
i am trying to calculate time difference btw the script execution
I am using solaris
start_time=`date +%s`
sleep 2
end_time=`date +%s`
duration=`expr $end_time - $start_time`
when i try to subtract i get the error
line 13: %s - -time : syntax error: operand expected... (3 Replies)
Discussion started by: posner
3 Replies
8. Shell Programming and Scripting
hi all
kindly i want to subtract to time stamps
like:
t1=08:35:20
t2=08:36:58
diff=00:01:38 <<<<
or
diff=01:38 <<<<
using bash
thanks alot (9 Replies)
Discussion started by: teefa
9 Replies
9. Shell Programming and Scripting
Dear All
I want to diff between two time(FIRST 4 COLUMN) in hours in last column. Kindly help me for same.
2013-11-23 15:51:23 2013-11-23 12:20:06 BRC023 CG
2013-11-23 15:51:23 2013-11-23 12:20:08 BRC064CG
2013-11-23 15:51:23 2013-11-22 13:17:49 BLM003 NG
2013-11-23 15:51:23 2013-11-22... (9 Replies)
Discussion started by: jaydeep_sadaria
9 Replies
10. Shell Programming and Scripting
Hi All,
I have one file which contains time for request and response.
I want to calculate time difference in milliseconds for each line.
This file can contain 10K lines.
Sample file with 4 lines.
for first line.
Request Time: 15:23:45,255
Response Time: 15:23:45,258
Time diff... (6 Replies)
Discussion started by: Raza Ali
6 Replies
LEARN ABOUT DEBIAN
time::piece::mysql
Time::Piece::MySQL(3pm) User Contributed Perl Documentation Time::Piece::MySQL(3pm)
NAME
Time::Piece::MySQL - Adds MySQL-specific methods to Time::Piece
SYNOPSIS
use Time::Piece::MySQL;
my $time = localtime;
print $time->mysql_datetime;
print $time->mysql_date;
print $time->mysql_time;
my $time = Time::Piece->from_mysql_datetime( $mysql_datetime );
my $time = Time::Piece->from_mysql_date( $mysql_date );
my $time = Time::Piece->from_mysql_timestamp( $mysql_timestamp );
DESCRIPTION
Using this module instead of, or in addition to, "Time::Piece" adds a few MySQL-specific date-time methods to "Time::Piece" objects.
OBJECT METHODS
mysql_date / mysql_time / mysql_datetime / mysql_timestamp
Returns the date and/or time in a format suitable for use by MySQL.
CONSTRUCTORS
from_mysql_date / from_mysql_datetime / from_mysql_timestamp
Given a date, datetime, or timestamp value as returned from MySQL, these constructors return a new Time::Piece object. If the value is
NULL, they will retrun undef.
CAVEAT
"Time::Piece" itself only works with times in the Unix epoch, this module has the same limitation. However, MySQL itself handles date and
datetime columns from '1000-01-01' to '9999-12-31'. Feeding in times outside of the Unix epoch to any of the constructors has
unpredictable results.
Also, MySQL doesn't validate dates (because your application should); it only checks that dates are in the right format. So, your database
might include dates like 2004-00-00 or 2001-02-31. Passing invalid dates to any of the constructors is a bad idea: on my system the former
type (with zeros) returns undef (previous version used to die) while the latter returns a date in the following month.
AUTHOR
Original author: Dave Rolsky <autarch@urth.org>
Current maintainer: Marty Pauley <marty+perl@kasei.com>
COPYRIGHT
(c) 2002 Dave Rolsky
(c) 2004 Marty Pauley
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Time::Piece
perl v5.12.4 2008-06-07 Time::Piece::MySQL(3pm)