Please solve the error

Question

1.00/5 (2 votes)

See more:

SQL

SelectCommand="SELECT ATHR,HYPERLINK,HEADINGS,NDATE(SYSDATE,'DD-MON-YYYY') FROM NEWS1 order by ndate desc "

Posted 5-Sep-11 21:19pm

asok6783

Updated 5-Sep-11 21:20pm

Prerak Patel

v2

Add a Solution

Comments

Mehdi Gholam 6-Sep-11 3:22am

What is the error?

Pravin Patil, Mumbai 6-Sep-11 3:25am

Pleae provide the details, like what are you doing, what error you are getting etc.... to get the answer.
Your question is very incomplete.

Prerak Patel 6-Sep-11 3:27am

NDATE(SYSDATE,'DD-MON-YYYY') seems fishy. What is it by the way?

asok6783 6-Sep-11 3:39am

my query is "select * from news" .In that oracle table "news" one field is NDATE of date variable.while using select * it is showing the date along with time but i want the date alone

3 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)

Prerak Patel · Answer 1 · 2011-09-05T22:45:00

Solution 3

Use Cast or Convert
http://msdn.microsoft.com/en-us/library/ms187928.aspx[^]

SQL

SelectCommand="SELECT ATHR,HYPERLINK,HEADINGS,Convert(varchar, NDATE, 106) FROM NEWS1 order by ndate desc "

Posted 5-Sep-11 22:45pm

Prerak Patel

OriginalGriff · Answer 2 · 2011-09-05T21:27:00

Solution 1

Without the specific error message, we have to guess - but NDATE is not a built in SQL function, so I assume you mean something else...

Posted 5-Sep-11 21:27pm

OriginalGriff

Comments

asok6783 6-Sep-11 3:29am

ndate is a date variable in oracle table

Simon Bang Terkildsen 6-Sep-11 3:31am

in that case see my answer and replace sysdate with NDATE and remove ndate from the end

asok6783 6-Sep-11 3:45am

System.Web.HttpException: A field or property with the name 'NDATE' was not found on the selected data source.

Simon Bang Terkildsen · Answer 3 · 2011-09-05T21:29:00

Solution 2

I don't know where you gotten the idea of NDATE being a function in PL/SQL.
use to_char e.g.
to_char(sysdate, 'DD-MON-YYYY') ndate

Posted 5-Sep-11 21:29pm

Simon Bang Terkildsen

Updated 5-Sep-11 21:31pm

v2

Comments

asok6783 6-Sep-11 3:46am

i want to change the ndate(date variable) to char.
if i use to_char(NDATE,'DD-MON-YYYY') it shows the error as
System.Web.HttpException: A field or property with the name 'NDATE' was not found on the selected data source.

Simon Bang Terkildsen 6-Sep-11 6:27am

Then ndate is not a column in your table.