|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Date Query
Post 302488456 by theref on Monday 17th of January 2011 08:09:23 AM
01-17-2011
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi there,
I am trying to do the following in Unix (Solaris 2.7):
1...Find the actual date 7 days ago in format (dd-mmm-yyyy) and with the weekday prefably,
2...Find the date 5 days after the above in the same format.
How can I do this in Unix instead of accessing our Oracle database and... (5 Replies)
Discussion started by: csong2
5 Replies
2. UNIX for Dummies Questions & Answers
Good day folks,
This is my first post on this board and I thank you in advance for helping me with this issue.
Any idea how I can synchronize server time with another timeserver but have my server lag behind by 2 seconds?
Meaning...I need a simple unix script that I can run as crone that... (2 Replies)
Discussion started by: franklo
2 Replies
3. Shell Programming and Scripting
Hi
Do you have any pointers how to validate numbers (not to contain alphabets and special characters) and date(MM/DD/YYYY) format.
I used following regular expression to validate integer, which is not working in the default shell:
nodigits="$(echo $testvalue | sed 's/]//g')"
... (4 Replies)
Discussion started by: alok_jax
4 Replies
4. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
5. Shell Programming and Scripting
Hi,
I wrote a simple shell script which accepts the input value yearmonth in the format YYYYMM and displays the date as YYYY-MM-DD.Day will be 01 always.Please find the code below
#!/bin/ksh
export yearmonth_date=$1
print_usage() {
echo "usage: ${0##*/} <yearmonth_date> \n" \
... (1 Reply)
Discussion started by: kavithakuttyk
1 Replies
6. Shell Programming and Scripting
When I write
Select date_field from TableA fetch first row only
I am getting the output as 09/25/2009.
I want to get the output in the below format
2009-09-25 i.e., MM-DD-YYYY. Please help (7 Replies)
Discussion started by: dinesh1985
7 Replies
7. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
8. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
9. Shell Programming and Scripting
Dear all,
I have 2 questions.
I have a file with many rows which has date of the format YYYYMMDD.
1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too.
2. After converting the date to... (10 Replies)
Discussion started by: 2001.arun
10 Replies
10. Shell Programming and Scripting
Hi,
I am trying to capture the total run time of a script which contains SQL's by providing date command in top & bottom, it displaying both the times same in top & bottom.However the time in the sql connection is different.Please help.
OS - LINUX
Shell - ksh
printf "Script Started at... (3 Replies)
Discussion started by: nag_sathi
3 Replies
LEARN ABOUT DEBIAN
nnstats
NNSTATS(1m) NNSTATS(1m) NAME
nnstats - display nnmaster collection and expire statistics SYNOPSIS
nnstats [ -lt ] [ -d month day ] [ -m month ] [ logfile ]... DESCRIPTION
nnstats will extract the collection (C) and expiration (X) entries from the log file and calculate total and average number of articles, groups and elapsed time per day, per month, or for the duration of the whole log file. Normally only a summary for the specified period is printed. If -l is specified, the statistics for each day in the period is also printed, and if -t is specified the summary is not printed. Normally the statistics is collected for all days in the log files (or the current log file if one is not specified). If "-m month" is specified, the statistics for that month is calculated. The month is specified in normal date notation, i.e. a capital- ized three letter abbreviation like Jan, Feb, ... If "-d month day" is specified, the statistics for that date only is calculated and printed. FILES
../Log The log file SEE ALSO
nn(1), nnusage(1M), nnadmin(1M), nnmaster(8) NOTES
If nnmaster is run with options -LCX, nnstats will not work, because the necessary entries are not written to the log file. AUTHORS
Mark Moraes <moraes@csri.toronto.edu> Kim F. Storm <storm@texas.dk> 4th Berkeley Distribution Release 6.6 NNSTATS(1m)