I want date instead of datetime from my table in sql server?

Question

I have a table in which there is one column, EnteredDateTime. This column contains the date and time. How do I get only the date instead of the date and time?

Look at you profile.. *"I have 3 year experience in .Net technology's and Ms Sql Server. "* I don't believe you !!! — , Jul 09 '14 at 10:09
@Popeyethesailorman: Seems your comment made his profile changed :) — huMpty duMpty, Jul 09 '14 at 12:46

score 1 · Answer 1 · answered Jul 09 '14 at 09:58

1

SELECT  CAST(enteredDateTime AS DATE)
FROM    mytable

answered Jul 09 '14 at 09:58

Quassnoi

413,100
91
616
614

@user3819358: You can accept the answer if it works, by clicking in the check mark next to the answer!! – Jul 16 '14 at 16:17

score 0 · Answer 2 · answered Jul 09 '14 at 10:02

0

Select Convert(Date, EnteredDateTime) as EnteredDateTime
From TableName

Have a look at CAST and CONVERT

answered Jul 09 '14 at 10:02

huMpty duMpty

14,346
14
60
99

Ajay · Answer 3 · 2014-07-09T10:10:23.820

0

Try this:

SELECT  CAST(yourDateTimeColumn AS DATE) from tableName

for example

SELECT  CAST(GETDATE() AS DATE)

gives me

2014-07-09

Refer this: http://www.w3schools.com/sql/sql_dates.asp

edited Jul 09 '14 at 10:10

answered Jul 09 '14 at 10:04

Ajay

6,418
18
79
130

faster? Got any proof? – Nick.Mc Jul 09 '14 at 10:04
1

Have you read the question. OP says *"How do I get only the date instead of the date and time"* !! – huMpty duMpty Jul 09 '14 at 10:05
This is outputting with time – Jul 09 '14 at 10:06

I want date instead of datetime from my table in sql server?

3 Answers3