Home » SQL & PL/SQL » SQL & PL/SQL » how to find previous day
how to find previous day [message #209836] Mon, 18 December 2006 01:27 Go to next message
sandeepshahare
Messages: 20
Registered: December 2006
Location: pune
Junior Member
if i give input 18/12/2006
how i can get 17/12/2006
please provide sql query.
Re: how to find previous day [message #209838 is a reply to message #209836] Mon, 18 December 2006 01:31 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Subtract 1 from the input date.
Re: how to find previous day [message #209863 is a reply to message #209836] Mon, 18 December 2006 03:49 Go to previous message
venurajkumar
Messages: 4
Registered: December 2006
Location: chennai
Junior Member
in the below you can give the date as input to get the previous day output

select to_date('&date')-1 from dual;
Previous Topic: How to get the Column list of a table in run time
Next Topic: How to create/use composite keys.
Goto Forum:
  


Current Time: Fri Dec 09 13:35:16 CST 2016

Total time taken to generate the page: 0.33495 seconds