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

[amit_saini]

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,

AS

[Anil_Babu_Samineni]

It's clearly stating ..

I believe you need Convert() instead to_timestamp

[amit_saini]

Sorry Anil,

Can u please help with an example.

My SQL date format is below:

Thanks,

AS

[Anil_Babu_Samineni · Accepted solution]

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";