Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets 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.:-)
 
I agree. Here's the link: http://aspose.com/file-tools
 
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