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-10-04 : 10:03:14
|
| Mark writes "Hello PeopleI hope you can be of help.I'm interested in converting a timestamp value stored in a sql server 2000 database table column, in the format:dd/mm/yyyy hh:mm:ssto the format:dd/mm/yyyyHow can I achieve this?Sorry if this appears to be such a basic question of the layman form, but my knowledge of sql 2000 at the best of times is at the most basic level.CheersMark" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-04 : 10:15:14
|
| select convert(varchar(10),fld,113)==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
converting timestamp value to date value