Conversion failed when converting date and/or time from character string. Severity 16

Question

0.00/5 (No votes)

See more:

When I execute

SELECT datepart(HH,'24:31')

following error occurs

Conversion failed when converting date and/or time from character string. Severity 16

How I get hours in 24 and above

Thanks In advance

What I have tried:

Please Its Urgnet

SELECT datepart(HH,'24:31')

Posted 2-Apr-18 22:28pm

shoaib Naeem

Updated 2-Apr-18 22:46pm

Add a Solution

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)

#realJSOP · Answer 1 · 2018-04-02T22:44:00

Solution 1

There's no such thing as hour 24. You should use 00.

Time is measured from 00:00 (midnight) to 23:59 (11:59pm)

Posted 2-Apr-18 22:44pm

#realJSOP

Updated 2-Apr-18 22:45pm

v2

Comments

shoaib Naeem 3-Apr-18 4:54am

Accutally its working Hours of and Employee and I want to convert it into minutes

OriginalGriff · Answer 2 · 2018-04-02T22:47:00

24:31 is not a valid time: SQL datetime values (which DATEPART expects) cannot represent it as a time so you correctly get the error - which you do not with just a valid time:

SELECT datepart(HH,'23:31')

You will have to look at exactly where the string came from, and work out from that what you can do with it.

We can't suggest anything - we have no idea where you get the value '24:31' from, but the chances are that is comes from your DB and is badly stored - you should never store anything other than true strings as VARCHAR or NVARCHAR - dates, times, numbers: all need to be stored in "proper" columns, not strings. Probably, you need to store it as a number of minutes in an INT instead of string based hours and minutes.