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-02-07 : 10:13:07
|
| Sunitha writes "Pls let me know how to fetch the dates in the format dd-mmm-yyyy. With convert function we can get dd mmm yyyy. But I need dd-mmm-yyy format." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-07 : 10:25:43
|
| you can use combination of convert,datepart and datename functions.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-07 : 11:31:18
|
| How about:SELECT Replace( Convert(varchar(12), dateValue, 106), ' ', '-') FROM myTableThe REPLACE function will replace all the spaces in the CONVERTed string with dashes. |
|
|
|
|
|
|
SQL 7.0- To Retrieve dates in dd-mmm-yyyy format