the expression contains undefined function call cast().

Sonu Gupta7y ago

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

0

Rafnas T P7y ago

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.

0

Rajanikant Hawaldar7y ago

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 ?

0

Satish7y ago

using cast('' as date) like this

0

Rajanikant Hawaldar7y ago

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

0