I am guessing, as I have not used oracle perl, that you need to explicitly concatenate, like '||' or '+'.
Between is not your friend, since it gets both end points. In dodging this, you added code, and in return, you might miss something between 235959 and 000000, if timestamps have factions. It snares the unwary all the time. Nobody has the guts to do "dt between a and b and dt != b" !
Time goes to zero by default.
Decide which end point is included and which is not. Usually one keeps the first instant of the day with the day, so:
Hi All,
I'm still a newbie in perl programming. I have a data below say in test.tmp
The output in test.tmp will be the same data as above sample in test.tmp . So after i get all the 4th column data within the range of month and year i need, then i will use the foreach () code to execute... (1 Reply)
Hi,
I need to search email files by date & time range in email files.
The timezone is not important.
Can someone plz advise how i can do this ?
For e.g A user can specify only
A single date
A date range
date & time range
Below is part of the email file. (4 Replies)
Hi Guys,
Can someone please help me on adding/inserting a variable to an sql scipt? Basically I want to assign today's date. As shown below..
set head off;
set linesize 300;
set pagesize 200;
spool /opt/oracle/temp/output.txt
select value,count(*) as totalcount from pmowner.pinpebasev... (11 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)
how can i grep a range?
i have a text file with the following text:
result.log.00:2012/01/02 12:00:07.422 LOG STARTED HERE
N6Kashya29MemoryShieldScheduler_AO_IMPLE, pid=8662/8658,
config=(alertThreshold=10,alertLevel=0,killThreshold=7200,coreThreshold=0,full=1),
deltaTime=0,... (1 Reply)
i need to run one script inside of other, and there is some terms
- main script in scheduled in cron for everyday runing every 5min
- i need to run /tmp/script2.sh after first 3 days in month
- i need to run /tmp/script2.sh from 7-9AM, main script is runining all day
all recommendations are... (1 Reply)
Hello All,
This is my first script in PERL. Hence require your help in moving further.
I have a script which should populate the values for Today, Yesterday output.
For which I use timeFrame as a variable to obtain the time in hrs:mm as 10:00.
All I want is, I want my timeFrame to start... (4 Replies)
Hi
I am looking to automate the process in PERL of allocating IP addresses from a set range of addresses (for example a /22 network 10.10.224.1 - 10.10.227.254)
I am able to query the IP addresses that are already in use in the above range, which will produce me a list like this for example... (3 Replies)
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
LEARN ABOUT BSD
date
DATE(1) General Commands Manual DATE(1)NAME
date - print and set the date
SYNOPSIS
date [-nu] [-d dst] [-t timezone] [yymmddhhmm [.ss] ]
DESCRIPTION
If no arguments are given, the current date and time are printed. Providing an argument will set the desired date; only the superuser can
set the date. The -d and -t flags set the kernel's values for daylight savings time and minutes west of GMT. If dst is non-zero, future
calls to gettimeofday(2) will return a non-zero tz_dsttime. Timezone provides the number of minutes returned by future calls to gettimeof-
day(2) in tz_minuteswest. The -u flag is used to display or set the date in GMT (universal) time. yy represents the last two digits of
the year; the first mm is the month number; dd is the day number; hh is the hour number (24 hour system); the second mm is the minute num-
ber; .ss is optional and represents the seconds. For example:
date 8506131627
sets the date to June 13 1985, 4:27 PM. The year, month and day may be omitted; the default values will be the current ones. The system
operates in GMT. Date takes care of the conversion to and from local standard and daylight-saving time.
If timed(8) is running to synchronize the clocks of machines in a local area network, date sets the time globally on all those machines
unless the -n option is given.
FILES
/usr/adm/wtmp to record time-setting. In /usr/adm/messages, date records the name of the user setting the time.
SEE ALSO gettimeofday(2), utmp(5), timed(8),
TSP: The Time Synchronization Protocol for UNIX 4.3BSD, R. Gusella and S. Zatti
DIAGNOSTICS
Exit status is 0 on success, 1 on complete failure to set the date, and 2 on successfully setting the local date but failing globally.
Occasionally, when timed synchronizes the time on many hosts, the setting of a new time value may require more than a few seconds. On
these occasions, date prints: `Network time being set'. The message `Communication error with timed' occurs when the communication between
date and timed fails.
BUGS
The system attempts to keep the date in a format closely compatible with VMS. VMS, however, uses local time (rather than GMT) and does not
understand daylight-saving time. Thus, if you use both UNIX and VMS, VMS will be running on GMT.
4th Berkeley Distribution March 24, 1987 DATE(1)