You can translate the question and the replies:

"The parameters of the function 'to_timestamp' cannot be delegated to this database." in MS SQL Server 2017

Hi. In my view, I use the TO_TIMESTAMP function to parse a string to a timestamp. In the VQL, it looks like this: to_timestamp('dMMyy', common.i_bv_erp_kund.creation_date) But now, queries involving this view won't get pushed down to the source because, "The parameters of the function 'to_timestamp' cannot be delegated to this database." The Database we use is a MS SQL Server 2017. Is this a known limitation? Best regards, David
to_timestamp sqlserver mssql performance
user
02-11-2022 07:42:51 -0400
code

1 Answer

Hi, I was able to delegate the **to_timestamp** function to MS SQL server 2017. In order to delegate the "to_timestamp" function, I would check the timestamp pattern of the function, because not all patterns are delegatable. For example, ` Select to_timestamp(‘yyyy-MM-dd HH:mm:ss’, date_column) from base_view1` In this example, ‘yyyy-MM-dd’ pattern can be delegatable to the MS SQL server 2017. Please notice that the “to_timestamp” function can be delegated only when the pattern matches one that can be translated to a SQL Server Convert Function. You could also refer to the section [Datetime Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/datetime_functions/datetime_functions) of the Virtual DataPort VQL Guide for more information about Date and time functions offer by Denodo Platform. Hope this helps!
Denodo Team
04-11-2022 01:51:20 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here