02-03-2010
date range
I have a number of instances wher I need to run reports for the previous month and need to include the last months date range in the sql.
I want to create a string which consists of the first and last dates of last month separated with an ' and ' ie for this month (Feb) I want it to say
'01/01/10 and 31/01/10'
Needs to work for all months and work in leap years. It will be run on the same date of each month.
Any help would be appreciated
Niven
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi all,
I'm trying to do a cp only on files I created on a given day or within a certain date range.
What's the best way to do this?
Cheers,
KL (1 Reply)
Discussion started by: ee7klt
1 Replies
2. Shell Programming and Scripting
Hi Experts,
I have files name
report_20090416
report_20090417
report_20090418
report_20090420
report_20090421
I have 2 input from user
From Date: 20090417
To Date: 20090420
and I need to grep only those line in between. Output should be
report_20090417
report_20090418... (3 Replies)
Discussion started by: tanit
3 Replies
3. Shell Programming and Scripting
Hi ,
I need a function that verfies the given date is between start date and end date .
I have written this but this not working if start date is 1900/01/01
Below is my code
validateDate()
{
RC=$#
if
then
return 0
else
... (2 Replies)
Discussion started by: Satyak
2 Replies
4. Shell Programming and Scripting
Hi All,
I have a log file which has first few characters of every line as a timestamp.
2010-06-01 04:56:02,802 DEBUG {Thread-27} Some text message
2010-06-01 04:56:02,802 DEBUG {Thread-27} Some text message
2010-06-01 04:56:02,802 DEBUG {Thread-27} Some text message
2010-06-01... (7 Replies)
Discussion started by: nitin14341
7 Replies
5. Shell Programming and Scripting
Hi All,
Can anybody help me out a Shell script which pulls the files based on date range
Example
./test.sh start_date End_date (20110901 20110930)
or
./test.sh ( if we don't provide any input)
it should take sysdate-1 ( yesterdays date)
it should have both conditions
Plzz help me... (1 Reply)
Discussion started by: krux_rap
1 Replies
6. Shell Programming and Scripting
Hi Everyone How all are doing today,
Want some help from All in Unix, What I am trying to do is , A shell file should be a called with two date parameters suppose the shell file name is run.sh
run.sh <start_date> <end_date>
If end date is not given it will pick today's date. The date should... (7 Replies)
Discussion started by: adisky123
7 Replies
7. Shell Programming and Scripting
Solaris 10
ksh88
Sorry for re-hashing some of this, but I can't find a proper solution in the forums.
Starting with /a/archive containing (on and on date formatted directories)
20060313 20080518 20100725 20121015
20060314 20080519 ... (1 Reply)
Discussion started by: moesplace
1 Replies
8. UNIX for Dummies Questions & Answers
Hi
i am try to run a script by using a dates here is what i am doing
EXPORTDATE=`date --date "2 days ago" +%Y-%m-%d`
sh /path/to/the/files.sh ${EXPORTDATE}
the above code runs the job for one day,if i want to run the job for all the past 4 days how can i pass the date as a... (1 Reply)
Discussion started by: vikatakavi
1 Replies
9. UNIX for Dummies Questions & Answers
My unix version is IBM AIX Version 6.1
I tried google my requirement and found the below answer,
find . -newermt “2012-06-15 08:13" ! -newermt “2012-06-15 18:20"
But newer command is not working in AIX version 6.1 unix
I have given my requirement below:
Input:
atr files:
... (1 Reply)
Discussion started by: yuvaa27
1 Replies
10. Shell Programming and Scripting
Dear all,
how can I select in the file below only the files created between Aug 14 2014 and Feb 03 2015?
EZA2284I -rw-r--r-- 1 30 8 356954 Aug 15 2014 file1
EZA2284I -rw-rw-r-- 1 30 8 251396 Feb 05 12:53 file2
EZA2284I -rw-rw-r-- 1 30 8 ... (3 Replies)
Discussion started by: simomuc
3 Replies
CAL(1) BSD General Commands Manual CAL(1)
NAME
cal, ncal -- displays a calendar and the date of Easter
SYNOPSIS
cal [-3hjy] [-A number] [-B number] [[month] year]
cal [-3hj] [-A number] [-B number] -m month [year]
ncal [-3hjJpwy] [-A number] [-B number] [-s country_code] [[month] year]
ncal [-3hJeo] [-A number] [-B number] [year]
ncal [-CN] [-H yyyy-mm-dd] [-d yyyy-mm]
DESCRIPTION
The cal utility displays a simple calendar in traditional format and ncal offers an alternative layout, more options and the date of Easter.
The new format is a little cramped but it makes a year fit on a 25x80 terminal. If arguments are not specified, the current month is dis-
played.
The options are as follows:
-h Turns off highlighting of today.
-J Display Julian Calendar, if combined with the -e option, display date of Easter according to the Julian Calendar.
-e Display date of Easter (for western churches).
-j Display Julian days (days one-based, numbered from January 1).
-m month
Display the specified month. If month is specified as a decimal number, it may be followed by the letter 'f' or 'p' to indicate the
following or preceding month of that number, respectively.
-o Display date of Orthodox Easter (Greek and Russian Orthodox Churches).
-p Print the country codes and switching days from Julian to Gregorian Calendar as they are assumed by ncal. The country code as deter-
mined from the local environment is marked with an asterisk.
-s country_code
Assume the switch from Julian to Gregorian Calendar at the date associated with the country_code. If not specified, ncal tries to
guess the switch date from the local environment or falls back to September 2, 1752. This was when Great Britain and her colonies
switched to the Gregorian Calendar.
-w Print the number of the week below each week column.
-y Display a calendar for the specified year.
-3 Display the previous, current and next month surrounding today.
-A number
Display the number of months after the current month.
-B number
Display the number of months before the current month.
-C Switch to cal mode.
-N Switch to ncal mode.
-d yyyy-mm
Use yyyy-mm as the current date (for debugging of date selection).
-H yyyy-mm-dd
Use yyyy-mm-dd as the current date (for debugging of highlighting).
A single parameter specifies the year (1-9999) to be displayed; note the year must be fully specified: ``cal 89'' will not display a calendar
for 1989. Two parameters denote the month and year; the month is either a number between 1 and 12, or a full or abbreviated name as speci-
fied by the current locale. Month and year default to those of the current system clock and time zone (so ``cal -m 8'' will display a calen-
dar for the month of August in the current year).
Not all options can be used together. For example ``-3 -A 2 -B 3 -y -m 7'' would mean: show me the three months around the seventh month,
three before that, two after that and the whole year. ncal will warn about these combinations.
A year starts on January 1.
Highlighting of dates is disabled if stdout is not a tty.
SEE ALSO
calendar(3), strftime(3)
HISTORY
A cal command appeared in Version 5 AT&T UNIX. The ncal command appeared in FreeBSD 2.2.6.
AUTHORS
The ncal command and manual were written by Wolfgang Helbig <helbig@FreeBSD.org>.
BUGS
The assignment of Julian-Gregorian switching dates to country codes is historically naive for many countries.
Not all options are compatible and using them in different orders will give varying results.
BSD
March 14, 2009 BSD