datediff statement

Question

Viewing 8 posts - 1 through 7 (of 7 total)

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

Sergiy SSC Guru Points: 110208 More actions · Answer 1

Can you just code what you are asking for?

Look:

"hire date is greater then 90 days from today"

can be easily traslated to:

hire_date > dateadd(dd, -90, Getdate() )

Why to complicate own life?

_____________
Code for TallyGenerator

Tahsin Valued Member Points: 54 More actions · Answer 2

Try this:

SELECT * FROM myTable WHERE hire_date > (CONVERT(VARCHAR,getdate()-90, 110))

- Tahsin

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Worst suggestion.

Never do like this.

_____________
Code for TallyGenerator

Sergiy SSC Guru Points: 110208 More actions · Answer 4

So what?

"hire date is less then 90 days from today"

can be easily traslated to:

hire_date < dateadd(dd, -90, Getdate() )

_____________
Code for TallyGenerator

jim Edwards-308192 Say Hey Kid Points: 680 More actions · Answer 5

Thank You for the help. Hopefully I'll catch on to this T-SQL stuff quickly.

jim Edwards-308192 Say Hey Kid Points: 680 More actions · Answer 6

see anything wrong with this? just curious with the difference would be and why you chose dataadd over datediff

where datediff(d,hire_date,GETDATE()) <= 90

thanks!!!

Sergiy SSC Guru Points: 110208 More actions · Answer 7

This version makes using of indexes impossible.

_____________
Code for TallyGenerator