the expression contains undefined function call cast().

Question

If i tried to cast the datetime Then i am getting this error the expression contains undefined function call cast(). How to slove this.

Sonu Gupta · Answer

Hi, Cast method in SQL Server - Visit the following lin - http://www.sqlservertutorial.net/sql-server-system-functions/sql-server-cast-function/ https://www.c-sharpcorner.com/UploadFile/rohatash/cast-and-convert-function-in-sql-server/ Cast method in c# - Visit the following url for detail - https://www.tutorialspoint.com/chash-cast-method

Rafnas T P · Answer

hi satish, may be date field is coming empty and you are trying to cast, before casting please make sure date is not null, you may can follow below example, cast( isnull( 'yourdatefield' ,GETDATE() ) as date in above example when date is empty I am changing to current date then I am casting to date.

Rajanikant Hawaldar · Answer

Satish, refer this link https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-2017 Are you using MSSQL / MYSQL or anyother ?

Satish · Answer

using cast('' as date) like this

Rajanikant Hawaldar · Answer

Hi Satish, if possiable post line of code where error is occurred, use Convert instead of CAST. let us know the issue is fixed or need help on the same. Thanks

the expression contains undefined function call cast().

Answers (5)