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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-06-01 : 11:28:19
|
| Hi i have a column, that is in this format "20060502" its a string. I want to change the format to "dd\mm\yyyy" a date format.But my update statement does not work, any1 know why ? UPDATE UK_SBS SET UK_SBS.[Desp Date] = Format([Desp Date],"dd\mm\yyyy"); |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-06-01 : 14:45:30
|
| May be the Date Format of Machine is different from what u try to put.When u take out data (in to a front end), u can display it in any format using the function FORMATIf u want to have data in the way u like, u can Format and save in a Text Type Field (But not recommended)Srinika |
 |
|
|
|
|
|
From US Date format to UK