Querying on daily basis based on date

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I have a table related to payments.
I need to search on daily basis
but it is in "2012-04-01 13:00:30.687" date format
column name is PaymentDate
i am able to search by year.
but i need by date
Please help me
i am using

SQL

select * from online_payments where PaymentDate like '%2012%'

this is giving whole year results but i need only particular date.
I tried but not able to find.
Its some what urgent now.
Can any one help me please.

Posted 1-Apr-12 21:15pm

angel94

Updated 1-Apr-12 21:44pm

P.Salini

v3

Add a Solution

3 solutions

Add a Solution

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

OriginalGriff · Answer 1 · 2012-04-01T21:44:00

Solution 3

Try:

SQL

SELECT * FROM Student WHERE dat2 >= '2012-02-12' and dat2 < '2012-02-13'

Posted 1-Apr-12 21:44pm

OriginalGriff

Michel [mjbohn] · Answer 2 · 2012-04-01T21:35:00

Solution 1

Have a look at the CONVERT command. http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx[^]

With this command you do your query like this:

SQL

select * from online_payments where CONVERT(varchar(8), PaymentDate,112) = '20120401'

regards
Michel

Posted 1-Apr-12 21:35pm

Michel [mjbohn]

Saral S Stalin · Answer 3 · 2012-04-01T21:38:00

Solution 2

Try like below.

SQL

select * 
from online_payments 
where DateAdd(day, DateDiff(day, 0, PaymentDate), 0) = '2012-04-01'

DateAdd(day, DateDiff(day, 0, PaymentDate), 0) removes time and get the date alone

Posted 1-Apr-12 21:38pm

Saral S Stalin

v2

Querying on daily basis based on date

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Querying on daily basis based on date

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us