Hi, i am using vb.net 2005
I have a date value in a variable declared as date, I am then trying to insert it into sql table. on one my dev machine the value in my SQL insert statement is 2008/06/30, but on my dev server its being formatted to 30/08/2008. I have checked the regional settings on both machines and they are set to dd/MM/yyyy
So my question is, is there away for me then to "force" the date to yyyy/MM/dd in my insert statement so then its in the correct format on my dev server?
My SQL field is defined as a DateTime datatype