05-16-2014
Convert date into days using shell script
Hi,
I have date format in an excel sheet as 07/03/2014 11:21. I need to check this date with current date and need to find whether it is more than 30 days or not.
I know how to current date into days, but someone please help me to change the date in the excel sheet to days, so that i can check with simple expr function.
Regards,
Arasu
10 More Discussions You Might Find Interesting
1. AIX
hello !
can so help me ? i'm writting a shell srcipt ( UNIX AIX) and I'd like to convert a date as 20041108 in lilian format.
thanks so much (2 Replies)
Discussion started by: chocolate
2 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
I have a csv file and column 1 is date in the cursed YYYY-M-D format. Is there any way to convert 1st column to an absolute date say using 1977-1-1 as day 1?
Thanks a lot. (2 Replies)
Discussion started by: onthetopo
2 Replies
3. Shell Programming and Scripting
i need a script that can tell me the date 2 days ago or 3 days ago.
please help (7 Replies)
Discussion started by: tomjones
7 Replies
4. Shell Programming and Scripting
Hi Guys,
I was working some time ago n was in need to calculate date 30/31 days from today including Feb (Leap yr stuff). Today date is variable depending on day of execution of script. I tried searching but was not able to get exactly what I needed....So at that I time I implemented by my own... (3 Replies)
Discussion started by: coolgoose85
3 Replies
5. AIX
Hi,
How can I convert a string "Jul 10 09" to date in aix? the output can be like 20090710.
Thanks. (4 Replies)
Discussion started by: Gbyte
4 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 writing a cron job.
so for it i need the 60 days old date form current date in variable.
Like today date is 27 jan 2011 then output value will be stote in variable in formet Nov 27.
i am using EST date, and tried lot of solution and see lot of post but it did not helpful for me. so... (3 Replies)
Discussion started by: Himanshu_soni
3 Replies
8. Shell Programming and Scripting
Hi,
I want to subtract 'n' days from the current timestamp in a k shell script. Is there any inbuilt function to do it
or any workaround solution to get the date. And I want the output to be in YYYY:MM:DD HH:MM:SS format. Please help.
Thanks in advance. (4 Replies)
Discussion started by: Suryaaravindh
4 Replies
9. UNIX for Dummies Questions & Answers
hi friends,
I m trying to write a script which compares to dates.
for this i am converting dates into no using synatx
as below
v2=`date | awk '{print $2,$3,$4}'`
v3=`date +%s -d "$v2"`
this syntax is working in bash shell ,but fails in ksh shell.
please suggest on this. (12 Replies)
Discussion started by: Jcpratap
12 Replies
10. Shell Programming and Scripting
Hi,
I have a requirement where I am getting date in string format (20161130). I need to add 20 days(not no. 20) to the above string. The o/p should 20161220.
In case of 20170228, it should show 20170320.
Could you please help me with the command to achieve this.
Note: I am using AIX 7.1... (5 Replies)
Discussion started by: satyaatcgi
5 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)