This week's giveaway is in the Threads forum.
We're giving away four copies of Java Concurrency Live Lessons and have Doug Schmidt on-line!
See this thread for details.
Win a copy of Java Concurrency Live Lessons this week in the Threads forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Max(Date)  RSS feed

 
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
Boost this thread!