Timestamp error while fetching data from Azure Synapse Analytics.

[deep2021]

Hi All,

I am fetching data from Azure synapse but I am unable to convert the timestamp for the incremental load.

I am getting an error as per the below,

I am using the below function.to convert the timestamp,

CONVERT(DATETIME, "timestamp_event",104) as timestamp_event,

My date in azure is in below format,

Could you please suggest on this.

How to move ahead.

I am trying to apply the incremental load.

Thanks

[vinieme12]

This error is being returned from your database and is not related to Qlik,

https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-...

You would find more information on stackoverflow 

[PrashantSangle]

Hi,

As Vineeth correctly pointed out that issue is in database query script not related to qlik script.

Just want to know, in which format you are converting timestamp event.

there are 2 possible solution for this.

1: use correct covert() in SQL script.

2: In Qlik:

Use

Load *, Timestamp(Timestamp#(yourdatefield,'YYYY-MM-DD hh:mm:ss.ffff'),'Your_required_format');

Select <you_SQL_script>

Regards,

Prashant Sangle

[deep2021]

Hi All,

Thanks for the response, My second timestamp is in the below format,

Can you please suggest how to compare timestamp for incremental and how to convert them in the desired format?

Thanks

[vinieme12]

Timestamp(Timestamp#(yourdatefield,'YYYY-MM-DDhh:mm:ss.ffff'),'Your_required_format')

refer example here

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/NumberInte...