12-12-2014
UNIX- Adding days to datetime variable
Hello All,
I have a date with timestamp stored in a variable and another variable which stores no. of days.
Var1=2014-12-11 12:54:21
Var2=5
In my unix script, I have to add the no. of days stored in var2 with the var1 date.
Var3=var1+var2=2014-12-16 12:54:21
Can you please advise if there is any unix function similar to dateadd MS SQL Server function. I tried using date -d argument,
but it is not supported in our environment.
Thank you in advance for your valuable suggestions.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how can we add or subtract days from the output of date command in unix...
like if i want to subtract a day from the result of date command like this..
v_date=`date +%Y%m%d`
this wud give me 20080519
now i want to subtract one day from this.. so tht it wud give me 20080518..
how do i do... (1 Reply)
Discussion started by: St.Fartatric
1 Replies
2. Shell Programming and Scripting
Hello Unix gurus,
I need to add days to the input date and further use it in comparision with the existing date.
Im having issues sto add days to date,can you guys help me with script or function with which I can add days to the date.
Thanks,
Sud (10 Replies)
Discussion started by: sud
10 Replies
3. Shell Programming and Scripting
Hi,
New to scripting.
I have datetime as a String and I need to add some hours/minutes in to that.
21/10/2009 23:00:00
After adding 180 minutes; it will look like this
22/10/2009 02:00:00
Regards,
Vikas Mahajan (9 Replies)
Discussion started by: vikas482
9 Replies
4. Shell Programming and Scripting
I am writing a script that requires the number of days in any given month.
In the shell, I can use the command:
cal `date +%m` `date +%Y`| grep -v '' | wc -w
to give me the number of days in the month, but when I assign it to a variable:
VAR=`cal `date +%m` `date +%Y`| grep -v '' | wc... (3 Replies)
Discussion started by: skaptakalian
3 Replies
5. Shell Programming and Scripting
Hi,
could someone help on this..
I have a date in variable
procdate="05/30/2009"
I would want to Subtract it with 3 or 4 (2 Replies)
Discussion started by: infernalhell
2 Replies
6. Windows & DOS: Issues & Discussions
Hi,
I'm writing an batch file to create report
In the batch file iam passing two arguments:startdate and finishdate
Ex: startdate=07-sep-2009 finishdate=07-sep-2011
I need to have script that takes command line argument as input and gives me out currentdate last year and current date... (2 Replies)
Discussion started by: anand1773
2 Replies
7. Shell Programming and Scripting
Hi! I am trying to read a file and every line has a specific date as one of its fields.
I want to take that date and compare it to the date today plus 6 days.
while read line
do
date=substr($line, $datepos, 8) #date is expected to be YYYYMMDD
if ; then
...proceed commands
... (1 Reply)
Discussion started by: kokoro
1 Replies
8. Shell Programming and Scripting
Hey Guys,
I have looked for a solution throughout the forum for my particular question, but I cant find one. So I'm sorry if I overlooked it. I need to be able to 48 add hours to a particular DateTime string.
I have a variable named $startTime
I would like to be able to take that... (1 Reply)
Discussion started by: chagan02
1 Replies
9. Shell Programming and Scripting
Hi, please can somebody let me know the easiest way to add days to a date.
I can do this in perl but would like to able to do it in a shell script.
Desired output would be:
date +'%Y-%m-%d' + 10 = 2016-05-02
Thank you (8 Replies)
Discussion started by: andy391791
8 Replies
10. UNIX for Beginners Questions & Answers
I am trying to add a date variable to the end of each line. This is what I have to start with
cat ${DATAPATH}/Participate_Stream${STREAMDATE}.dryak1.csv | grep ^',' | awk '{print $0}' >> ${DATAPATH}/badparticipant.csv
This is what I tried $DATE is a variable I have defined.
cat... (3 Replies)
Discussion started by: req62861
3 Replies
LEARN ABOUT PHP
px_date2string
PX_DATE2STRING(3) PX_DATE2STRING(3)
px_date2string - Converts a date into a string.
SYNOPSIS
string px_date2string (resource $pxdoc, int $value, string $format)
DESCRIPTION
Turns a date as it stored in the paradox file into human readable format. Paradox dates are the number of days since 1.1.0000. This func-
tion is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the example below.
PARAMETERS
o $pxdoc
- Resource identifier of the paradox database as returned by px_new(3).
o $value
- Value as stored in paradox database field of type PX_FIELD_DATE.
o $format
- String format similar to the format used by date(3). The placeholders support by this function is a subset of those supported by
date(3) (Y, y, m, n, d, j, L).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Turn a paradox date into a human readable form
<?php
$px = px_new();
/* make up a date as it could be stored in */
/* a date field of a paradox db. */
/* 700000 days since 1.1.0000. */
$days = 700000;
/* Use the calendar functions to print a */
/* human readable format of the date */
echo jdtogregorian($days+1721425)."
";
/* px_date2string() outputs the same */
echo px_date2string($px, $days, "n/d/Y")."
";
px_delete($px);
?>
The above example will output:
7/15/1917
7/15/1917
SEE ALSO
px_timestamp2string(3), jdtogregorian(3).
PHP Documentation Group PX_DATE2STRING(3)