clarification in query

Question

Post reply

clarification in query

faroz2003

SSC Journeyman

Points: 92
More actions
March 16, 2012 at 4:39 am

#270117

Hi All,
Pls explain me the below query
select * from xyz
where year(created_on) <2010
if i give date instead of year it will work?
note: "xyz" is a table and "created_on " is column in my db
Pls advice me
very urgent.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Where are you going to "give a date"?

Do you mean instead of 2010?

That will not work, as YEAR(myColumn) returns an integer, so it needs another integer to be compared with, otherwise you get incompatible data type issues.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

faroz2003 SSC Journeyman Points: 92 More actions · Answer 2

faroz2003

SSC Journeyman

Points: 92

March 16, 2012 at 5:19 am

#1460429

Thanks Keon Verbeeck

now i understood.

really thanks

j.miner SSCrazy Points: 2264 More actions · Answer 3

The TSQL example below work since you are comparing apples with apples.

select * from xyz where year(created_on) < year('2012-01-01')

-- or

select * from xyz where created_on < '2012-01-01'

John Miner
Crafty DBA
www.craftydba.com

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 4

faroz2003 (3/16/2012)
Hi All,
Pls explain me the below query
select * from xyz
where year(created_on) <2010
if i give date instead of year it will work?
note: "xyz" is a table and "created_on " is column in my db
Pls advice me
very urgent.

What is the datatype of "Create_on"?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)