Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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";
It's clearly stating ..
I believe you need Convert() instead to_timestamp
Sorry Anil,
Can u please help with an example.
My SQL date format is below:
Thanks,
AS
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";