Re: Change sysdate in database to a future date
You can just ALTER SYSTEM SET FIXED_DATE = 'DD-MON-YY'; without setting in ini.ora. Later set it to none will bring it back to os time. Joan > Hallas John wrote: > > Or use the init.ora parameter FIXED_DATE to set the database time > only. > John > > -Original Message- > From: kranti pushkarna [mailto:[EMAIL PROTECTED]] > Sent: 07 December 2001 04:30 > To: Multiple recipients of list ORACLE-L > Subject: RE: Change sysdate in database to a future date > > change the date of the system on which the database resides > > -Original Message- > Sent: Friday, December 07, 2001 9:15 AM > To: Multiple recipients of list ORACLE-L > > Hi Gurus, > > I need to change the sysdate in the database to a future date. Does > anyone > know the command to do it ? Please advise. Thanks. > > Regds, > New Bee > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: CHAN Chor Ling Catherine (CSC) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: kranti pushkarna > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > = > This electronic message contains information from the mmO2 plc Group > which may be privileged or confidential. The information is intended > to be > for the use of the individual(s) or entity named above. If you are not > the > intended recipient be aware that any disclosure, copying, distribution > or > use of the contents of this information is prohibited. If you have > received > this electronic message in error, please notify us by telephone or > email > (to the numbers or address above) immediately. > = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change sysdate in database to a future date
Check out DB init parameter FIXED_DATE. It allows you to set the date to either in the future or in the past. When you select SYSDATE, it will get the date from this parameter instead of the true system date. -Original Message- Sent: Thursday, December 06, 2001 10:45 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tieu, Linh K. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change sysdate in database to a future date
Title: RE: Change sysdate in database to a future date Or use the init.ora parameter FIXED_DATE to set the database time only. John -Original Message- From: kranti pushkarna [mailto:[EMAIL PROTECTED]] Sent: 07 December 2001 04:30 To: Multiple recipients of list ORACLE-L Subject: RE: Change sysdate in database to a future date change the date of the system on which the database resides -Original Message- Sent: Friday, December 07, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
RE: Change sysdate in database to a future date
Dear All,
I've found the answer. I manage to use the "date" command in root account to
change the date. Thanks.
Regds,
New Bee
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Friday, December 07, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Change sysdate in database to a future
date
Hi Unix Gurus,
Does anyone know how to change the date of the Unix system ?
I am running my
database server in Unix 2.6. Thanks.
Regds,
New Bee
PS. Thank you, Kranti, for your reply.
-Original Message-
From: kranti pushkarna
[mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Change sysdate in
database to a future
date
change the date of the system on which the
database resides
-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need to change the sysdate in the database
to a future
date. Does anyone
know the command to do it ? Please advise.
Thanks.
Regds,
New Bee
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
538-5051 FAX: (858)
538-5051
San Diego, California-- Public
Internet access /
Mailing Lists
To REMOVE yourself from this mailing list,
send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru')
and in
the message BODY, include a line containing:
UNSUB ORACLE-L
(or the name of mailing list you want to be
removed from).
You may
also send the HELP command for other
information (like
subscribing).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: kranti pushkarna
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
538-5051 FAX: (858)
538-5051
San Diego, California-- Public
Internet access /
Mailing Lists
To REMOVE yourself from this mailing list,
send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru')
and in
the message BODY, include a line containing:
UNSUB ORACLE-L
(or the name of mailing list you want to be
removed from).
You may
also send the HELP command for other
information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
538-5051
San Diego, California-- Public Internet access /
Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP co
RE: Change sysdate in database to a future date
Hi Unix Gurus, Does anyone know how to change the date of the Unix system ? I am running my database server in Unix 2.6. Thanks. Regds, New Bee PS. Thank you, Kranti, for your reply. -Original Message- From: kranti pushkarna [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Subject:RE: Change sysdate in database to a future date change the date of the system on which the database resides -Original Message- Sent: Friday, December 07, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Change sysdate in database to a future date
SYSDATE is determined by the operating system's date. You can't change the current date and time in Oracle; you have to change it at the OS level. If, however, your aim is to determine things like "what's the date one week from today", then you can use Oracle's date arithmetic functionality (eg, "SYSDATE + 7" to determine the date one week from today). hth -arn >>> [EMAIL PROTECTED] 7/12/2001 14:45:21 >>> This message has been scanned by MAILSweeper. Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Change sysdate in database to a future date
change the date of the system on which the database resides -Original Message- Sent: Friday, December 07, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
