DateValue() thus:
SELECT X,Y,Z
WHERE datevalue(UPDATED) = #createOdbcDate(mydate)#
unfortunately the dateValue() function doesn't exist in MS SQL so
another way to do it is:
SELECT X,Y,Z
WHERE datediff(d,UPDATED,#createOdbcDate(mydate)#) = 0
My question: Is this an effecient way of doing it, or is there a better
way?
ps I have a lot of quite big ones to do, like
SELECT X,Y,Z
WHERE datediff(d,UPDATED,#createOdbcDate(mydate)#) >= 0
--
Regards;
Richard Meredith-Hardy
-------------------------------------------------------------
r[dot]mh[at]flymicro[dot]com
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
