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 - 2000-12-08 : 09:09:47
|
Rob writes "I have a whole load of data, in different tables, that all have a column "TimeAdded" which is a date/time string. Unfortunately I need to change the format of this date/time string so that every month, which is currently numeric, is now given as the three letter text equivalent.
i.e. 12/10/00 19:53:00 becomes 12/Oct/00 19:53:00
Is there any way to batch process this, either by using T-SQL or ASP (or any other method), so that it changes each and every record in the tables (I can manually run it on each table, in turn)?
thanks,
rob
SQL Server 7, Windows NT Server" |
|
|
|
|
|
Update - with wildcards