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 - 2003-01-10 : 08:31:25
|
| Chan writes "Dear All:I would like to get the date only from sql server, I know that I can use the getdate function and together with Convert function to remove the time. But my problme is the output of the date format must in the format of Window setting instead of the format that I mention in convert function.Please help. Thanks" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-10 : 08:49:28
|
| Any presentation layer should be able to convert to the current profile format.Wouldn't advise trying to do this sort of thing in sql.==========================================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. |
 |
|
|
|
|
|
Date in Window setting format