Inserting value in SQL Server’s datetime by java.sql.Timstamp
Posted on: April 8, 2007
- In: Java
- 6 Comments
This post has been moved to: http://www.pakzilla.com/2007/04/08/inserting-value-in-sql-server%e2%80%99s-datetime-by-javasqltimstamp/
6 Responses to "Inserting value in SQL Server’s datetime by java.sql.Timstamp"
November 20, 2007 at 9:16 pm
Uh….according to the javadoc for java.sql.Timestamp the ToString function returns a String object in yyyy-mm-dd hh:mm:ss.fffffffff format.
So the sqlTime.toString() function should be sufficient, it works for me with mysql.
November 20, 2007 at 9:18 pm
Silly me, I see now that you are using the java.sql.Time and not Timestamp. I’m so used to seeing Timestamp I just glossed over that part. Good example of how to use the SimpleDateFormat. I never did understand how to use it just by looking at the javadoc.
October 30, 2008 at 10:35 pm
Muy buen Dato estimado Amigo, estaba teniendo problemas, por que necesitaba conocer fecha y hora de transaccion.
Gracias
December 22, 2008 at 7:06 am
I think this code should be enough…
public static Timestamp getTodayTimestamp ()
{
Calendar calendar=Calendar.getInstance();
Timestamp timeStamp = new Timestamp(calendar.getTimeInMillis());
return timeStamp;
}
May 12, 2007 at 1:51 pm
Hi
that works a treat… thanks very much…
dates are a pain … and dates between java and sql are worse…
this code did the business for me thanks