how to update date in mssql 2k

[amit taneja]

hi,

can any body tell me how to update date in ms-sql 2k ..
as it store date in "DD/MM/YYYY" fromat .

so if we make String of above format and then update it or
we update the date object ?
but date format is in other format ? not like the above..?
so what we do to convert to above format ?

kindly write in details


Thanx and Regards,
Amit

[Nathan Pruett]

This belongs in the JDBC forum... moving it there...

[Jeanne Boyarsky]

Amit,
Use a prepared statement. Then you don't have to worry about the formatting and your SQL is not database specific:

"select * from table where field = ?"
preparedStatement.setDate(date);