TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
venkatesh g
NA
5
0
Fetching records greater then datetime does not work in c# windows service application
May 24 2012 3:38 AM
Hi All,
I have the following queries (both are for same purpose) which fetches records greater the the datetime column.
SELECT PROSPECT.BUSINESS_UNIT,PROSPECT.LAST_CHANGED FROM PROSPECT WHERE (TO_CHAR(LAST_CHANGED, 'YYYY-MM-DD HH24:MI:SS') > (SELECT TO_CHAR(LAST_UPDATED, 'YYYY-MM-DD HH24:MI:SS') FROM LAST_UPDATE))
SELECT PROSPECT.BUSINESS_UNIT,PROSPECT.LAST_CHANGED FROM PROSPECT WHERE LAST_CHANGED > (SELECT LAST_UPDATED FROM LAST_UPDATE))
This query works fine in query window and also in the windows console application. But the same query does not work from c# Application. Could any one has any idea why this behaves differently in c# windows service application.
Regards
Venkatesh G
Reply
Answers (
2
)
The oracle Stored procedure problem
Session In oracle