Hello Ranchers,
I am facing a problem in inserting date-time value in a column of type datetime in table of sybase database.
I am collecting datetime in
mm/dd/yyyy hh:mi format in a
string variable. Then i convert that to java.util.Date using SimpleDateFormat.
To insert this date to database i am using a
CallableStatement call to execute the stored procedure in the database. For that, i am using [B]prepareCall[B] of the connection object.
Now i am writing
statement.setDate(columnIndex, new java.sql.Date(utilDate.getTime()) This code executes properly but in the database table, only date value is stored. The time value is not stored and it shows hh:mi as 00:00 only.
I need to store the time value also.
Is my code wrong in case?
Please advise.
Thanks in advance.
[edited to remove empty code tags]
[ August 07, 2005: Message edited by: Jeanne Boyarsky ]