Get Date and Time separately from SQL

Situation: You have a column in your table type DateTime. But you just want to view the date or time only. This is how it can be done.

SQL query

Select convert(varchar, [your column date], 3)
from [your table name]

will return result in format dd/mm/yy

Select select convert(varchar, [your column date], 8 )
from [your table name]

will return result in format hh:mm:ss

Here are list of format which you can refer:

Date Formats
Format No.	SQL Query	Output
1	select convert(varchar, [your column date], 1) from [your table name]	12/30/08
2	select convert(varchar, [your column date], 2) from [your table name]	08.12.30
3	select convert(varchar, [your column date], 3) from [your table name]	30/12/08
4	select convert(varchar, [your column date], 4) from [your table name]	30.12.08
5	select convert(varchar, [your column date], 5) from [your table name]	30-12-08
6	select convert(varchar, [your column date], 6) from [your table name]	30 Dec 08
7	select convert(varchar, [your column date], 7) from [your table name]	Dec 30, 08
10	select convert(varchar, [your column date], 10) from [your table name]	12-30-08
11	select convert(varchar, [your column date], 11) from [your table name]	08/12/30
101	select convert(varchar, [your column date], 101) from [your table name]	12/30/2008
102	select convert(varchar, [your column date], 102) from [your table name]	2008.12.30
103	select convert(varchar, [your column date], 103) from [your table name]	30/12/2008
104	select convert(varchar, [your column date], 104) from [your table name]	30.12.2008
105	select convert(varchar, [your column date], 105) from [your table name]	30-12-2008
106	select convert(varchar, [your column date], 106) from [your table name]	30 Dec 2008
107	select convert(varchar, [your column date], 107) from [your table name]	Dec 30, 2008
110	select convert(varchar, [your column date], 110) from [your table name]	12-30-2008
111	select convert(varchar, [your column date], 111) from [your table name]	2008/12/30

Time Formats
Format No.	SQL Query	Output
8 or 108	select convert(varchar, [your column date], 8 ) from [your table name]	00:40:50
9 or 109	select convert(varchar, [your column date], 9) from [your table name]	Dec 30 2006 12:40:50:840AM
14 or 114	select convert(varchar, [your column date], 14) from [your table name]	00:40:50:840