datetime JDBC date conversionThis is a discussion on datetime JDBC date conversion within the JDBC JAVA forums in Framework and Interface Programming category; I am writing a datetime field value to MS SQL Server 7 in the following manner via a stored procedure: // item to be written is originally a java.util.Date object java.util.Date fromDate; // I'm inserting it here into the database cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); // the record in the database appears as follows - as I wanted it to.. 12/23/2004 4:30:43 AM The problem is reading the date FROM the database back into ANY type of Java Date-related object. No matter what I try, the hour/minutes/seconds are not returned, and I desperately need the hour and minutes. I don't want to ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
10-26-2004, 02:51 PM
| |||
| |||
 datetime JDBC date conversion I am writing a datetime field value to MS SQL Server 7 in the following manner via a stored procedure: // item to be written is originally a java.util.Date object java.util.Date fromDate; // I'm inserting it here into the database cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); // the record in the database appears as follows - as I wanted it to.. 12/23/2004 4:30:43 AM The problem is reading the date FROM the database back into ANY type of Java Date-related object. No matter what I try, the hour/minutes/seconds are not returned, and I desperately need the hour and minutes. I don't want to store the hours and minutes in another field - it just causes more complications. Does anyone out there know a way to get the ENTIRE date value out of the database?  |
|
#2
10-26-2004, 04:13 PM
| |||
| |||
| Re: datetime JDBC date conversion Hi Are you saying that getTime() returns 00:00:00 ? Posting your the code that tries to retrive this may help! John "billb" <kmilburn@austin.rr.com> wrote in message news:3561fddb.0410261050.6c8bafba@posting.google.c om... > I am writing a datetime field value to MS SQL Server 7 in the following manner > via a stored procedure: > > // item to be written is originally a java.util.Date object > java.util.Date fromDate; > // I'm inserting it here into the database > cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); > > // the record in the database appears as follows - as I wanted it to.. > 12/23/2004 4:30:43 AM > > The problem is reading the date FROM the database back into ANY type of Java > Date-related object. No matter what I try, the hour/minutes/seconds are not > returned, and I desperately need the hour and minutes. I don't want to store > the hours and minutes in another field - it just causes more complications. > Does anyone out there know a way to get the ENTIRE date value out of the database? |
|
#3
10-26-2004, 06:10 PM
| |||
| |||
| Re: datetime JDBC date conversion billb wrote: > I am writing a datetime field value to MS SQL Server 7 in the following manner > via a stored procedure: > > // item to be written is originally a java.util.Date object > java.util.Date fromDate; > // I'm inserting it here into the database > cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); > > // the record in the database appears as follows - as I wanted it to.. > 12/23/2004 4:30:43 AM > > The problem is reading the date FROM the database back into ANY type of Java > Date-related object. No matter what I try, the hour/minutes/seconds are not > returned, and I desperately need the hour and minutes. I don't want to store > the hours and minutes in another field - it just causes more complications. > Does anyone out there know a way to get the ENTIRE date value out of the database? Are you sure you tried getTimestamp()? Joe Weinstein at BEA |
|
#4
10-27-2004, 10:55 PM
| |||
| |||
| Re: datetime JDBC date conversion billb wrote: > I am writing a datetime field value to MS SQL Server 7 in the following manner > via a stored procedure: > > // item to be written is originally a java.util.Date object > java.util.Date fromDate; > // I'm inserting it here into the database > cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); > > // the record in the database appears as follows - as I wanted it to.. > 12/23/2004 4:30:43 AM > > The problem is reading the date FROM the database back into ANY type of Java > Date-related object. No matter what I try, the hour/minutes/seconds are not > returned, and I desperately need the hour and minutes. I don't want to store > the hours and minutes in another field - it just causes more complications. > Does anyone out there know a way to get the ENTIRE date value out of the database? Convert DATETIME into CHARATER using MS SQL finction is SELECT statement: CONVERT ( VARCHAR( length ), some_datetime_colimn, <style> ) where <style> is magic number which defines format( 120 ~ yyyy-mm-dd HH:mi:ss); get value from ResultSet as string and parse it using java.text.DateFormat.parseDate(...) |
|
#5
10-31-2004, 11:25 PM
| |||
| |||
| Re: datetime JDBC date conversion Hi, Please use the following to construct a full date object from database date field. java.util.Date myDate = new java.util.Date(myResultSet.getTimestamp("myDate"). getTime()); I hope this will help .. Regards, Yasir "billb" <kmilburn@austin.rr.com> wrote in message news:3561fddb.0410261050.6c8bafba@posting.google.c om... > I am writing a datetime field value to MS SQL Server 7 in the following manner > via a stored procedure: > > // item to be written is originally a java.util.Date object > java.util.Date fromDate; > // I'm inserting it here into the database > cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); > > // the record in the database appears as follows - as I wanted it to.. > 12/23/2004 4:30:43 AM > > The problem is reading the date FROM the database back into ANY type of Java > Date-related object. No matter what I try, the hour/minutes/seconds are not > returned, and I desperately need the hour and minutes. I don't want to store > the hours and minutes in another field - it just causes more complications. > Does anyone out there know a way to get the ENTIRE date value out of the database? |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 04:07 PM.
