• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Max(Date)

 
kalyan
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i wanna select the maximum date from the database.
my database is MYSQL and i access my database using JSP.
I tried the following the query
select Max(WeeklyDate) from tblWeeklyReport;
Weekly date is a coloumn in the table tblWeeklyReport.
but it's giving the following error
coloumn not found
so cud someone suggest me as to how to retrieve the maximum date from the dates already stored in the database thru JSP.
 
Madhav Lakkapragada
Ranch Hand
Posts: 5040
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"kalyan"
your name deosn't agree with the javaranch guidelines. Please take a moment and re-register after reviewing the guidelines at http://www.javaranch.com/name.jsp
thanks for your cooperation.
- satya
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic