Ver originalSELECT dateadd(hh,12,CONVERT(datetime,'2011-10-22')) ----------------------------------------------------------------2011-10-22 12:00:00.000