You may do like below, String dateStr = obj.getString(“birthdate”); SimpleDateFormat sdf = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”); Date birthDate = sdf.parse(dateStr); //then user.setBirthdate(birthDate); Hope to help you 🙂
Most database vendors don’t support JDBC 4.2 yet. This specification says that the new java.time-types like LocalDate will/should be supported using the existing methods setObject(…) and getObject(). No explicit conversion is required and offered (no API-change). A workaround for the missing support can be manual conversion as described on the Derby-mailing list. Something like: LocalDate … Read more
This answer is outdated. Continue to Basil Bourque’s answer. java.util.Date date; Timestamp timestamp = resultSet.getTimestamp(i); if (timestamp != null) date = new java.util.Date(timestamp.getTime())); Then format it the way you like.
The Date.parse method is implementation dependent (new Date(string) is equivalent to Date.parse(string)). While this format will be available on modern browsers, you cannot be 100% sure that the browser will interpret exactly your desired format. I would recommend you to manipulate your string, and use the Date constructor with the year, month and day arguments: … Read more
CURRENT_TIMESTAMP is standard ANSI SQL, and so is theoretically one tiny little island of ‘don’t need to change’ amongst your thousands of SQL Server-specific lines of SQL if you ever need to move databases….
In SQL Server 2008 and newer you can cast the DateTime to a Date, which removes the time element. WHERE Orders.OrderStatus=”Shipped” AND Orders.ShipDate >= (cast(GETDATE()-6 as date)) In SQL Server 2005 and below you can use: WHERE Orders.OrderStatus=”Shipped” AND Orders.ShipDate >= DateAdd(Day, Datediff(Day,0, GetDate() -6), 0)
First, you should probably use SYSDATETIME() if you’re looking for more precision. To format your data with milliseconds, try CONVERT(varchar, SYSDATETIME(), 121). For other formats, check out the MSDN page on CAST and CONVERT.
You can’t pass in a function call as an argument to your stored procedure. Instead use an intermediate variable: DECLARE @tmp DATETIME SET @tmp = GETDATE() EXEC DisplayDate @tmp;