Posted by Crumb on 03/01/06 22:42

Hi,

I am a Newbie to SQL and am therefore sorry if this is a stupid
question

I am trying to run the following command

SELECT OriginationNumber, DestinationNumber, StartTime, State, Duration
FROM dbo.IpPbxCDR
WHERE OriginationNumber Like 'MMColParam' or DestinationNumber Like
'MMColParam' and StartTime Between '%MMColParam2%' AND
'%MMColParam3%'

I am passing the variables MMColParam from a Web page but I always get
the following error when I try to run the command

Error converting string Datetime from Charactor String.

I have checked the DB and the value is defined as DateTime entry


here is an example of Table entry 16/11/2005 18:27:24

Can anyone help me with this?

Many Thanks

Ian

• Next in forum: Re: Reasonable to assemble FullName W/ A UDF
• Prev in forum: Re: Difference Between NULL and Blank in SQL
• Thread view: Convert Sting to Date

[Reply to this message]