Sponsored Content
Full Discussion: How to get sysdate -1
Top Forums UNIX for Dummies Questions & Answers How to get sysdate -1 Post 75905 by gopskrish on Thursday 23rd of June 2005 04:22:50 AM
Old 06-23-2005
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
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Getting sysdate - 2 by an unix command

How can I get an equivalent in unix for the following Oracle SQL command: select sysdate - 2 from dual; Thanks José (4 Replies)
Discussion started by: josecollantes
4 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. Programming

How to get First and Last day of previous month from trunc(sysdate)

Hi Guys, How to get First day of previous month and last day of previous month from trunc(sysdate) using SQL..? Thanks in advance. Br, pinpe (2 Replies)
Discussion started by: pinpe
2 Replies

7. Shell Programming and Scripting

How to replace actual generated date with sysdate?

Hi, currently I've a file with the following content: insert into CD_CARD_TYP (code, description, last_update_by, last_update_date) values ('024', '024', 2, to_date('29-03-2008 05:16:09', 'dd-mm-yyyy hh24:mi:ss')); insert into CD_CARD_TYP (code, description, last_update_by,... (1 Reply)
Discussion started by: jediwannabe
1 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
DATE(1) 						      General Commands Manual							   DATE(1)

NAME
date - print or set the date and time SYNOPSIS
date [-qsu] [[MMDDYY]hhmm[ss]] [+format] OPTIONS
-q Read the date from stdin -s Set the time (implicit for -q or a date string) -u Print the date as GMT -t Use this number of seconds instead of current time EXAMPLES
date # Print the date and time date 0221921610 # Set date to Feb 21, 1992 at 4:10 p.m. DESCRIPTION
With the -q flag or a numeric argument, date sets the GMT time and date. MMDDYY refers to the month, day, and year; hhmmss refers to the hour, minute and second. Each of the six fields must be exactly two digits, no more and no less. date always display the date and time, with the default format for the system. The -u flag request GMT time instead of local time. A format may be specified with a + followed by a printf-like string with the following options: %% % character %A Name of the day %B Name of the month %D mm/dd/yy %H Decimal hour on 2 digits %I Decimal hour modulo 12 on 2 digits %M Decimal minute on 2 digits %S Decimal seconds on 2 digits %T HH:MM:SS %U Decimal week number, Sunday being first day of week %W Decimal week number, Monday being first day of week %X Same as %T %Y Decimal year on 4 digits %Z Time Zone (if any) %a Abbreviated name of the day %b Abbreviated name of the month %c Appropriate date & time (default format) %d Decimal day of the month on 2 digits %e Same as %d, but a space replaces leading 0 %h Same as %b %j Decimal dey of the year on 3 digits %m Decimal month on 2 digits %n Newline character %p AM or PM %r 12-hour clock time with AM/PM %s Number of seconds since the epoch %t Tab character %w Decimal day of the week (0=Sunday) %x Same as %D %y Decimal year on 2 digits SEE ALSO
time(2), ctime(3), readclock(8). DATE(1)
All times are GMT -4. The time now is 01:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy