CONVERT SQL Server Example

SQL Server > Built-in Functions > CONVERT

CONVERT converts an expression of one data type to another.

Example

select CONVERT(nvarchar(30), GETDATE(), 100)

result

Oct 15 2014  9:54AM

Other examples:

How to format date and time