For now the best way to handle this specific type conversion is to use the SQL<T>() extensions method that allows you to write backend-dependent SQL code snippets and insert them in your LINQ queries.
Please note that the SQL statement in this case is specific to MS SQL Server and can fail if different backend is used.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.