Date Time selection in sql server.

Question

0.00/5 (No votes)

See more:

I have two column DATE,TIME in one table. I want to fetch record between 10/10/2013 10:10 - 10/12/2013 12:00. Tell me how to fetch.

Posted 25-Dec-13 21:52pm

Abhilask kumar

Add a Solution

3 solutions

Solution 1

Check this out:

Date Time selection in sql server.[^]

hope it helps :)

Posted 25-Dec-13 21:59pm

Uday P.Singh

Comments

Abhilask kumar 26-Dec-13 4:12am

It is not my question. first you understand my query.
my query is one table 2 column(DATE,TIME). Then How to select between two date and start time of start date and end time of end date.

Solution 2

Hi,

See the below link. It might be helpful to you.

http://stackoverflow.com/questions/7079543/how-can-i-find-the-data-between-two-specific-times-in-sql[^]

Posted 25-Dec-13 22:00pm

viprat

Comments

Abhilask kumar 26-Dec-13 4:12am

It is not my question. first you understand my query.
my query is one table 2 column(DATE,TIME). Then How to select between two date and start time of start date and end time of end date.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2013-12-25T23:22:00

Solution 3

You can just add them.

select * from mytable where date + time >= '10/10/2013 10:10:00' and date + time <= '10/12/2013 12:00:00'

Posted 25-Dec-13 23:22pm

Christian Graus

Comments

Abhilask kumar 26-Dec-13 5:27am

It is return error "Operand data type date is invalid for add operator."
can i use SELECT * FROM mytable WHERE DATE+TIME between '2013-12-24 00:00:00' AND '2013-12-26 10:00:00'

Abhilask kumar 26-Dec-13 5:44am

Thanks. I have cast date and time then work fine.

Christian Graus 26-Dec-13 18:04pm

Awesome. I am pleased to hear that you worked at it and solved the issue.