This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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.:-)
 
Consider Paul's rocket mass heater.
 
subject: oracle min function
 
Similar Threads
check Input array null or empty
Performance Issue
Performance Issue[JDBC ]
on checking validity of input. problem on my if-else.
SQL for lowest