Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle min function

 
Manon Baratt
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, lack of sleep can make one make stupid mistakes. It is working correctly.:-)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic