Home Forums SQL Server 7,2000 T-SQL Truncating Date RE: Truncating Date
sushila
SSC-Dedicated
Points: 35293
More actions
April 12, 2006 at 5:38 pm
#632253
use convert and apply a style to get only the date...
select convert(varchar, getdate(), 101)
there're any # of formats that you can apply - check BOL for the one that fits your need best!
**ASCII stupid question, get a stupid ANSI !!!**