<div>
Try this and see if it helps:<br />
<br />

<pre><code id="code-20-34443454-1">I@FileName = 'xyz' + SUBSTRING(CONVERT(varchar, @OrderTime, 100), 13, 5)+ '.xml'</code></pre>
</div>


Try this and see if it helps:



I@FileName = 'xyz' + SUBSTRING(CONVERT(varchar, @OrderTime, 100), 13, 5)+ '.xml'

<div>
try<br />
<br />
select @OrderTime &nbsp;= replace(replace(replace(co<wbr />nvert(varc<wbr />har(19),ge<wbr />tdate(),21<wbr />),'-',''),<wbr />':',''),' ','')
</div>


try

select @OrderTime  = replace(replace(replace(convert(varchar(19),getdate(),21),'-',''),':',''),' ','')

<div>
Actually this is better:<br />
<br />

<pre><code id="code-20-34443509-1">select FileName = 'xyz' + CONVERT(CHAR(10),@OrderTime, 23) + SUBSTRING(CONVERT(varchar, @OrderTime, 100), 13, 5)+ '.xml' from yourtable</code></pre>
</div>


Actually this is better:



select FileName = 'xyz' + CONVERT(CHAR(10),@OrderTime, 23) + SUBSTRING(CONVERT(varchar, @OrderTime, 100), 13, 5)+ '.xml' from yourtable

<div>
Guys, I said &quot;better&quot; compared to the original code I posted; not to you guys code.<br />
<br />
Just wanted to clarify to avoid confusion.
</div>


Guys, I said "better" compared to the original code I posted; not to you guys code.

Just wanted to clarify to avoid confusion.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a variable like @OrderTime varchar(8) now this variable I am using to add a timestamp to a file. Like SET @FileName = 'xyz' + @OrderTime.+ '.xml'<br />
My file should look like this xyz20101229130446470.xml . How Can I do that? I want everything except the millisecond part so 470 will be removed and it should be xyz20101229130446.xml
</div>
</div>


Hi,
I have a variable like @OrderTime varchar(8) now this variable I am using to add a timestamp to a file. Like SET @FileName = 'xyz' + @OrderTime.+ '.xml'
My file should look like this xyz20101229130446470.xml . How Can I do that? I want everything except the millisecond part so 470 will be removed and it should be xyz20101229130446.xml

Date Time and VARCHAR

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.