Posted by laurenq uantrell on 10/22/92 11:33

Maybe you're right but it's pretty bullet proof and passing integers
seems preferable to passing strings. Plus, I'm always dealing with date
and time as opposed to date when dealing with clients in multiple time
zones, so since everthing is converted to UTC anyway, I figure why not
just look at dealing with DATEDIFF as opposed to date parameters. I
just throw this out as a theoretical since I am already heavily
invested in datetime parameters in my current projects.
I imagine this would have implications on query performance as well
since the stored procedures would be using DECLARE'd variables as WHERE
filters (WHERE StartDate BETWEEN @ServerStartDate and @ServerEndDate...)

[Back to original message]