• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to update date in mssql 2k

 
amit taneja
Ranch Hand
Posts: 813
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 4121
IntelliJ IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This belongs in the JDBC forum... moving it there...
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35276
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Amit,
Use a prepared statement. Then you don't have to worry about the formatting and your SQL is not database specific:
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic