<div>
dude your a Ledged. i hate dates. saved me so much messing round. got deadlines to meet.<br />
<br />
thanks big time.
</div>


dude your a Ledged. i hate dates. saved me so much messing round. got deadlines to meet.

thanks big time.

<div>
This will work for you<br />

<pre><code id="code-20-36916384-1">Select Convert(varchar,DATEPART(yyyy,'2011-01-04 00:00:00.000'))+RIGHT('00' + Convert(varchar,DATEPART(mm,' 2011-01-04 00:00:00.000')),2) + RIGHT('00' + Convert(varchar,DATEPART(dd,' 2011-01-04 00:00:00.000')),2) </code></pre>
</div>


This will work for you


Select Convert(varchar,DATEPART(yyyy,'2011-01-04 00:00:00.000'))+RIGHT('00' + Convert(varchar,DATEPART(mm,' 2011-01-04 00:00:00.000')),2) + RIGHT('00' + Convert(varchar,DATEPART(dd,' 2011-01-04 00:00:00.000')),2) 

<div>
date and time: don't be scared :)<br />
<a href="https://www.experts-exchange.com/A_1499.html" rel="ugc">https://www.experts-exchange.com/A_1499.html</a>
</div>


date and time: don't be scared :)
https://www.experts-exchange.com/A_1499.html [https://www.experts-exchange.com/A_1499.html]

<div>
<div class="content wysiwyg-content">
please note the dates get added everyday and are not static.<br />
my source table has the following date. 2011-10-04 00:00:00.000<br />
<br />
the following code below produces the dta as follows. 041011.xls<br />
i need to change it from ddmmyy to yyyymmdd. <br />

<pre><code id="code-8224654">+ CASE WHEN LEN(CONVERT(VARCHAR,DATEPART(dd,@date))) = 1 
		  THEN '0' + CONVERT(VARCHAR,DATEPART(dd,@date)) 
		  ELSE CONVERT(VARCHAR,DATEPART(dd,@date)) END
	+ CASE WHEN LEN(CONVERT(VARCHAR,DATEPART(mm,@date))) = 1 
		  THEN '0' + CONVERT(VARCHAR,DATEPART(mm,@date)) 
		  ELSE CONVERT(VARCHAR,DATEPART(mm,@date)) END
	+ CONVERT(VARCHAR,RIGHT(DATEPART(yyyy,@date),2))
	+ '.xls&quot; &quot;exit&quot;'</code></pre>
</div>
</div>


please note the dates get added everyday and are not static.
my source table has the following date. 2011-10-04 00:00:00.000

the following code below produces the dta as follows. 041011.xls
i need to change it from ddmmyy to yyyymmdd. 

sql date format

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.