getString for DateTime returns only Date
Brought to you by:
jeffssmith1
I was assumed calling getString() on a MySQL DateTime object would return the Date&Time, but it only returned the Date. This caused problems with display and compareTo in my application. I fixed the problem as described below.
in SQLResults.java: replace
// else if ((o instanceof Date) || (o instanceof Timestamp))
// return("" + getDate(row, col));
with:
else if ((o instanceof Date))
return("" + getDate(row, col));
else if ((o instanceof Timestamp))
return("" + getTimestamp(row, col));
-Scott Forbes
sforbes_982@comcast.net
Logged In: YES
user_id=534373
Originator: NO
Fixed. Thanks for bringing this bug to my attention.
-Jeff Smith