<div>
SELECT &nbsp; &nbsp; cfs_no, rec_dt, CONVERT(varchar, rec_dt, 103) AS NewDate<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; dba.cfs<br />

</div>


SELECT     cfs_no, rec_dt, CONVERT(varchar, rec_dt, 103) AS NewDate
FROM         dba.cfs


<div>
Hi DavidNPD,<br />
<br />
Select &nbsp;cfs_no, rec_dt, convert(varchar,rec_dt,103<wbr />) + ' ' + convert(varchar(5),rec_dt,<wbr />114) As NewDate<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; dba.cfs<br />
<br />
Tim Cottee
</div>


Hi DavidNPD,

Select  cfs_no, rec_dt, convert(varchar,rec_dt,103) + ' ' + convert(varchar(5),rec_dt,114) As NewDate
FROM         dba.cfs

Tim Cottee

<div>
That is really close, but I have a field size issue that I really need to trim down. I am seeing &quot;06/04/2006 11:21&quot; right now, is there a way to make the 2006 only 06 and also to trim out the :<br />
<br />

</div>


That is really close, but I have a field size issue that I really need to trim down. I am seeing "06/04/2006 11:21" right now, is there a way to make the 2006 only 06 and also to trim out the :



<div>
TimCottee<br />
I just realized that the month and day is now swapped, it is no longer 04/06/2006 but 06/04/2006.<br />
<br />
SjoerdVerweij, <br />
that just gives me &quot;06/04/2006&quot;, no time and also the swapped month/day<br />

</div>


TimCottee
I just realized that the month and day is now swapped, it is no longer 04/06/2006 but 06/04/2006.

SjoerdVerweij,
that just gives me "06/04/2006", no time and also the swapped month/day


<div>
<div class="content wysiwyg-content">
I would like to convert the format of a DateTime field in sql. Currently the field (rec_dt) holds a value such as this &quot;4/6/2006 1:08:48 PM&quot; I would like this to be shown in the query as 04/06/06 1308&quot;<br />
<br />
I was trying to use a command such as the one below, but I dont think I have the format correct.<br />
<br />
<br />
SELECT &nbsp; &nbsp; cfs_no, rec_dt, CONVERT(datetime, rec_dt, 103) AS NewDate<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; dba.cfs
</div>
</div>


I would like to convert the format of a DateTime field in sql. Currently the field (rec_dt) holds a value such as this "4/6/2006 1:08:48 PM" I would like this to be shown in the query as 04/06/06 1308"

I was trying to use a command such as the one below, but I dont think I have the format correct.


SELECT     cfs_no, rec_dt, CONVERT(datetime, rec_dt, 103) AS NewDate
FROM         dba.cfs

Convert Date Format in SQL Query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.