Date & time arithmetics is one of the worst problems in IT, so you can spend endless time and resources to get it right. Ignoring several itches like short months, year end crossing, and leap years, here is a veeery simple approach to get you started with the sample data that you gave. Error messages are sent to the null device, and we use the (dangerous and deprecated) eval command because we (hope we) know exactly what we're doing, and take advantage of recent bash's functionality. Try (with $1 set to 170101, and $2 to 12):
If happy, you can run this through e.g. sh.
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Hi all
Im calling a DB procedure as foll
sqlplus -s $DB_USERID/$DB_PASSWD@$DB_NAME<<eof
var var1 VARCHAR2(200);
exec ODAS_BATCH_JOBS_RETRIEVE.retrieve_user_info(:var1);
eof
echo $var1
This echo is giving a blank.
Also in case the package ODAS_BATCH_JOBS_RETRIEVE is in an un compiled... (2 Replies)
I need a script to get the files for DEC
the file format will be
B20_abc_ancdfefg_20101209_INCR_201012100145.TXT.gz
Based on the bold ones (date) i need to get the files
can any one help me plzzzzzz (2 Replies)
while i try to start the audit i have the below error message .
audit>audit start
** auditing enabled already
A system call received a parameter that is not valid.
please advice (6 Replies)
I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
I need to check if the parameters are correctly passed based on the Environment I am in.
For e.g when I am in dev the 1st paramter needs to be either A OR B OR C OR D
similarly when I am in qa the parameter needs to be either e or f
so i need to write a case staement or a if statement to... (1 Reply)
Hi.
How do I achieve this
sh /EDWH-DMT02/script/MISC/exec_sql.sh "@/EDWH-DMT02/script/others/CSM_CKC/Complete_List.sql ${file_name}" Complete_List.txt
The /EDWH-DMT02/script/MISC/exec_sql.sh has two parameters and it's working fine with this
sh /EDWH-DMT02/script/MISC/exec_sql.sh... (7 Replies)
hi Guys,
is there a way to pass parameter into oracle store procedure by reading date range in file and increment accordingly. Something like this
file.txt
01-JAN-2015
03-JAN-2015
sqlplus -s user/pwd@DB
execute TEST( to_date( '01-JAN-2015, 'dd.mm.yyyy' ), to_date( '03-JAN-2015', ... (1 Reply)
Hi
I have a text file (Input.txt) with two column entries separated by tab as given below:
aaa str1
bbb str2
cccccc str3
dddd str4
eee str3
ssss str2
sdf str3
hhh str1
fff str2
ccc str3
.....
.....
..... (1 Reply)
I am having below script which needs to be executed based on start and end date
#!/bin/bash
array=('2016-09-27' '2016-10-27' '2016-11-27' '2016-12-27' '2017-01-27' '2017-02-27' '2017-03-27' '2017-04-27' '2017-05-27' '2017-06-27' '2017-07-27' '2017-08-27' '2017-09-27' )
for i in "${array}"
do... (9 Replies)
Discussion started by: rohit_shinez
9 Replies
LEARN ABOUT FREEBSD
week
CALENDAR(3) BSD Library Functions Manual CALENDAR(3)NAME
easterg, easterog, easteroj, gdate, jdate, ndaysg, ndaysj, week, weekday -- Calendar arithmetic for the Christian era
LIBRARY
Calendar Arithmetic Library (libcalendar, -lcalendar)
SYNOPSIS
#include <calendar.h>
struct date *
easterg(int year, struct date *dt);
struct date *
easterog(int year, struct date *dt);
struct date *
easteroj(int year, struct date *dt);
struct date *
gdate(int nd, struct date *dt);
struct date *
jdate(int nd, struct date *dt);
int
ndaysg(struct date *dt);
int
ndaysj(struct date *dt);
int
week(int nd, int *year);
int
weekday(int nd);
DESCRIPTION
These functions provide calendar arithmetic for a large range of years, starting at March 1st, year zero (i.e., 1 B.C.) and ending way beyond
year 100000.
Programs should be linked with -lcalendar.
The functions easterg(), easterog() and easteroj() store the date of Easter Sunday into the structure pointed at by dt and return a pointer
to this structure. The function easterg() assumes Gregorian Calendar (adopted by most western churches after 1582) and the functions
easterog() and easteroj() compute the date of Easter Sunday according to the orthodox rules (Western churches before 1582, Greek and Russian
Orthodox Church until today). The result returned by easterog() is the date in Gregorian Calendar, whereas easteroj() returns the date in
Julian Calendar.
The functions gdate(), jdate(), ndaysg() and ndaysj() provide conversions between the common "year, month, day" notation of a date and the
"number of days" representation, which is better suited for calculations. The days are numbered from March 1st year 1 B.C., starting with
zero, so the number of a day gives the number of days since March 1st, year 1 B.C. The conversions work for nonnegative day numbers only.
The gdate() and jdate() functions store the date corresponding to the day number nd into the structure pointed at by dt and return a pointer
to this structure.
The ndaysg() and ndaysj() functions return the day number of the date pointed at by dt.
The gdate() and ndaysg() functions assume Gregorian Calendar after October 4, 1582 and Julian Calendar before, whereas jdate() and ndaysj()
assume Julian Calendar throughout.
The two calendars differ by the definition of the leap year. The Julian Calendar says every year that is a multiple of four is a leap year.
The Gregorian Calendar excludes years that are multiples of 100 and not multiples of 400. This means the years 1700, 1800, 1900, 2100 are
not leap years and the year 2000 is a leap year. The new rules were inaugurated on October 4, 1582 by deleting ten days following this date.
Most catholic countries adopted the new calendar by the end of the 16th century, whereas others stayed with the Julian Calendar until the
20th century. The United Kingdom and their colonies switched on September 2, 1752. They already had to delete 11 days.
The function week() returns the number of the week which contains the day numbered nd. The argument *year is set with the year that contains
(the greater part of) the week. The weeks are numbered per year starting with week 1, which is the first week in a year that includes more
than three days of the year. Weeks start on Monday. This function is defined for Gregorian Calendar only.
The function weekday() returns the weekday (Mo = 0 .. Su = 6) of the day numbered nd.
The structure date is defined in <calendar.h>. It contains these fields:
int y; /* year (0000 - ????) */
int m; /* month (1 - 12) */
int d; /* day of month (1 - 31) */
The year zero is written as "1 B.C." by historians and "0" by astronomers and in this library.
SEE ALSO ncal(1), strftime(3)STANDARDS
The week number conforms to ISO 8601: 1988.
HISTORY
The calendar library first appeared in FreeBSD 3.0.
AUTHORS
This manual page and the library was written by Wolfgang Helbig <helbig@FreeBSD.org>.
BUGS
The library was coded with great care so there are no bugs left.
BSD November 29, 1997 BSD