error is 296: "The conversion of char data type to smalldatetime datat

[GaryInUK]

Hi,

Select ActiveCharges.ID, ChargeTypes.Name, ActiveCharges.Start, ActiveCharges.[End], ActiveCharges.Amount from ActiveCharges
INNER JOIN ChargeTypes ON ActiveCharges.ItemID = ChargeTypes.ID
Where ActiveCharges.ProviderNo = 1 AND [End] = CAST('2078/12/31 00:00:00' as smalldatetime) Order By ItemID

Simple - works on my SQL Query Analyser, but doesn't work on my mate's.

Am I missing something???

The error is 296: "The conversion of char data type to smalldatetime datatype resulted in an out-of-range smalldatetime value"

This is causing the prob I believe
[End] = CAST('2078/12/31 00:00:00' as smalldatetime)

but which settings must I check to make sure it works.

Cheers,

Gary

 

[foxdev]

Could it be a difference in your SET DATEFORMAT settings? Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[GaryInUK]

I figured it out. Cunningly the SQL Logins had been incorrectly set up by the DBA.

One was "British English" the other was "English". Consequently the day and month needed to be one way for one person and the other way for the other person

 

[mukund]

Hi Gary,
I think you should pass the string for CAST function, in the following format.

yyyy-mm-dd hh:mm:ss
e.g.
'2078-12-31 00:00:00'

Hope this helps.
Mukund.