N
N
nonbody2015-04-30 16:56:37
Working with date/time
nonbody, 2015-04-30 16:56:37

MSSQL how to compare date?

How can I select only records from the month and year I need?
For example there are dates in a column of such format.
Dec 13 2014 12:32:00:480AM
Feb 3 2015 12:32:00:480AM
Feb 21 2015 12:32:00:480AM
...
Apr 11 2015 12:32:00:480AM
How to query to select dates later than a certain month?
For example, after March 2015

Answer the question

In order to leave comments, you need to log in

2 answer(s)
N
Nikita Kamenev, 2015-04-30
@NickStone

SELECT * FROM table WHERE date LIKE '%2015%'

N
nonbody, 2015-04-30
@nonbody

That is, all dates, for example, from May 2014 to the current time

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question