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
Sai Reddy
NA
214
31.6k
SQL PUZZLE WITH Date Function
May 31 2018 2:27 AM
Hi,
I found the following query some where in the google .
SELECT YEAR(35000/20) AS YEAR_VALUE----> Output = 1904
As you can see that 35000/20 is not a valid date value. The matter of the fact 35000/20 is results in value 1750.
Reply
Answers (
3
)
A cursor with the name 'CURSOR_LIST' does not exist
How To Swap the values in the Table?