Loading

How to convert date formt from MM/dd/yyyy to yyyy/MM/dd ?

Venkatesh K H

9y1.6kJSP

I am sending MM/dd/yyyy format from frontend to the mysql workbench database but its not storing the date as MM/dd/yyyy format. then how to convert this to yyyy/MM/dd in jsp.

I have tried this code but getting error please reply soon its urgent.

<%String start_date = "MAY-08-2017";

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");

Date d = formatter.parse(start_date);

System.out.println(d);

System.out.println(formatter.format(d));%>

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Venkatesh K H9y ago
Data type declared as date
rajeev kumar9y ago
1st of all set your tabel of date culumn datatype as date and use

<%#Eval("createdon", "{0:yyyy-MM-dd}") %>