how to get the minute part alone without seconds

Question

5.00/5 (1 vote)

See more:

SQL-Server-2005

where CONVERT(VARCHAR,lastsenddate,101)=CONVERT(VARCHAR,getdate(),101)and ---

in the above iam comparing the lastsendate with the currentdate which is working and adding to that i need to check whether the 'minute ' of lastsendate matches with the current datetime minute.

need to the get lastsendates hour and minute part alone
and the currentdates hour and mniute part alone i donot require seconds.

pls help me out

Posted 14-Dec-11 22:45pm

ashok_89

Add a Solution

3 solutions

Solution 1

Hi,

Try this sample if could help...

C#

where lastsenddate between cast(@From + ' 00:00:00' as datetime) and cast(@To + ' 23:59:59' as datetime))

Please vote if could help so that others may consider as an answer...

Regards,

Posted 14-Dec-11 22:56pm

Al Moje

Comments

ashok_89 15-Dec-11 5:07am

really great ,it works sir and i also need to remove the date part also

Al Moje 15-Dec-11 20:46pm

Thanks, Could you click the vote radio button so that others may see and consider as an answer? The highest vote is on the right side (5)...

sravani.v 15-Dec-11 23:42pm

My 5!

Solution 3

In case you were going to compare two times DATEDIFF[^] will help you , to collect times that have ocurred just in the same minute as now try this :

SQL

where DATEDIFF(MINUTE, lastsenddate, GETDATE())=0 and 
        DATEDIFF(SECOND, lastsenddate, GETDATE())<60

This will give you lastsenddates whose minutes are the same as now.

If you want other alternations execute this query and use its functions in your where clause :

SQL

select GETDATE(), DATEPART(HOUR, GETDATE()),DATEPART(MINUTE, GETDATE())

Hope it helps.

Posted 15-Dec-11 18:46pm

Amir Mahfoozi

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)

nwayynge · Accepted Answer · 2011-12-14T23:18:00

Solution 2

Try this :

SQL

select datepart(mi,getdate())

SQL

where CONVERT(VARCHAR,LastSendDate,101)=CONVERT(VARCHAR,getDate(),101) and DATEPART(hh,LastSendDate)=DATEPART(hh,getDate()) and DATEPART(mi,LastSendDate)=DATEPART(mi,getDate())

Posted 14-Dec-11 23:18pm

nwayynge

Updated 15-Dec-11 17:31pm

v2

Comments

ashok_89 15-Dec-11 5:30am

sir i dont know how to use in this query just show me an sample

ashok_89 16-Dec-11 0:25am

thanks a lot siir its really awesome, thank u very much