how to calculate tow columns date in sql server 2005 table

Question

0.00/5 (No votes)

See more:

I want to calculate tow column value that contain date time in sql server 2005. this is my code.

select DATEDIFF(day,Issue_date,Return_date)as subtract from dbo.Issue_book ;

return ERROR:

Invalid object name 'dbo.Issue_book'.

please help me..

Posted 11-Feb-15 18:52pm

enamul haque

Add a Solution

Comments

[no name] 12-Feb-15 1:04am

If this is a typo, most likely, table is never created on selected database.

Jeet Gupta 12-Feb-15 2:12am

the specified error shows that your table is not present or it can have a spelling mistake. try to remove the dbo. if still problem exits check your table name.

Kornfeld Eliyahu Peter 12-Feb-15 2:14am

It also can be that the table Issue_book exists but in different schema - not dbo...

Ganesh KP 12-Feb-15 4:15am

Make sure that you are executing the query on the specified database where that table exists. Also try by removing 'dbo'.

Shridhar Gowda 12-Feb-15 23:01pm

First check select * from dbo.Issue_book ; then use functions u want

1 solution

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)

ZurdoDev · Answer 1 · 2015-02-12T16:38:00

The error means it cannot find a table named Issue_book under the dbo schema.

First off, don't use underscores in a table name. If you can change it, do so.
Secondly, try putting brackets around the table name [Issue_book].
Thirdly, remove the dbo part.
Fourth, make sure that table is in the db you are connected to.