<div>
This should get you closer to your purpose...<br />
select (convert(varchar(12),getda<wbr />te(), 112) + '.' + right (cast(getdate() as varchar(50)), len(cast(getdate() as varchar(50)) - 11) &nbsp;<br />

</div>


This should get you closer to your purpose...
select (convert(varchar(12),getdate(), 112) + '.' + right (cast(getdate() as varchar(50)), len(cast(getdate() as varchar(50)) - 11)  


<div>
nope - syntactically incorrect. &nbsp;i added the missing paren after the first getdate(), 112), but now I'm getting this error:<br />
Syntax error converting the varchar value 'Mar 20 2005 &nbsp;2:49PM' to a column of data type int.<br />
<br />
select (convert(varchar(12),getda<wbr />te(), 112)) + '.' + right (cast(getdate() as varchar(50)), len(cast(getdate() as varchar(50)) - 11))<br />
<br />
this gets me this: &nbsp;20050320. 2:48PM<br />
select (convert(varchar(12),getda<wbr />te(), 112)) + '.' + RIGHT(CONVERT(VARCHAR(30),<wbr /> getdate(), 100), 7)<br />
<br />
but I don't want the time in that format. &nbsp;any ideas?
</div>


nope - syntactically incorrect.  i added the missing paren after the first getdate(), 112), but now I'm getting this error:
Syntax error converting the varchar value 'Mar 20 2005  2:49PM' to a column of data type int.

select (convert(varchar(12),getdate(), 112)) + '.' + right (cast(getdate() as varchar(50)), len(cast(getdate() as varchar(50)) - 11))

this gets me this:  20050320. 2:48PM
select (convert(varchar(12),getdate(), 112)) + '.' + RIGHT(CONVERT(VARCHAR(30), getdate(), 100), 7)

but I don't want the time in that format.  any ideas?

<div>
<div class="content wysiwyg-content">
Hi. &nbsp;I'm looking to get a datetime concatenated value from my table -- this is probably quite easy, but I'm not getting what I want.<br />
<br />
this gives me this: &nbsp;20050320<br />
select convert(varchar(12),getdat<wbr />e(), 112)<br />
<br />
what's the right way to return this: &nbsp;20050320.14:23:53.140<br />
<br />

</div>
</div>


Hi.  I'm looking to get a datetime concatenated value from my table -- this is probably quite easy, but I'm not getting what I want.

this gives me this:  20050320
select convert(varchar(12),getdate(), 112)

what's the right way to return this:  20050320.14:23:53.140



what's the best way to concatenate this date?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.