Click here to Skip to main content
14,454,632 members
Rate this:
Please Sign up or sign in to vote.
i have to compare time attributes of two tables and query is like
select s.sid
from sal s, prod p
where s.date='2008-01-10'
and p.beginDate< s.date
and p.endDate>s.date


i want to know, how it will be evaluated.mean, is it same to following query

select s.sid
from sal s, prod p
where s.date='2008-01-10'
and p.beginDate<2008-01-10'
and p.endDate>'2008-01-10'
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 1

Use Query analyzer of SQL Server to find the query cost and performance.
   
Comments
s_aslam98 17-Dec-10 14:10pm
   
okay, i check it.but, is it theoratically right
Rate this:
Please Sign up or sign in to vote.

Solution 2

Yes, it should do the same thing, but you could have determined that yourself by simply running the two different query versions in SQL Server Management Studio Express...

   
v2
Rate this:
Please Sign up or sign in to vote.

Solution 3

Hi,
there's two way to compare Date Time types, but i see that you need the Date and not the time comparation right?

well, if you need the time Use this function CONVERT(DataType,Value,#)
here an example
SELECT CONVERT(varchar(11),fecha_de_Emision,113),
       CONVERT(varchar(11),fecha_de_Emision,112) ,
       CONVERT(varchar(11),fecha_de_Emision,110) ,
       CONVERT(varchar(11),fecha_de_Emision,109)
FROM TableOfSomeDates WHERE Date1 >=Date2


the result is a several dates in differents formats..

remember if you want comparate Date be sure that the date is in the correct format like MM/DD/YY OR MM/DD/YYYY OR MM/DD/YYYY HH:MM:SS

the simple way to do this is to use the CONVERT function

CONVERT(varchar(11),fecha_de_Emision,110) the result is '11-09-2011' (avoid the time, leave only the Date)
then you can compare with your DateTime
Regards!!!

[Edited]Code is wrapped in "pre" tag[/Edited]
   
v2
Comments
RaviRanjanKr 10-Nov-11 6:55am
   
A Suggestion :- Always wrap your code in "pre" tag to give better readability to user.
Rene Bustos 23-Nov-11 10:54am
   
ok. thanks Ravi!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100