Hi,
I'm trying to accomplish the following and would like some suggestions or possible bash script examples that may work
I have a directory that has a list of log files that's periodically dumped from a script that is crontab that are rotated 4 generations. There will be a time stamp that is... (4 Replies)
Hi all,
how can I compare two defferent lines in a csv file, with the date values,
and print the latest date!
example:
cat test.csv
test1;whatever;Wed Nov 26 14:17:48 CET 2008
test1;whatever;Wed Nov 26 17:14:06 CET 2008
Any suggession? (4 Replies)
So I have a csv file where the 3rd field is a date string in the format yyyy-mm-dd. I need to change it to mm/dd/yyyy. So each line in the csv file looks like:
StringData,StringData,2009-02-17,12.345,StringData
StringData,StringData,2009-02-16,65.789,StringData
Any idea how I can keep... (5 Replies)
Hi,
Im having a hard time in creating a script with the following conditions below. I have a csv file generated which is updated every 5 mins and it contains a timestamp in it. for example:
time data
00:00 1
00:05 0
00:10 6
00:15 3
however, there is a time that... (4 Replies)
Hi,
I've been trying (and failing miserably) all morning to strip from a CSV file the time from it.
Can somebody point me in the right direction on how to do this using sed or awk?
The file looks like:
"James","07/20/2009-14:40:11"
"Steve","08/06/2006-02:34:37"... (5 Replies)
Hello All,
Need a shell script to sort entries in a file by date and time. Below are the entries in the file, i need to sort it first by the date and then time
Note :- Date is in MM/DD/YY format and date comes as the 6th & time comes on 7th coloumns respectively.
150 pbnawldb001-b... (10 Replies)
Hi,
i have csv input file looks like below
3rd field is date and time field i want to change it with user supplied date and time says
year=2011
month=09
day=05
hour=11
count=2
when count is say 10 then first ten records should pick and it should increment the... (2 Replies)
I have a CSV file with a date format like this;
11/19/2012 17:37:00,1.372,121.6
11/19/2012 17:38:00,0.743,121.6
Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts.
Needs to... (3 Replies)
Hi,
We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places
But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script.
Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies
LEARN ABOUT PHP
datetime.add
DATETIME.ADD(3) 1 DATETIME.ADD(3)DateTime::add - Adds an amount of days, months, years, hours, minutes and seconds to a DateTime object
Object oriented style
SYNOPSIS
public DateTime DateTime::add (DateInterval $interval)
DESCRIPTION
Procedural style
DateTime date_add (DateTime $object, DateInterval $interval)
Adds the specified DateInterval object to the specified DateTime object.
PARAMETERS
o $object
-Procedural style only: A DateTime object returned by date_create(3). The function modifies this object.
o $interval
- A DateInterval object
RETURN VALUES
Returns the DateTime object for method chaining or FALSE on failure.
EXAMPLES
Example #1
DateTime.add(3) example
Object oriented style
<?php
$date = new DateTime('2000-01-01');
$date->add(new DateInterval('P10D'));
echo $date->format('Y-m-d') . "
";
?>
Procedural style
<?php
$date = date_create('2000-01-01');
date_add($date, date_interval_create_from_date_string('10 days'));
echo date_format($date, 'Y-m-d');
?>
The above examples will output:
2000-01-11
Example #2
Further DateTime.add(3) examples
<?php
$date = new DateTime('2000-01-01');
$date->add(new DateInterval('PT10H30S'));
echo $date->format('Y-m-d H:i:s') . "
";
$date = new DateTime('2000-01-01');
$date->add(new DateInterval('P7Y5M4DT4H3M2S'));
echo $date->format('Y-m-d H:i:s') . "
";
?>
The above example will output:
2000-01-01 10:00:30
2007-06-05 04:03:02
Example #3
Beware when adding months
<?php
$date = new DateTime('2000-12-31');
$interval = new DateInterval('P1M');
$date->add($interval);
echo $date->format('Y-m-d') . "
";
$date->add($interval);
echo $date->format('Y-m-d') . "
";
?>
The above example will output:
2001-01-31
2001-03-03
NOTES DateTime.modify(3) is an alternative when using PHP 5.2.
SEE ALSO DateTime.sub(3), DateTime.diff(3), DateTime.modify(3).
PHP Documentation Group DATETIME.ADD(3)