how can i remove the time from getdate using with out substring?

how can i Remove time from GetDate() without using substring
shinodmpAsked:
Who is Participating?
 
BinuthConnect With a Mentor Commented:
select convert(varchar,getdate(),101)
0
 
rajeshprasathCommented:
SQL Server does not have separate data types for date and time. If you want to split the date and time separately then you have to convert datetime into varchar datatype.

Date:
select convert(varchar,getdate(),101)

Time:
select convert(varchar,getdate(),108)

For more conversion format visit the following link,
http://msdn.microsoft.com/en-us/library/ms187928.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.