mallox007 / sqlsheet

Automatically exported from code.google.com/p/sqlsheet
0 stars 0 forks source link

ResultSet.getDate nyi #11

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I am not sure if this should be categorized as issue or an additional feature.
If you have a date formatted cell, the ResultSet.getString method returns the 
representation value of String and not the date value in standard format.

Consider a date "22. Dezember 1963" - a german localized date then you get 
exact string. When it should return the date which can be used directly to 
store in Database. 

Now there is another method getTimeStamp to return date from resultset but it 
throws null pointer exception if the cell is empty. This should be null value 
instead.

Original issue reported on code.google.com by hanuma...@gmail.com on 6 Aug 2013 at 2:53

GoogleCodeExporter commented 9 years ago
Please give a sample spreadsheet + expected result

Original comment by vasilievip on 6 Aug 2013 at 4:31