Sponsored Content
Top Forums Shell Programming and Scripting How to get the difference between dates?Can i treat as string? Post 302094095 by EDBGSK on Wednesday 25th of October 2006 07:12:26 AM
Old 10-25-2006
Compare the first column and get the second column from file.

Hi All ,

I have an output value with two columns like this...

Days User
10 A
500 B
1 C

How i can compare the first column value and passing the user name as parameter?

For example :

while read -r days
If (days<=30) ;
then
value=days/30 x100
update tableA set value = ${value} where user=A
else
update tableA set value=100 where user=B

Anyone can help me?

Thank you!!

Last edited by EDBGSK; 10-25-2006 at 10:21 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Difference between two dates...

Hi All, Wish you a Happy New year... I have to find the difference between two dates, the result should be the number of days. I have seen the "datecalc" function. Its good, can I have any other alternative. Thanks in Advance Raju (4 Replies)
Discussion started by: rajus19
4 Replies

2. Shell Programming and Scripting

Difference between two dates in no of days ???

Hi All How to get the difference between two dates in no of days ??? My date format is like this YYYY/MM/DD. I have to get the no of days between two dates in the given format. I tried to search the forum but nothing came up similar to my requitement. Your help will be appreciated. ... (1 Reply)
Discussion started by: csaha
1 Replies

3. Shell Programming and Scripting

Difference between two dates.

Hi all. My question may seems to be similar to one that already been here. But i need a little other solution. I have two dates in format dd/mm/yyyy. I need to find number of days between them. I need to do it in bash script. I am running on Solaris machine and have cutted 'date' command version... (1 Reply)
Discussion started by: kukuruku
1 Replies

4. Shell Programming and Scripting

Perl difference between dates

Hi, Is there any way I can get the difference between two dates in terms of days? I have used this method so far, but I cant format it in terms of days. @a=&DateCalc($date1,$date2,0); The o/p that I am getting is sort of like this: +0:0:0:4:0:0:0 I just want to get 4 days as an o/p.... (1 Reply)
Discussion started by: King Nothing
1 Replies

5. Shell Programming and Scripting

Difference between two dates

Hi! I have two parameters like this: YYYY-MM-DD YYYY-MM-DD My question is, there is a direct command for get the elapsed time between the 2 dates, or I have to find another way? Thx! (1 Reply)
Discussion started by: MalaTomi
1 Replies

6. Shell Programming and Scripting

Difference between two dates

hi all, I need a help for below requirement. Difference between two dates"12-11-2009" and "03-25-2012" (mm-dd-yy format") in weeks and days and hours Please help me for this. Thanks in adv.... I am working in AIX, so dont have below command:- date --version (2 Replies)
Discussion started by: gani_85
2 Replies

7. Shell Programming and Scripting

How to Calculate the difference between two dates?

I want the difference between two following date using scripts in terms of no.of days. How I can accomplish this. lastdate=Tue Nov 13 10:30:56 2012 currdate=Wed Dec 15 15:58:21 PAKST 2012 Ouput should be like this: Your Password will expire after = 32 Days on Wed Dec 15 15:58:21 PAKST... (1 Reply)
Discussion started by: m_raheelahmed
1 Replies

8. Shell Programming and Scripting

Difference between 2 dates

Hi Friends, I have a file that has the contents like below: file1.txt 5,13/07/2013 23:25:25,14/07/2013 19:40:21 5,13/07/2013 23:25:25,14/07/2013 19:40:43 5,12/07/2013 23:50:50,13/07/2013 20:30:26 5,12/07/2013 23:20:24,13/07/2013 19:40:53 60,14/07/2013 00:00:00,14/07/2013 23:00:39... (5 Replies)
Discussion started by: vsachan
5 Replies

9. Fedora

Difference of dates

I have a script which is printing date in below format while writing the logs. theDate=`date +"%m%d%Y"` theTime=`date +"%H%M%S"` echo $theDate $theTime How can i find out difference current time and above format. Appreciate your help. (6 Replies)
Discussion started by: srikanth38
6 Replies

10. UNIX for Beginners Questions & Answers

Difference between two dates

Hi There I am trying to find the difference between two dates in seconds, by taking the first 10 digits of the file name itself, which I have done as shown below: current_time=`date +%s` last_login_of_tim=`date -d @1489662376 +%s` diff_sec=$(($current_time-$last_login_of_tim)) ... (5 Replies)
Discussion started by: simpsa27
5 Replies
TV_GRAB_COMBINER(1p)					User Contributed Perl Documentation				      TV_GRAB_COMBINER(1p)

NAME
tv_grab_combiner - Grab listings by combining data from several grabbers. SYNOPSIS
tv_grab_combiner --help tv_grab_combiner --configure [--config-file FILE] tv_grab_combiner [--config-file FILE] [--days N] [--offset N] [--output FILE] [--quiet] DESCRIPTION
Output TV and listings in XMLTV format by combining data from several other grabbers. First you must run tv_grab_combiner --configure to choose which grabbers you want to grab data with and how these grabbers should be configured. Then you can run tv_grab_combiner with the --days and --offset options to grab data. Omitting these options will use the default values for these parameters for each grabber. Since these defaults differs between grabbers, you might end up with data for different periods of time for different channels. OPTIONS
--configure Prompt for which grabbers to use, how these grabbers shall be configured and write the configuration file. --config-file FILE Set the name of the configuration file, the default is ~/.xmltv/tv_grab_combiner.conf. This is the file written by --configure and read when grabbing. --output FILE When grabbing, write output to FILE rather than standard output. --days N When grabbing, grab N days rather than 5. --offset N Start grabbing at today + N days. N may be negative. --quiet Suppress the progress-bar normally shown on standard error. --version Show the version of the grabber. --help Print a help message and exit. ERROR HANDLING
If any of the called grabbers exit with an error, tv_grab_combiner will exit with a status code of 1 to indicate that the data is incomplete. If any grabber produces output that is not well-formed xml, the output from that grabber will be ignored and tv_grab_combiner will exit with a status code of 1. ENVIRONMENT VARIABLES
The environment variable HOME can be set to change where configuration files are stored. All configuration is stored in $HOME/.xmltv/. AUTHOR
Mattias Holmlund, mattias -at- holmlund -dot- se. BUGS
perl v5.14.2 2012-06-13 TV_GRAB_COMBINER(1p)
All times are GMT -4. The time now is 10:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy