Convert Char to Date in SQL Server

[Former Member]

Hello Experts,

I am trying to convert Char to Date but getting error in Universe designer. Can anybody advise please?

Thanks,

Ravi

[Former Member · Accepted solution]

Hi,

Try with CAST() and CONVERT() functions. For more information refer use this url : http://msdn.microsoft.com/en-us/library/ms187928.aspx.

It is more easy to get solution if you can post your query.

Cheers,

Suresh Babu Aluri.

[Former Member · Accepted solution]

Thank you..

[Former Member]

The cast() or convert() functions would be your best bet. Please post the syntax you have tried and it will be easier to debug. More details on these two functions can be found on the Microsoft site here:

http://msdn.microsoft.com/en-us/library/aa226054(SQL.80).aspx