Splitting week start date and end date based on custom period start dates
Below are my custom period start and end dates based on a calender, these dates are placed in a file, for each period i need to split into three weeks for each period row, example is given below.
Could you please help out to achieve solution through shell script..
Last edited by nani2019; 02-05-2020 at 12:05 PM..
Reason: none
Hi All,
I have problem in my file. It has two date variable.
There are 2 variables which has the values as below
1. START_MONTH = “Date(YYYYMM) format” Ex: 201008
2. END_MONTH = “Date(YYYYMM) format” Ex: 201105
The end date should be greater than start date.
Now we... (3 Replies)
Hi All,
I enter Start date and end date as parameters. I need to capture dates between start date and end date. Please let me know if you have any idea the same.
Thanks in advance.
Nagaraja Akkivalli. (5 Replies)
Hi All,
Want to get all dates and Julian week number for that date between the start date and end date. How can I achive this using perl?
(To achive above functionality, I was connecting to the database from DB server. Need to execute the same script in application server, since databse... (6 Replies)
Hi All,
what i want to do in perl is i should give the date at run time .Suppose date given is 23/12/2011(mm/dd/yyyy) the perl script shold find week start date, week end date, previous week start date,end date,next week start date, end date. In this case
week start date will be-:12/19/2011... (2 Replies)
Oracle Enterprise Linux
We want to track how long a process takes to complete its execution. This is what we want in the schell script
Before the process is started , get the time with date, hours and minutes
execute the process
After the process has ended , get the time with date,... (5 Replies)
Hi guys,
I am having the below logfile,date in yyyy-mm-dd
2013-08-02 *some content*
2013-08-02 *some content*
2013-08-02 *some content*
2013-08-03 *some content*
2013-08-05 *some content*
from the above logfile i need to get the lines between the two timestamps,if i give... (5 Replies)
Dear all,
I have an user passing 2 parameter 31/03/2015 and 02/04/2015 to a ksh script. How to print the start date to end date.
Expected output is :
31/03/2015
01/04/2015
02/04/2015
Note :
1. Im using aix and ksh
2. I have tried to convert the given input into a date, didnt... (0 Replies)
Discussion started by: mr.rajaravi
0 Replies
LEARN ABOUT DEBIAN
asql
ASQL(8) Perl Programmers Reference Guide ASQL(8)NAME
asql - Provide an SQL interface to Apache logfiles.
SYNOPSIS
asql [options]
General Options:
--help Show brief help intstructions.
--manual Show more complete help.
--version Show the version of the software.
Scripting Options:
--load Load the named file, or glob.
--execute Execute a single query then exit.
Options:
--file Rather than running as a shell read commands from a named file.
--quiet Don't show the banner at startup.
DESCRIPTION
asql provides a simple console interface to allow a user to
query the contents of an Apache logfile via an SQL interface.
The shell features include:
Persistent alias definitions.
Command line completion
Command history
Simple scriptability
INTRODUCTION
The asql shell will create a temporary SQLite database based upon
any number of Apache logfiles. This temporary database may then
be interactively queried using common SQL syntax.
To get started you should load your logfiles into the database:
load /var/log/apache2/acces*
(The tool will automatically decompress files which have been
compressed with gzip or bzip2.)
Once you've loaded at least one file you may run queries, for
example:
SELECT source,SUM(size) AS Number FROM logs GROUP BY source ORDER BY Number DESC, ip
This example shows all the clients connecting to your webserver
and the size of files/requests that they have downloaded in total.
As you can see we've selected two columns "source" and "SUM(size)".
To see which other columns are available you may execute the "show"
command.
Because parsing the Apache logfile(s) specified might be quite
slow there is the option of dumping the temporary SQLite database
to a known filename with the 'save' command. The analog to the
save command is the 'restore' command, which will read in an
existing SQLite database and allow future queries to be executed
against it.
FILES
When the shell starts up it will read and intepret the initialisation
file of ~/.asqlrc if it exists. Any commands present in that file
will be executed prior to the launch of the interactive session.
All aliases will be read and written to the file ~/.asql.aliases.
All interactive history will be written to the file ~/.asql.
AUTHOR
Steve
--
http://www.steve.org.uk/
LICENSE
Copyright (c) 2007,2008,2009,2010 by Steve Kemp. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the
full text of the license.
AUTHOR
Steve
--
http://www.steve.org.uk/
LICENSE
Copyright (c) 2007-2020 by Steve Kemp. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the
full text of the license.
perl v5.10.1 2010-10-04 ASQL(8)