Home » SQL & PL/SQL » SQL & PL/SQL » finding latest date in oracle
finding latest date in oracle [message #307669] Wed, 19 March 2008 07:06 Go to next message
mkr_oracle
Messages: 6
Registered: March 2007
Location: chennai
Junior Member


Hi,


i have diffrent dates in current month.


for ex:

10-02-2007

20-02-2007
12-02-2207

So how can i select the above mentioned dates latest date of the day.(latest date is 20-02-2007)

Please help me out
Re: finding latest date in oracle [message #307672 is a reply to message #307669] Wed, 19 March 2008 07:14 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
MAX() is what you need?Pls refer the Oracle docs.You will find all answers to your question.

regards,
Re: finding latest date in oracle [message #307733 is a reply to message #307669] Wed, 19 March 2008 14:04 Go to previous message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
If the dates are stored as strings instead of dates like they should be, look into TO_DATE and MAX.
Previous Topic: Need help with PLSQL query
Next Topic: MAX function
Goto Forum:
  


Current Time: Sun Dec 04 18:42:11 CST 2016

Total time taken to generate the page: 0.08641 seconds