excel vba - How to get a datetime value from an excelsheet in java? -

excel vba - How to get a datetime value from an excelsheet in java? -

when trying read datetime value such 10/1/2014 8:47:10 am excel sheet using poi library code

row.getcell(3).getdatecellvalue();

i wed oct 01 08:47:10 ist 2014. need convert 2014-11-20 16:23:16 in order store database.how convert it?

public static string getformateddate(final date date) { simpledateformat myformat = new simpledateformat("yyyy-mm-dd hh:mm:ss"); homecoming myformat.format(date); }

use simpledateformat

java excel-vba