04-21-2010
D=`perl -le "print scalar localtime (time() - "50"*60);"`
echo $D
D1=`perl -le "@x=localtime (time() - "50"*60); printf(\"%4d%02d%02d%02d%02d%02d\n\", \$x[5]+1900,\$x[4]+1,\$x[3],\$x[2],\$x[1],\$x[0])"`
echo $D1
and output
Wed Apr 21 17:54:25 2010
107382063610738185091074160772107416091610741609521074160988
$D is ok
except $D1
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi gurus!
i realize that my question shows my stupidness, but i need your help!
i have:
s_date=`date +%m-%d-%Y_%I%p`
variable and i need the same, but minus one hour..
what i made:
s_date=time(`date +%m-%d-%Y_%I%p`) - 3600
but i'm getting:
daily_exports.sh: line 20: syntax error near... (4 Replies)
Discussion started by: MarGur
4 Replies
2. Shell Programming and Scripting
hi i have file 1 as follows:
6
7
8
9
10
i have file 2 as follows:
5
5
5
5
5
i want file 3 as follows: (4 Replies)
Discussion started by: npatwardhan
4 Replies
3. Shell Programming and Scripting
hi,
i set up a script on my server to do a particular task once files from an external system are ftpd in the format compaq_20100110 (YYDDMM). Interestingly, the source of ftp is sending the files in the format e.g 20100109 i.e. previous date and for some reason this fails.kindly see my script... (2 Replies)
Discussion started by: bigtejus
2 Replies
4. Shell Programming and Scripting
Hallo all i am trying to execute this script ...............
But this is throwing the error......
use of uninitialized value in subtraction in at icd_convert.pl line 156
use of uninitialized value in subtraction in at icd_convert.pl line 157
use of uninitialized value in subtraction in at... (1 Reply)
Discussion started by: suvenduperl
1 Replies
5. Shell Programming and Scripting
HI gurus...
I have a PERL file that help me extract the date and time
of the file.
The format of this is: yyyymmddhhmmss.
Example:
20100430070935 (April 30 2010 07:09:35)
How can i subtract the acquired time from system's time..??
The answer... (6 Replies)
Discussion started by: bankimmehta
6 Replies
6. Shell Programming and Scripting
How can i print the output of a perl script on a unix console and redirect the same in a log file under same directory simultaneously ?
Like in Shell script, we use tee, is there anything in Perl or any other option ? (2 Replies)
Discussion started by: butterfly20
2 Replies
7. Shell Programming and Scripting
Hi,
I have having a great confusion in under standing the below terms.
a) "wall time" (time according the the clock on the wall vs. cpu time spent executing it)
what exactly it means?
For example:
wall time cpu time line:text
4.22404 24.186 if(some junk condition)
... (1 Reply)
Discussion started by: vanitham
1 Replies
8. Shell Programming and Scripting
Hi
#!/bin/sh
month=`date +%m`
year=`date +%Y`
echo $month
a=02
# Retaining Data for Current and Previous Month
lmonth=`expr $month - $a`
if test "$lmonth" = "0"
then
lmonth=12
year=`expr $year - 1`
fi
echo $year
echo $lmonth
The output is (3 Replies)
Discussion started by: Abhayman
3 Replies
9. Shell Programming and Scripting
Hello all .
I have two arrays.
${ARRAY_MOUNT_POINT_CAPACITY}
${ARRAY_MOUNT_POINT_CAPACITY}.
Whats the synatx of subtracting their values , placing them in variable V1 and then echoeing it ???
Ive tried expr and let ...gives me ./test_code.sh: difference: bad number (3 Replies)
Discussion started by: Junaid Subhani
3 Replies
10. Shell Programming and Scripting
I have dates as follows in a file
20121029135649
20121029135721
20121030091540
20121030093420
20121030094340
20121030095427
20121030095856
20121030100104
20121030100251
All these dates are in sorted order. I need to find out the difference between the dates as follows
2nd row... (6 Replies)
Discussion started by: meetsriharsha
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)