I Have an application in VB2008 and MySql as Database.I have date field on form, Accepted date format is yyyy-mm-dd when it is adding into database while retreiving data from database table to datagrid view and form fields date field is diplaying in otherformat i.e 'mm-dd-yyyy' because of this end user getting confused.I need database table format yyyy-mm-dd on datagrid and form field.Both should be same as yyyy-mm-dd