topic Re: Conversion numeric to date with Replicate in Qlik Replicate

Conversion numeric to date with Replicate

EasyThomas — Fri, 15 Nov 2024 22:48:32 GMT

Hi,

I try to build a replicate task with db2i as a a source and SQLServer as a target.

I try to convert a numeric colum from my source in a date column on my target

The coulmn from my source looks like that '20210615'

The implicite conversion didn't work and there is no function for conversion

Any idea ?

Regards,

sunny_talwar — Tue, 15 Jun 2021 15:28:21 GMT

Try this

=Date(Date#('20210615', 'YYYYMMDD'))

EasyThomas — Tue, 22 Jun 2021 06:43:33 GMT

Hi,

I post the answer if anybody need it in the future

Ther is no date format in SQLite so i used the implicit conversion with the good format for SQL Server

substr('20210615',1,4)||'-'||substr('20210615',5,2)||'-'||substr('20210615',7)

suvbin — Tue, 21 Feb 2023 06:05:14 GMT

with out using Substring how to do it.

john_wang — Tue, 21 Feb 2023 09:13:54 GMT

Hello @suvbin ,

May we know more information to understand the request well?

1- source/target sides database type

2- source/target sides column type

3- a sample of the data in source and what's expected results in target

Regards,

John.

Steve_Nguyen — Tue, 21 Feb 2023 13:28:36 GMT

try this article :