how to select datas from database only from their time if they have both date and time value in c#

Question

0.00/5 (No votes)

See more:

hi frens, its me bishnu karki
i want to retrieve all datas in crystal report but only by using the date and not the time, i have datas in which it has both date and time in single data value , how can i seperate it and get the required datas, please help me ............

Posted 2-Nov-11 8:20am

vishnu karki

Add a Solution

Comments

Bala Selvanayagam 3-Nov-11 8:20am

vishnu

If you have a question, please use the "Have a question or comment" right below my solution and i will be notified by an email immediately but please do not post your questions as an another solution

CreatedDateTime is one of my column in the table employees with a sample date of "14 Jun 1990 12:47 AM" with time part.

the two CAST operations and FLOOR will remote the time part and make it for example "14 June 1990" which can be compared with your input date

Hope this helps

2 solutions

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)

Bala Selvanayagam · Answer 1 · 2011-11-02T08:28:00

Solution 1

You can remove the time element.

for example

SQL

select *
from   employees
where CAST(floor( CAST( CreatedDateTime AS FLOAT ) )AS DATETIME) = '13 Jun 1967'

Posted 2-Nov-11 8:28am

Bala Selvanayagam

Updated 2-Nov-11 8:31am

v2

vishnu karki · Answer 2 · 2011-11-02T22:27:00

Solution 2

is CreatedDateTime the name of column of table? and what is cast and floor please reply soon

Posted 2-Nov-11 22:27pm

vishnu karki

Comments

Bala Selvanayagam 3-Nov-11 8:21am

vishnu

If you have a question, please use the "Have a question or comment" right below my solution and i will be notified by an email immediately but please do not post your questions as an another solution

CreatedDateTime is one of my column in the table employees with a sample date of "14 Jun 1990 12:47 AM" with time part.

the two CAST operations and FLOOR will remote the time part and make it for example "14 June 1990" which can be compared with your input date

Hope this helps