Re: Setting sysdate's timestamp

I appreciate your help.

Muru

• Rajagopal Venkataramany <rajagopalvr_at_excite.com> wrote:
  > Murugesan,
  >
  > If u want to change the sysdate and time that
  > oracle returns,
  > u have to change the operating system date and
  > time for this.
  >
  > If u want to change the timestamp for a particular
  > row(s) then
  > use the to_date(<input_date>,'mm/dd/yyyy
  > hh:mi:ss') where input_date
  > is the date that u want it to be set.
  >
  > Hope my understanding of ur requirement is
  > correct...
  >
  > Regards
  > Rajagopal Venkataramany
  >
  > On Sun, 27 Aug 2000 16:53:31 -0800,
  > ORACLE-L_at_fatcity.com wrote:
  >
  > > Hello lists,
  > >
  > > How to set the sysdate's timestamp in oracle? For
  > > example I want to change it from 08/15/00
  > 02:30:15 to
  > > 08/27/00 04:30:30.
  > >
  > > Any help would be highly appreciated.
  > >
  > > TIA
  > > Muru
  > >
  > >
  > __________________________________________________
  > > Do You Yahoo!?
  > > Yahoo! Mail - Free email you can access from
  > anywhere!
  > > http://mail.yahoo.com/
  > > --
  > > Author: Murugesan Balakrishnan
  > > INET: mail_oracle_at_yahoo.com
  > >
  > > 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: ListGuru_at_fatcity.com (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).
  > >
  >
  >
  > Regards
  > Rajagopal Venkataramany
  >
  >
  >
  >
  >
  >

  ---

  
  > Say Bye to Slow Internet!
  > http://www.home.com/xinbox/signup.html
  >
  > --
  > Author: Rajagopal Venkataramany
  > INET: rajagopalvr_at_excite.com
  >
  > 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: ListGuru_at_fatcity.com (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).
  >
  

  ---