Please let me know how to get day, month and year in JSP from mysql Date.

you can use the format on the Date

Like
dd = 12
ddd = sun
dddd = sunday

and the same for the month and year

Ever tried the getDate() method of ResultSet, It would give you a java.sql.Date object from the date in your MySQL table.
Extracting Month,Year and Day from it should be trivial then.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.