topic Re: ErrorMsg: 'to_timestamp' is not a recognized built-in function name in QlikView

ErrorMsg: 'to_timestamp' is not a recognized built-in function name

amit_saini — Tue, 19 Dec 2017 04:40:17 GMT

Hi Folks,

Can you please suggest , why I'm getting below error:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'to_timestamp' is not a recognized built-in function name.

SQL SELECT *

FROM MasterCAQ.dbo."CAQ_Leer"

WHERE DTTSERF > to_timestamp('12/19/2017 05:04:51', 'MM/DD/YYYY hh:mm:ss')

Thanks,

Re: ErrorMsg: 'to_timestamp' is not a recognized built-in function name

Anil_Babu_Samineni — Tue, 19 Dec 2017 05:18:25 GMT

It's clearly stating ..

I believe you need Convert() instead to_timestamp

Re: ErrorMsg: 'to_timestamp' is not a recognized built-in function name

amit_saini — Tue, 19 Dec 2017 05:23:57 GMT

Sorry Anil,

Can u please help with an example.

My SQL date format is below:

Thanks,

Re: ErrorMsg: 'to_timestamp' is not a recognized built-in function name

Anil_Babu_Samineni — Tue, 19 Dec 2017 05:31:47 GMT

As always, I would prefer to work QV functions. Because, If SQL getting down that created headache again. Any way, using Qlikview you may try this?

Load Date(Date#(DTTSERF, 'MM/DD/YYYY hh:mm:ss TT'), 'MM/DD/YYYY hh:mm:ss') as DTTSERF where Date(Date#(DTTSERF, 'MM/DD/YYYY hh:mm:ss TT'), 'MM/DD/YYYY hh:mm:ss') > '12/19/2017 05:04:51';

SQL SELECT * FROM MasterCAQ.dbo."CAQ_Leer";

Even, more efficient you can use

SET Var = 12/19/2017 05:04:51;

And, Then use this?

Load * Where DTTSERF > '$(Var)';

Load Date(Date#(DTTSERF, 'MM/DD/YYYY hh:mm:ss TT'), 'MM/DD/YYYY hh:mm:ss') as DTTSERF;

SQL SELECT * FROM MasterCAQ.dbo."CAQ_Leer";