<div>
<div class="content wysiwyg-content">
I am writing a SPROC. &nbsp;What is the syntax for converting the result of GetDate() into the format yyyy-mm-dd hhmm?<br />
<br />
DECLARE @MyDateTime varchar(20)<br />
@MyDateTime = GetDate()
</div>
</div>


I am writing a SPROC.  What is the syntax for converting the result of GetDate() into the format yyyy-mm-dd hhmm?

DECLARE @MyDateTime varchar(20)
@MyDateTime = GetDate()

Format Date and Time as yyyy-mm-dd hhmm

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.