I was using this statement to get how many hours a user logged in during
the month (timon cold fusion template). It was working fine until I had
this error :
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of CHAR to
SMALLDATETIME resulted in a SMALLDATETIME value out of range.
even if I use sqlquery directly I get the same response. can you help me
where to look to solve the problem. My server is configured for US date
and time settings.
original query is :
SELECT CallDate, UserName, FramedAddress, (AcctSessionTime/60) + 1 as
CallTime, Location
FROM Calls, Servers
WHERE NASIdentifier=IPAddress
AND UserName='#User.UserName#'
AND AcctStatusType=2
AND CallDate >= '04/01/97'
AND CallDate < '04/31/97'
thank you.
Mourad Dahoumane