Thanks for your interest. At the moment I do this
and in the query I say
This requires the dates to be changed every year obviously which is what Im trying to address.
Its running HP-UX (not sure which version) with a Unify database. The sql is the Unify SQL. The date field is defined as 'huge date' whatever that means in Unify.
Hope this helps.
Thanks
Last edited by pludi; 02-04-2010 at 04:24 AM..
Reason: code tags, please...
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT MOJAVE
cal
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