SQL to get date from datetime field

Saloni Upadhyay's Avatar, Join Date: Jan 2010
Newbie Member
select convert(varchar,Datecolumn,101)
where
101 ->mm/dd/yyyy
108 ->hh:mm:ss
103 ->dd/mm/yyyy

Function for getting current date in sql --> getdate()
SpOonWiZaRd's Avatar, Join Date: May 2007
Know what you can do.
Welcome to G4E, is that a question?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Moved to DB forum