When i insert record i gave written this Format(DTPicker3.Value, "MM/dd/yyyy") . On what basis date is stored in Database.
dates are stored in sql server internally as integer values. when you select datetime field the values will be shown in iso format yyyy-mm-dd hh:mi:ss You can apply CONVERT() function to get it in format you want by making it varchar and specifying a style value which corresponds to format. This can also be done in front end applications using format functions available there.