Subramanian,
You might consider storing your time fields as long in the database ( milliseconds)
The reason being is that different
databases can handle different object mappings. ( Timestamp will map to one thing in
Oracle and another in SQLServer)
You may also encounter driver issues as we did using Timestamp in SQLServer.
Chris
-----Original Message-----
From: subramanian Athimoolam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:42 AM
To: [EMAIL PROTECTED]
Subject: Re: java.sql.Date problem
hi
data inserting time give the following formate
java.util.Date date = new java.util.Date();
java.text.DateFormat dateFormat = new
java.text.SimpleDateFormat("dd/MM/yyyy hh:mm:ss");
String formattedDate = dateFormat.format(date);
INSERT INTO msgdf
VALUES("+tid1+",'"+Value+"','"+Name+"',"+k+",'"+u+"',TO_DATE('"
+formattedDate + "','DD-MM-YY
HH24:MI:SS'),'"+Top+"',"+co+",'"+"A"+"',TO_DATE('" +formattedDate+
"','DD-MM-YY HH24:MI:SS'),
then you will retirve the formate[ see my previous mail]
subu
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
