Saturday, May 3, 2008
How to change the server wide date format
date to your database. even you put the write syntex in your application program and the insert query. Why ?
It is due to server level date settings. As a default your server settings would be in mm/dd/yyyy format, which needs to be changed in the server.
How to do this?
Follow these simple steps...
1. Start -> Control Pannel -> Reginal settings ->Customize
after that go the date format and set the short date = dd/mm/yyyy
and long date format = dd mmmm, yyyy
After doing this, Your application will be able to insert the exact date to your database.As there is no sql server level settings to change the date format. But apart from thatyou can use SET option while firing the insert command to your database
Insert into table (date1) value ('29/04/2008')
Labels: SQL Information