<div>
see the CONVERT function help in BOL for complete list of formats
</div>


see the CONVERT function help in BOL for complete list of formats

<div>
for the convert function use this as reference<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp</a>
</div>


for the convert function use this as reference
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp]

<div>
This gives you the date in dd/mm/yy format...<br />
<br />
SELECT CONVERT(VARCHAR(10),GETDAT<wbr />E(),3)<br />
<br />
If you want it in dd/mm/yyyy format..you can use<br />
<br />
SELECT CONVERT(VARCHAR(10),GETDAT<wbr />E(),103)<br />
<br />

</div>


This gives you the date in dd/mm/yy format...

SELECT CONVERT(VARCHAR(10),GETDATE(),3)

If you want it in dd/mm/yyyy format..you can use

SELECT CONVERT(VARCHAR(10),GETDATE(),103)



<div>
<div class="content wysiwyg-content">
Hello<br />
In a stored proc I want to get todays date in the form dd/mm/yy and compare it against some datgetime fields in my tables how can I do this? 
</div>
</div>


Hello
In a stored proc I want to get todays date in the form dd/mm/yy and compare it against some datgetime fields in my tables how can I do this? 

Get date without minutes and seconds?

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.