07-25-2008
How to calculate specific hours between 2 dates
Hi there,
I am trying to find out a way to calculate how many hours are between 2 dates but from a specific time range, actually working hours (Monday to Friday 09:00 - 18:00).
What I mean is for example
date1 = Monday 21 July 2008 22:00:00 so in python 2008-07-21 22:00:00
date2 = Wednesday 23 July 2008 12:00:00 so in python 2008-07-23 12:00:00
and I want to find a way to say
date2 - date1 = 12 hours
Always the date2 is in working hours.
Anybody has an idea how to do this? Actually I don't care about the programming language I just want to find the best logic to do this and then I will write it in python
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I extract dates from the log file and need to calculate days between two dates. My dates are in yyyyMmmdd format. Example:
$d1=2011 Oct 21
$d2=2012 Feb 20
I need to calculate the number of days between $d2 and $d1. This is on Solaris.
Any ideas?
Thanks,
djanu (4 Replies)
Discussion started by: djanu
4 Replies
2. Web Development
Is this code good for this purpose?
<?php
$date1 = mktime(0,0,0,01,01,1991);
$date2 = mktime(0,0,0,03,22,2012);
$diff = $date2 - $date1;
$days = $diff / (60*60*24);
echo ($days . "<br />");
?> (3 Replies)
Discussion started by: kovacsakos
3 Replies
3. Shell Programming and Scripting
I wrote the day calculator also in bash. I would like to now, that is it good so?
#!/bin/bash
datum1=`date -d "1991/1/1" "+%s"`
datum2=`date "+%s"`
diff=$(($datum2-$datum1))
days=$(($diff/(60*60*24)))
echo $days
Thanks in advance for your help! (3 Replies)
Discussion started by: kovacsakos
3 Replies
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
shell script to calculate difference between 2 dates (3 Replies)
Discussion started by: gredpurushottam
3 Replies
6. Shell Programming and Scripting
Hi,
how to calculate the time difference between PST date and PDT date in perl scripting.
date1: Mon Dec 31 16:00:01 PST 2015
date2: Tue Mar 19 06:09:30 PDT 2013
and also difference between PST-PST and PDT-PDT
need difference in months or days (months prefereble). (3 Replies)
Discussion started by: praveen265
3 Replies
7. Shell Programming and Scripting
I have to fetch files from a location hour wise.
Eg files available at location /tmp/data/ are
A20140205.1300-1315......
.
.
A20140205.1400-1415......
.
.
A20140205.1700-1715......
.
.
.
.
Below is the code I have prepared.
But it works only for one hour.
For instance... (1 Reply)
Discussion started by: Saidul
1 Replies
8. UNIX for Advanced & Expert Users
Hello,
I have a question please,
How could I get ALL update dates and hours of a file ?
For example:
I modified a file on 09/04/2014 at 7:am for the first time. Then, I modified again the same file on 09/04/2014 at 9 am and finally, I modified the same file again on 10/04/2014 at... (3 Replies)
Discussion started by: nurinolo
3 Replies
9. Shell Programming and Scripting
I have two dates in below format, how would I find the hours difference between the two dates. Im using AIX and ksh.
Current date : Wed May 17 14:34:41 SGT 2017
File date : Thu Apr 27 20:52:41 SGT 2017 (3 Replies)
Discussion started by: simpltyansh
3 Replies
10. Red Hat
Objective: We have multiple files in a folder and we want to delete all files except for last 1 week files.
Note: We are copying these files from original location to this temporary location. So time shown for these files are time when we copied to this location. Not that when file was created.... (2 Replies)
Discussion started by: Agoyals1986
2 Replies
CALENDAR(1) General Commands Manual CALENDAR(1)
NAME
calendar - reminder service
SYNOPSIS
calendar [ - ]
DESCRIPTION
Calendar consults the file `calendar' in the current directory and prints out lines that contain today's or tomorrow's date anywhere in the
line. Most reasonable month-day dates such as `Dec. 7,' `december 7,' `12/7,' etc., are recognized, but not `7 December' or `7/12'. If
you give the month as ``*'' with a date, i.e. ``* 1'', that day in any month will do. On weekends `tomorrow' extends through Monday.
When an argument is present, calendar does its job for every user who has a file `calendar' in his login directory and sends him any posi-
tive results by mail(1). Normally this is done daily in the wee hours under control of cron(8).
The file `calendar' is first run through the ``C'' preprocessor, /lib/cpp, to include any other calendar files specified with the usual
``#include'' syntax. Included calendars will usually be shared by all users, maintained and documented by the local administration.
FILES
calendar
/usr/libexec/calendar to figure out today's and tomorrow's dates
/etc/passwd
/tmp/cal*
/lib/cpp, egrep, sed, mail as subprocesses
SEE ALSO
at(1), cron(8), mail(1)
BUGS
Calendar's extended idea of `tomorrow' doesn't account for holidays.
7th Edition October 21, 1996 CALENDAR(1)