how to insert date in sqlserver in (yyyy-MM-dd HH:mm:ss) format
843838Mar 30 2007 — edited Feb 27 2008please help how to insert date in sqlserver in (yyyy-MM-dd HH:mm:ss) format, I have tried java.sql.Date but in that case the time portion automatically changed to 00:00:00 and while using java.sql.Timestamp it through me an error as data type mismatch in data base.
I have set data type as datetime in sqlserver instead of timestamp the reason is I have two datetime column in my table and if I use timestamp it will not allow to columns................
thanks in advance
Amit