Message-Id: <10602.115646@fatcity.com> From: Murugesan Balakrishnan Date: Mon, 28 Aug 2000 08:31:16 -0700 (PDT) Subject: Re: Setting sysdate's timestamp I appreciate your help. Muru --- Rajagopal Venkataramany 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(,'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@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@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@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@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@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). > __________________________________________________