08-28-2001
Except if you run it on the 1st, then 1-2 = -1. Oops.
A portable solution is to convert the current date to a julian value, subtract 2 and then convert back to a gregorian value. A script to convert to/from julian date is here:
http://droflet.net/julian.txt
Last edited by PxT; 08-28-2001 at 03:49 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
How can i change date value to date value - 1 in unix ?
I mean sysdate to sysdate -1.
Can anyone throw some light on that ?
cheers,
gopskrish (2 Replies)
Discussion started by: gopskrish
2 Replies
2. UNIX for Dummies Questions & Answers
Dear
I check script written in Unix commands and i face misunderstanding in date format.
the format is ( sysdate -p -f%d/%m/%Y ). can you told me what is ( -p and
-f ) means. and can you write sample for this. (1 Reply)
Discussion started by: abu_hassan
1 Replies
3. UNIX for Dummies Questions & Answers
I need to automate the creation of a file. It needs to have the date of the previous day. In sqlplus we use sysdate -1 but I checked the man page for date and didn't find a similar command. This is what I use for creating a file for the current date:
rciind`date '+%m%d%Y'`.txt
What do I... (1 Reply)
Discussion started by: kskywr
1 Replies
4. UNIX for Dummies Questions & Answers
Hi,
There is file on UNIX server named as fd40568-07082009.txt which get FTP'ed to UNIX on a daily basis. 07082009 of fd40568-07082009.txt represents the system date. This type of .txt gets FTP on a daily basis.
My requirement is to rename the fd40568-07082009.txt to fd40568-07072009.txt... (2 Replies)
Discussion started by: rahulbahulekar
2 Replies
5. Shell Programming and Scripting
Hi,
I need to append the current system date and time in my file which are being taken a backup by my shell script .so i added the following line in by .profile
SYSDATE="$( date '+%d/%B/%Y/%S' )"
export SYSDATE
But it's a constant one rather then a sync with my system date ,so how can i do... (10 Replies)
Discussion started by: malickhat
10 Replies
6. Shell Programming and Scripting
I am use unix shell script to called an sql Script to query data in my shell program.
sqlplus -S /nolog @update.sql
but my script on function "sysdate" not work !!
Could you tel me,How can i use function "sysdate" on unix or can replace the other function in my script to get data in system... (5 Replies)
Discussion started by: krai
5 Replies
7. Shell Programming and Scripting
Hi Guys,
I wanted to create an Unix Shell Script that should fetch a particular string from a text file on a particular date.
We all know Oracle generates alert logs for each and every day for every actions in the database.
I have an alert log file now where it contains for about a months... (4 Replies)
Discussion started by: raja_dba
4 Replies
8. UNIX for Dummies Questions & Answers
How do i insert the sysdate in the below xml file? This has to happen dynamically, meaning everytime the script runs, it shud put 2 sysdates in the below xml marked in red ...format is YYYY-MM-DD
<?xml version="1.0" encoding="UTF-8"?>
<Package>
<LOCALE>en_US</LOCALE>
<User... (2 Replies)
Discussion started by: saggiboy10
2 Replies
9. Shell Programming and Scripting
Looking for help.
I need help in the grep ( alternative) to filter out the a keyword from the logfile for a time period of sysdate -1.
My logfile looks like:
####<Sep 7, 2014 3:46:55 PM PDT> <Warning> <Management> <hostname> <> < ExecuteThread:
####<Sep 15, 2014 2:51:05 AM PDT>... (1 Reply)
Discussion started by: jjoy
1 Replies
10. Shell Programming and Scripting
I have a file from which I need to filter out certain lines when field 17 is less than sysdate. The file has date in YYYYMMDD HH:MI:SS format.
Sample file is as below:
PRUM,67016800 ,CC ,C1,67016800 ,00,Y,Y,2 ,US,BX,BOX ... (5 Replies)
Discussion started by: mady135
5 Replies
LEARN ABOUT DEBIAN
nqs2pbs
nqs2pbs(1B) PBS nqs2pbs(1B)
NAME
nqs2pbs - convert NQS job scripts to PBS
SYNOPSIS
nqs2pbs nqs_script [pbs_script]
DESCRIPTION
This utility converts a existing NQS job script to work with PBS and NQS. The existing script is copied and PBS directives, #PBS , are
inserted prior to each NQS directive #QSUB or #@$ , in the original script.
Certain NQS date specification and options are not supported by PBS. A warning message will be displayed indicating the problem and the
line of the script on which it occurred.
If any unrecognizable NQS directives are encountered, an error message is displayed. The new PBS script will be deleted if any errors
occur.
OPERANDS
nqs_script
Specifies the file name of the NQS script to convert. This file is not changed.
pbs_script
If specified, it is the name of the new PBS script. If not specified, the new file name is nqs_script.new .
NOTES
Converting NQS date specifications to the PBS form may result in a warning message and an incompleted converted date. PBS does not support
date specifications of "today", "tomorrow", or the name of the days of the week such as "Monday". If any of these are encountered in a
script, the PBS specification will contain only the time portion of the NQS specification, i.e. #PBS -a hhmm[.ss]. It is suggested that
you specify the execution time on the qsub command line rather than in the script.
Note that PBS will interpret a time specification without a date in the following way:
- If the time specified has not yet been reached, the job will become eligible to run at that time today.
- If the specified time has already passed when the job is submitted, the job will become eligible to run at that time tomorrow.
PBS does not support time zone identifiers. All times are taken as local time.
SEE ALSO
qsub(1B)
Local nqs2pbs(1B)