hi if i am using this query in a storeprocedure i am getting error. here is the sp and the error

USE [TEMP]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[psp_TEMP]

-- Add...

thanks a ton Lowell it worked

this value was suppose to be datetime but by mistake the column datatype was given integer so now i want to convert it back to datetime