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 - 2005-05-02 : 07:29:53
|
| Ralph writes "How can I save a file with the current date only(no time component) as part of the file name? I want to use this ability in a DTS that converts a spreadsheet into a formated text file that gets ftp'd to the same remote directory daily." |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-02 : 07:51:58
|
| Its usally best to leave the date/time as is and filter out time at the SP or querry.Here is the conversionConvert(varchar(30),Yourcolumn,101)JimUsers <> Logic |
 |
|
|
|
|
|
mssql 2000