I have a 4 tier application. The components are on a different server than the webpages . The SQL server is on a different machine. I am creating a recordset in the component. I have found that the date format of the date depends upon the regional setting of the machine in which the Recordset is created. What I want to know is whether it will depend on the date format of the SQL server also. What about the date format of ADO ?
Would appreciate if I could get quick answer.