Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-28 : 11:22:52
|
| Saibabu writes "HI We are accessing SQL Server 2000 by using ADO.We are executing a SELECT statement which returns some Date values. But Now our problem is that we need to get all the date values to be returned to us in a specific format specified by us.We tried setting our required Date format everytime a ADO Connection is opened to SQLServer 2000 expecting that It will give the Date values in the format we set. But unfortunately it doesn't seem to be working.Please let us know the way to retrieve the Date Sql Server 2000 in our specified DATE FORMATthanks in advanceSai" |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-08-28 : 11:24:58
|
| Try using CAST or CONVERT function as per your required settings.. Refer BOL for more info on the functionsCheers,Samrat |
 |
|
|
|
|
|
SQL Server200 DATE Conversion