11-16-2009
Thank you very much.
Can you pls tell me how can I find the current_date+6days date? I mean if I run a script today it should print 22/11/2009.
Important thing is it should work for all the years including leap year.
I need your help for the below activity. (currently it should print the today date)
dat=`date '+%m/%d/20%y'`
partition_date=`date|awk '{print $2$3}'`
new_partition=SAS_AUDIT_$partition_date
echo "The new partition name is "$new_partition""
echo "alter table AUDIT_TRAIL split partition partmax at (to_date('$dat 00:00:00','mm/dd/yyyy hh24:mi:ss')) into (partition
$new_partition,partition partmax);" | sqlplus -s username/pwd
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey everyone, I'm newer than new when it comes to this ksh and scripting stuff, and unix in general. I have been thrown into a task at work that
A: They expect me to come up to speed on,
B: Show I can do this. (Program for the workgroup)
Here's the script, part of it, from the overall... (3 Replies)
Discussion started by: Brusimm
3 Replies
2. UNIX for Dummies Questions & Answers
awk -F^ '{ if ((($1 != "M") && ($5 != "2")) || (($1 != "S") && ($5 != "7"))) print $0}' welcome > welcome1
The "&&" and "||" in the above command is not working with awk.
When I run the above command, the same content of welcome is copied to welcome1 without any difference.
Your reply is... (12 Replies)
Discussion started by: karthickrn
12 Replies
3. Shell Programming and Scripting
I have a function name called help as below
function help
{
echo "Run the script as,"
#echo "$(basename $0) -sod or -eod"
echo "${0##*/} -sod or -eod"
}
and have case stmt which will call this function incase of wrong parameter
but when ever I'm giving wrong... (2 Replies)
Discussion started by: manas_ranjan
2 Replies
4. Shell Programming and Scripting
Hi,
I need to resolve IP to names in a text file. I was thinking of using some unix commands. Ksh.
Text in file contains a lot of these entries:
..
20 6 <166>%ASA-6-302013: Built inbound TCP connection 12690562 for inside2:10.86.6.20/3678 (10.86.6.20/3678) to inside:10.107.22.12/1947... (3 Replies)
Discussion started by: hasselhaven
3 Replies
5. Shell Programming and Scripting
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies
6. Shell Programming and Scripting
Hi,
Can any body please tell me what does -z do in ksh?
I need to understand what does below code do?
FILE_LIST is an array which store multiple number of files...
if } ]]; then
echo "EVDO file not found
fi
I hope I'm clear on my query (3 Replies)
Discussion started by: annybase
3 Replies
7. Solaris
Hi guys,
I am currently receiving the following output in /var/log/syslog and is occurring every second leading to /var directory being full after every 2 days.
Aug 20 17:32:29 opaldn1 sendmail: r7KCOlQm002517: ruleset=check_rcpt, arg1=<postmaster@silverapp6>, relay=, reject=450 4.4.0... (3 Replies)
Discussion started by: Junaid Subhani
3 Replies
8. Shell Programming and Scripting
requirement : I need to read a text file and find out which particular line has highest charcters on it using the shell script.
I tried & was able to find out only for one line. I could not able to find out for the entire the line.
sed -n '10 p' ctstest.sh | wc -w
Please guide me... (5 Replies)
Discussion started by: ramkumar15
5 Replies
9. Shell Programming and Scripting
Hello,
I have used a chunk of ksh script similar to this in many places without any issue:
while :
do
print;
read OPTION?"Enter a number (q to quit): "
expr ${OPTION} + 1 >/dev/null 2>&1
CHECKVAL=$?
if }" != ${OPTION} ]; then
... (2 Replies)
Discussion started by: port43
2 Replies
LEARN ABOUT PHP
datetime.setdate
DATETIME.SETDATE(3) 1 DATETIME.SETDATE(3)
DateTime::setDate - Sets the date
Object oriented style
SYNOPSIS
public DateTime DateTime::setDate (int $year, int $month, int $day)
DESCRIPTION
Procedural style
DateTime date_date_set (DateTime $object, int $year, int $month, int $day)
Resets the current date of the DateTime object to a different date.
PARAMETERS
o $object
-Procedural style only: A DateTime object returned by date_create(3). The function modifies this object.
o $year
- Year of the date.
o $month
- Month of the date.
o $day
- Day of the date.
RETURN VALUES
Returns the DateTime object for method chaining or FALSE on failure.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.0 | |
| | |
| | Changed the return value on success from NULL to |
| | DateTime. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
DateTime.setDate(3) example
Object oriented style
<?php
$date = new DateTime();
$date->setDate(2001, 2, 3);
echo $date->format('Y-m-d');
?>
Procedural style
<?php
$date = date_create();
date_date_set($date, 2001, 2, 3);
echo date_format($date, 'Y-m-d');
?>
The above examples will output:
2001-02-03
Example #2
Values exceeding ranges are added to their parent values
<?php
$date = new DateTime();
$date->setDate(2001, 2, 28);
echo $date->format('Y-m-d') . "
";
$date->setDate(2001, 2, 29);
echo $date->format('Y-m-d') . "
";
$date->setDate(2001, 14, 3);
echo $date->format('Y-m-d') . "
";
?>
The above example will output:
2001-02-28
2001-03-01
2002-02-03
SEE ALSO
DateTime.setISODate(3), DateTime.setTime(3).
PHP Documentation Group DATETIME.SETDATE(3)