TSQL DATE FORMATING 1

[pyttviper]

I want to Format a date to return YYYY-MM-DD with out the hours minutes or seconds. i have looked through all of the help text and cannot find an appropriate way to format a date.

HELP!!!!!!


dan0

 

[jhall156]

just use convert and limit the output to varchar(10) like:
select convert(varchar(10),getdate(),20)

 

[pyttviper]

i know this looks silly but it lets me compare data in the table where that data's date ar 00.00.00.000 formated

thanks for the help

convert(datetime, convert(varchar(10),getdate(),20),20)