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

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.

Please solve the error

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Please solve the error

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us