[SOLVED] SimpleDateFormat apparently not working for mySQL

mfoley · 01-01-2023, 12:06 PM

I have a mySql table column defined as datetime. I'm trying to display this in my java program using:

Code:

SimpleDateFormat mmddyyyy = new SimpleDateFormat("MM/dd/yyyy h:mm a");
bidDate = rs.getDate("bidDate");

System.out.println(mmddyyyy.format(bidDate));

The actual database date is 2022-12-19 14:38, but the above displays as "12/19/2022 12:00 A". If I remove the mmddyyy format and display the raw database value 'System.out.println(bidDate);' it shows only "2022-12-19", no time component. If I do rs.getString("bidDate"), the String is displayed as 2022-12-19 14:38:00.

I've been showing MS SQLserver datetimes this way for over 10 years w/o problem. What needs to be done differently with MySql?

TB0ne · 01-01-2023, 04:55 PM

Quote:

Originally Posted by mfoley

I have a mySql table column defined as datetime. I'm trying to display this in my java program using:

Code:

SimpleDateFormat mmddyyyy = new SimpleDateFormat("MM/dd/yyyy h:mm a");
bidDate = rs.getDate("bidDate");
System.out.println(mmddyyyy.format(bidDate));

The actual database date is 2022-12-19 14:38, but the above displays as "12/19/2022 12:00 A". If I remove the mmddyyy format and display the raw database value 'System.out.println(bidDate);' it shows only "2022-12-19", no time component. If I do rs.getString("bidDate"), the String is displayed as 2022-12-19 14:38:00. I've been showing MS SQLserver datetimes this way for over 10 years w/o problem. What needs to be done differently with MySql?

I typically use TIMESTAMP if I need the date and time (with seconds/etc.), instead of datetime. Might be worth a try to modify the table and try it, if you're just starting with this project.

NevemTeve · 01-01-2023, 10:19 PM

Try this:

Code:

bidDate = rs.getTimestamp("bidDate");

mfoley · 01-24-2023, 11:26 AM

TB0ne: I've long used datetime on SQL Server and rs.getDate() to retrieve the value in Java. However, using NevemTeve's suggested rs.getTimestamp() makes sense. getDate() would imply that your just getting the date, even though with SQL Server you do get date and time. getTimestamp() implies both date and time.

NevemTeve's suggestion worked. I think I'll leave the database datatype as datetime since all other such tables with datestamps are that way.