I've seen a lot of posts on this and have tried the following:
But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY.
I am using bash and don't know much about perl. I can convert the current date, but nothing from the past. Unix gurus, any ideas as to what I might be doing wrong would be very greatly appreciated as I've spent a lot of time googling and reading and am unable to find any code to do this. I have been able to express current epoch time in various formats, but again, nothing from the past.
I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)
How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix
my script will generate text file which have two fields
one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)
I have a file which has 100k+ records like this
abc,05-JUN-1974,def,lkj,aaa
def,11-SEP-1975,ghj,dis,dea
I want to convert ex 05-JUN-1974 to 06/05/1974
Please help me with awk script to convert the whole file into MM-DD-YYYY
Thank you! (2 Replies)
Hi all
I have some pipe-separated data in the form:
5/12/2008 00:00:00|31/1/2009 00:00:00|SOMESTUFF|OTHERSTUFF
12/31/2008 00:00:00|15/1/2009 00:00:00|MORESTUFF|REMAININGSTUFF
1/1/1023 00:00:00|16/5/2047 00:00:00|THEREST|YETMORE
I need to zero-pad the single-digit days and months, using... (3 Replies)
My csv has data like this
x,x,3452,2/18/1986,abc
x,g,19711,1/24/1986,abc
i want to replace date in the following format YYYY-mm-dd
how do i convert using awk script ? (8 Replies)
(Attention: Green PHP newbie !)
I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Hello,
I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10)
To extract the dates, I am using shell substrings, i.e.:
read line
... (4 Replies)
Hi I have a problem with Date format in my code.
1st I am trying to convert today's date to yesterday's using
YESTERDAY3=`perl -e '@y=localtime(time()-86400); printf "%04d/%02d/%02d",$y+1900,$y+1,$y;$y;'`
And once it is done I am trying to using the yesterday date in a grep command to... (3 Replies)
Hi Experts,
I'm facing an issue with date. My requirement is as follows
./script "dd/mm/yy" or ./script "dd/mm/yyyy"
epoch time
Im using solaris 10 and have downloaded gnu date.
I have tried using
$/usr/local/bin/date -d '25/02/2013'
/usr/local/bin/date: invalid date... (19 Replies)
I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY.
When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD
file... (3 Replies)
Discussion started by: Roozo
3 Replies
LEARN ABOUT DEBIAN
test::mocktime
Test::MockTime(3pm) User Contributed Perl Documentation Test::MockTime(3pm)NAME
Test::MockTime - Replaces actual time with simulated time
SYNOPSIS
use Test::MockTime qw( :all );
set_relative_time(-600);
# do some tests depending on time increasing from 600 seconds ago
set_absolute_time(0);
# do some more tests depending on time starting from the epoch
# epoch may vary according to platform. see perlport.
set_fixed_time(CORE::time());
# do some more tests depending on time staying at the current actual time
set_absolute_time('1970-01-01T00:00:00Z');
# do some tests depending on time starting at Unix epoch time
set_fixed_time('01/01/1970 00:00:00', '%m/%d/%Y %H:%M:%S');
# do some tests depending on time staying at the Unix epoch time
restore_time();
# resume normal service
DESCRIPTION
This module was created to enable test suites to test code at specific points in time. Specifically it overrides localtime, gmtime and time
at compile time and then relies on the user supplying a mock time via set_relative_time, set_absolute_time or set_fixed_time to alter
future calls to gmtime,time or localtime.
Functions
set_absolute_time
If given a single, numeric argument, the argument is an absolute time (for example, if 0 is supplied, the absolute time will be the
epoch), and calculates the offset to allow subsequent calls to time, gmtime and localtime to reflect this.
for example, in the following code
Time::Mock::set_absolute_time(0);
my ($start) = time;
sleep 2;
my ($end) = time;
The $end variable should contain 2 seconds past the epoch;
If given two arguments, the first argument is taken to be an absolute time in some string format (for example, "01/01/1970 00:00:00").
The second argument is taken to be a "strptime" format string (for example, "%m/%d/%Y %H:%M:%S"). If a single argument is given, but
that argument is not numeric, a "strptime" format string of "%Y-%m-%dT%H:%M:%SZ" is assumed.
for example, in the following code
Time::Mock::set_absolute_time('1970-01-01T00:00:00Z');
my ($start) = time;
sleep 2;
my ($end) = time;
The $end variable should contain 2 seconds past the Unix epoch;
set_relative_time($relative)
takes as an argument an relative value from current time (for example, if -10 is supplied, current time be converted to actual machine
time - 10 seconds) and calculates the offset to allow subsequent calls to time,gmtime and localtime to reflect this.
for example, in the following code
my ($start) = time;
Time::Mock::set_relative_time(-600);
sleep 600;
my ($end) = time;
The $end variable should contain either the same or very similar values to the $start variable.
set_fixed_time
If given a single, numeric argument, the argument is an absolute time (for example, if 0 is supplied, the absolute time will be the
epoch). All subsequent calls to gmtime, localtime and time will return this value.
for example, in the following code
Time::Mock::set_fixed_time(time)
my ($start) = time;
sleep 3;
my ($end) = time;
the $end variable and the $start variable will contain the same results
If given two arguments, the first argument is taken to be an absolute time in some string format (for example, "01/01/1970 00:00:00").
The second argument is taken to be a "strptime" format string (for example, "%m/%d/%Y %H:%M:%S"). If a single argument is given, but
that argument is not numeric, a "strptime" format string of "%Y-%m-%dT%H:%M:%SZ" is assumed.
restore()
restore the default time handling values. "restore_time" is an alias. When exported with the 'all' tag, this subroutine is exported as
"restore_time".
AUTHOR
David Dick <ddick@cpan.org>
PREREQUISITES
Time::Piece 1.08 or greater
BUGS
Probably.
COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
ACKNOWLEDGEMENTS
Thanks to a use.perl.org journal entry <http://use.perl.org/~geoff/journal/20660> by Geoffrey Young.
perl v5.10.0 2008-06-29 Test::MockTime(3pm)