Home » SQL & PL/SQL » SQL & PL/SQL » TIMESTAMP-1..HOW??
TIMESTAMP-1..HOW?? [message #19310] Mon, 11 March 2002 10:37 Go to next message
Sabrina
Messages: 76
Registered: February 2002
Member
I have got a timestamp field.
How do i update that field, so that it sets the timestamp field to (timestamp-1)

For example,
MY CURRENT FIELD Looks: 11-MAR-02 02.28.41.498446 PM
I want it to look like: 10-MAR-02 02.28.41.498446 PM

Very urgent,
Thjanks.
Re: TIMESTAMP-1..HOW?? [message #19312 is a reply to message #19310] Mon, 11 March 2002 11:14 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
select date_col -1 from table_name;
Previous Topic: Length of SUM field
Next Topic: Re: Temporary table
Goto Forum:
  


Current Time: Fri Mar 29 07:08:09 CDT 2024