wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes oracle min function Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "oracle min function" Watch "oracle min function" New topic
Author

oracle min function

Manon Baratt
Ranch Hand

Joined: Jan 30, 2006
Posts: 58
Hi,

Is there a problem with Oracle min function. I am using it to get the min date. I should return 9/2/1997 but I get 10/23/1989.

This is my query:

select min(t.effective_start_date) from assignments t where t.job_id = '1'

Thanks.
Manon Baratt
Ranch Hand

Joined: Jan 30, 2006
Posts: 58
Sorry, lack of sleep can make one make stupid mistakes. It is working correctly.:-)
 
wood burning stoves
 
subject: oracle min function