Sponsored Content
Top Forums Shell Programming and Scripting How to add decimal month to some month in sql, php, perl, bash, sh? Post 302904491 by RudiC on Wednesday 4th of June 2014 09:41:49 AM
Old 06-04-2014
Are you sure you know what you/your business is talking about? Usually, a day is a good basic unit for licence payments, which you can count; I can't see the need to calculate to the split second. To make your customer happy, give him the fraction of a day that might be in question.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl Script : Split given month into weeks

I want to split a given month into weeks. For example if I give the date in dd/mm/yy format say 01/02/08 it should give output in the given format : week1 : start date and end date. week2 : "" week3 : "" week4 : "" (5 Replies)
Discussion started by: khushbu_roy
5 Replies

2. Shell Programming and Scripting

Isolating the Month in Perl

munt=`date '+%m` will isolate the month in digit form 02 = Feb Trying to get the same out of perl just cant see it $stimx = localtime($^T); print ((split/ /,$stimx)); (4 Replies)
Discussion started by: popeye
4 Replies

3. UNIX for Dummies Questions & Answers

print previous month (current month minus 1) with Solaris date and ksh

Hi folks month=`date +%m`gives current month Howto print previous month (current month minus 1) with Solaris date and ksh (7 Replies)
Discussion started by: slashdotweenie
7 Replies

4. Shell Programming and Scripting

Script to counting a specific word in a logfile on each day of this month, last month etc

Hello All, I am trying to come up with a shell script to count a specific word in a logfile on each day of this month, last month and the month before. I need to produce this report and email it to customer. Any ideas would be appreciated! (5 Replies)
Discussion started by: pnara2
5 Replies

5. Shell Programming and Scripting

perl : searching for month and storing the date and time in an array

I am writing the code in perl. I have an array in perl and each variable in the array contains the data in the below format Now I need to check the below variable w.r.t system month I need to store the date and time(Tue Aug 7 03:54:12 2012) from the below data into file if contains only 'Aug'... (5 Replies)
Discussion started by: giridhar276
5 Replies

6. Shell Programming and Scripting

Convert From Month Number to Month Name

Hi, I have a script that accepts an input date from the user in yyyy-mm-dd format. I need to get the mm-dd part and convert it to month name. example: 2011-11-15 I want that to become "Nov 15" I don't have the GNU date, I am using an AIX os. Thanks. (1 Reply)
Discussion started by: erin00
1 Replies

7. Shell Programming and Scripting

Need last month files after 10th of every month

Hi, I need all file names in a folder which has date >= 10th of last month, Example : files in folder AUTO_F1_20140610.TXT BUTO_F1_20140616.TXT CUTO_F1_20140603.TXT FA_AUTO_06012014.TXT LA_AUTO_06112014.TXT MA_AUTO_06212014.TXT ZA_AUTO_06232014.TXT Output: AUTO_F1_20140610.TXT... (9 Replies)
Discussion started by: nani1984
9 Replies

8. UNIX for Advanced & Expert Users

To pass one month range in sql script

Hi Guys, i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g set timing on; whenever sqlerror exit failure; spool myscript.log append accept start_date... (7 Replies)
Discussion started by: rohit_shinez
7 Replies

9. Shell Programming and Scripting

Remove new line and convert Month to Decimal

# Sample input common-name www.test.com.au expiration Dec 21 01:00:31 2017 GMT common-name www.test1.com.au expiration Jan 19 04:41:03 2018 GMT # Desired Output # Field 1: Domain name # Field 2: Date/time converted to Austraian format DD/MM/YYYY and on the same line as Domain Name. #... (7 Replies)
Discussion started by: thangbom
7 Replies

10. Linux

Bash Display First Friday of the next month

Hello, I need to find the date of next first Friday of the month and set as a variable in a bash script ie - FIRSTFRIDAY=$(date -dfirst-friday +%d) I know date -dfirst-friday doesn't work, but unsure if I can use this / cal + awk or something else to find the right date of the... (7 Replies)
Discussion started by: summerdays
7 Replies
Date::Manip::Holidays(3pm)				User Contributed Perl Documentation				Date::Manip::Holidays(3pm)

NAME
Date::Manip::Holidays - describes holidays and events SYNOPSIS
This describes the Holidays and Events sections of the config file, and how they are used. Holidays and events are specific days that are named. Holidays are used in business mode calculations, events are not. Events may be used for other calendaring operations. HOLIDAYS
The holiday section of the config file is used to define holidays. Each line is of the form: STRING = HOLIDAY HOLIDAY is the name of the holiday (or it can be blank in which case the day will still be treated as a holiday... for example the day after Thanksgiving is often a work holiday though it is not named). STRING is a string which can be parsed to give a valid date. It can be any of the following forms: A full date Specific holidays can be set which occur only a single time. May 5, 2000 = A one-time-only holiday Any format parseable by Date::Manip::Date::parse_date can be used. A date without a year Some holidays occur every year on the same day. These can be defined using the simple lines: Jan 1 = New Year's Day Jul 4th = Independence Day fourth Thu in Nov = Thanksgiving These dates must be written in a form which can be parsed as a full date by simply adding the year to the end of the string. Please refer to the Date::Manip::Date documentation to see what forms will work. ISO 8601 dates will not work since the year comes first. Any format parseable by Date::Manip::Date::parse_date can be used. Recurrence The dates can be specified using recurrences: 1*0:0:0:0:0:0*EASTER = Easter 1*11:0:11:0:0:0*DWD = Veteran's Day In cases where you are interested in business type calculations, you'll want to define most holidays using recurrences, since they can define when a holiday is celebrated in the financial world. For example, Christmas might be defined as: Dec 25 = Christmas but if it falls on a weekend, there won't be a business holiday associated with it. It could be defined using a recurrence: 1*12:0:24:0:0:0*DWD = Christmas so that if Christmas falls on a weekend, a holiday will be taken on the Friday before or the Monday after the weekend. You can use the fully specified format of a recurrence: 1*2:0:1:0:0:0***Jan 1 1999*Dec 31 2002 = Feb 2 from 1999-2002 OTHER HOLIDAY CONSIDERATIONS
Recurrences which change years It is now valid to have a recurrence defined for New Year's day which pushes the holiday to the previous year. For example, the most useful definition of New Year's day is: 1*1:0:1:0:0:0*DWD = New Year's Day which means to choose the closest working day to observe the holiday, even though this might mean that the holiday is observed on the previous year. Order of definitions is preserved The order of the definitions is preserved. In other words, when looking at the holidays for a year, previously defined holidays (in the order given in the config file) are correctly handled. As an example, if you wanted to define both Christmas and Boxing days (Boxing is the day after Christmas, and is celebrated in some parts of the world), and you wanted to celebrate Christmas on a business day on or after Dec 25, and Boxing day as the following work day, you could do it in one of the following ways: 1*12:0:25:0:0:0*NWD = Christmas 1*12:0:26:0:0:0*NWD = Boxing or 1*12:0:25:0:0:0*NWD = Christmas 1*12:0:25:0:0:0*NWD = Boxing Holidays go into affect the minute they are parsed which is why the second example works (though for clarity, the first one is preferable). The first recurrence defined the first business day on or after Dec 25 as Christmas. The second one then defines the business day after that as Boxing day. Since the definitions are stored as a list (NOT a hash as they were in Date::Manip 5.xx), using the same recurrence twice does not cause a problem. Multiple holidays Having multiple holidays on a single day is allowed. As an example, you may want to look at New Years day as both the observed and actual holidays, so you might have: 1*1:0:1:0:0:0*DWD = New Year's Day (observed) Jan 1 = New Year's Day Most of the time, both will fall on the same day, but sometimes they may differ. In this example, it is important that the observed holiday be listed first. Otherwise, Jan 1 will be marked as a holiday and then the observed date will check Jan 1, but where it is not a business day, it will move to another day (due to the DWD modifier). Likewise, the two holidays: 3rd Sunday in June = Father's Day Jun 17 = Bunker Hill Day sometimes fall on the same day. Using the Date::Manip::Date::list_holidays method (or the Date_IsHoliday function), you can get a list of all names that the date contains. EVENTS
The Events section of the config file is similar to the Holiday section. It is used to name certain days or times, but there are a few important differences: Events can be assigned to any time and duration All holidays are exactly 1 day long. They are assigned to a period of time from midnight to midnight. Events can be based at any time of the day, and may be of any duration. Events don't affect business mode calculations Unlike holidays, events are completely ignored when doing business mode calculations. Whereas holidays were added with business mode math in mind, events were added with calendar and scheduling applications in mind. Every line in the events section is of the form: EVENT = NAME where NAME is the name of the event, and EVENT defines when it occurs and its duration. An EVENT can be defined in the following ways: Date YMD YM Recur Date ; Date YMD ; YMD YM ; YM Date ; Delta Recur ; Delta Date refers to a full date/time (and is any string that can be parsed by Date::Manip::Date::parse). YMD is any string which can be parsed by Date::Manip::Date::parse_date. YM is any string which can be parsed by the parse_date method to give a date in the current year. Recur is a partial or fully specified recurrence. Delta is any string that can be parsed to form a delta. With the "Date" form, or the "Recur" form, the event starts at the time (or times) specified by the date or recurrence, and last 1 hour long. With the "YMD" and "YM" forms, the event occurs on the given day, and lasts all day. With all of the two part forms ("Date;Date", "YM;YM", etc.), the event starts at the first date and goes to the second date, or goes an amount of time specified by the delta. The "YMD;YMD" and "YM;YM" forms means that the event lasts from the start of the first date to the end of the second. In the Date;Date form, the event goes from the first date to the second date inclusive. In other words, both dates are in the event. In the "Date;Delta" and "Recur;Delta" forms, the Delta tells the length of the event. Also, in the Date;Date form, the second date may NOT be expressed as a delta. Currently, having an event longer than 1 year is NOT supported, but no checking is done for this. KNOWN BUGS
None known. BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author. SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.14.2 2012-06-02 Date::Manip::Holidays(3pm)
All times are GMT -4. The time now is 08:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy