Sponsored Content
Top Forums UNIX for Advanced & Expert Users Getting sysdate - 2 by an unix command Post 6016 by PxT on Tuesday 28th of August 2001 11:57:24 AM
Old 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

How to get sysdate -1

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

sysdate -p -f%d/%m/%Y

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

sysdate -1 in unix

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

Rename FILE with sysdate-1

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

Sysdate setting in .profile

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

How to use sql "sysdate" in unix?

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

Extracting Sysdate-1 ORA Errors - Can you help me in this UNIX Script?

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

Inserting sysdate into the XML!!

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

Grep the logfile for sysdate-1

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

Need to filter data based on sysdate

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
STRIPCHART(5)							File Formats Manual						     STRIPCHART(5)

NAME
stripchart - draws diagrams from data with PHP SYNOPSIS
The script is expected to be called as a CGI script but also works from the command line. DESCRIPTION
Stripchart prepares a series of diagrams directly from raw data. It is handy for web pages that need some graphics without too much over- head. OPTIONS
-i input FILE name of input data file (mandatory) -o output FILE name of output .gif file (default: STDOUT) -O output FILE name of output .gif file, also dumps to STDOUT -f from TIME stripchart with data starting at TIME (default: 24 hours ago) -t to TIME stripchart with data ending at TIME (default: now) -r range RANGE stripchart data centered around "from" time the size of RANGE (overrides -t) -l last LINES stripchart last number of LINES in data file (overrides -f and -t and -r) -T title TITLE title to put on graphic (default: FILE RANGE) -x column X time or "x" column (default: 2) -y column Y value or "y" column (default: 3) -Y column Y' overplot second "y" column (default: none) -b baseline VALUE overplot baseline of arbitrary value VALUE -B baseline-avg overrides -b, it plots baseline of computed average -d dump low VALUE ignore data less than VALUE -D dump high VALUE ignore data higher than VALUE -v verbose puts verbose runtime output to STDERR -L log makes y axis log scale -c colors "COLORS" set gnuplot colors for graph/axisnts/data (default: "xffffff x000000 xc0c0c0 x00a000 x0000a0 x2020c0" in order: bground, axisnts, grids, pointcolor1,2,3) -C cgi output CGI header to STDOUT if being called as CGI -s stats turn extra plot stats on (current, avg, min, max) -j julian times time columns is in local julian date (legacy stuff) -V version print version number and exit -h help display this help NOTES
* TIME either unix date, julian date, or civil date in the form: YYYY:MM:DD:HH:MM (year, month, day, hour, minute) If you enter something with colons, it assumes it is civil date If you have a decimal point, it assumes it is julian date If it is an integer, it assumes it is unix date (epoch seconds) If it is a negative number, it is in decimal days from current time (i.e. -2.5 = two and a half days ago) * All times on command line are assumed to be "local" times * All times in the data file must be in unix date (epoch seconds) * RANGE is given in decimal days (i.e. 1.25 = 1 day, 6 hours) * if LINES == 0, (i.e. -l 0) then the whole data file is read in * columns (given with -x, -y, -Y flags) start at 1 * titles given with -T can contain the following key words which will be converted: FILE - basename of input file RANGE - pretty civil date range (in local time zone) the default title is: FILE RANGE AUTHORS
Matt Lebofsky 2.21 November 2002 STRIPCHART(5)
All times are GMT -4. The time now is 05:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy