Compare dates in MS SQL using Convert

Question

I want to do the correct way to get a date from a @parameter that contains the complete datetime, that user gets from a calendar from TFS File.

In the select I would want to use something like CONVERT(varchar(10), @FechaHasta.Value, 120) AS DATE01 and then get the only date, throwing out the time from the parameter.

For the next step, I would want to compare it with another date in WHERE clause, having this code :

Awful code

Then, I would want to make this work on for looking for between two dates, and the last one, throwing out the time from the datetime.

Thanks.

possible duplicate of How to return the date part only from a SQL Server datetime datatype — Hogan
– Hogan, Commented Oct 28, 2014 at 17:18

Community · Accepted Answer · 2017-05-23 12:27:22Z

1

I am assuming @FetchHasta is a datetime

CONVERT(VARCHAR(10), @FetchHasta, 101)

is what gets you just the date part. i.e. 10/28/2014 1:10 PM would simply become 10/28/2014.

Source

EDIT: Alternatively, How to return the date part only from a SQL Server datetime datatype

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Oct 28, 2014 at 17:09

Scott T

2831 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

juannmcc Over a year ago

yes, but then, I put the '... AS date01' and compare in the where clause like that name?

Scott T Over a year ago

No. You can put the AS date01 for the column name if you wanted, but you would have to redo the calculation in the WHERE clause. It may be better to add a new variable before your SELECT query with the above calculation so you can use that in both places instead of calculating it repeatedly.

Collectives™ on Stack Overflow

Compare dates in MS SQL using Convert

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related