using convert function filter time or date only from datetime column

SELECT

 



convert(char(11), getdate(),109)

May  6 2008

SELECT

 



convert(char(8), getdate(),108)

12:51:32

and so on u can change according input different char length and style value