How to Show value in a Proper Timestamp Format

[brijeshvma]

Hi all , I am fetching a data from big Query . everything in fine . but Timestamp format i am getting in not Perfect .

Kindly help me to achieve this. please find the attachment.

i Attached , Qlikview output image , Bigquery image , sample data in excel and qvw .

[amit_saini]

Hi,

Try setting from here:

Thanks

AS

[sunny_talwar]

In this file you are loading the data from the csv file, I think you need to fix this issue while laoding the data from Big Query. What is the script that you are using?

[Colin-Albert]

These posts should help you get the correct timestamp values.

Why don’t my dates work?

QlikView Date fields

[sunny_talwar]

Amit the date doesn't seem to be the correct date. Check the screenshot

[amit_saini]

Yes Sir

[brijeshvma]

Hi Sunny,

Thanks for your reply .

I am using a QvSource connector to fetch data .

i am attaching Qvd as well for the same .

Can you what i need to do .

[brijeshvma]

Hi,

I have a script in Date_add(date_time,330,"MINUTE") as date_time_IST in big query to create this Field. can you able to tell me what i can do so qlikview can understand the timestamp format

[Peter_Cammaert]

Can you tell us in what environment or which programming language these large timestamp values were created? QVSource extracts these values from somwhere. And digits are just digits. The cannot tell us anything about granularity or starting date.

Peter

[brijeshvma]

i am extracting data from big query .

select date, Date_add(date_time,330,"MINUTE") as date_time_IST,datetime

from(

SELECT date,SEC_TO_TIMESTAMP(datetime/1000) as date_time ,datetime

FROM (

SELECT date,INTEGER(JSON_EXTRACT(hits.eventInfo.eventLabel,'$.time_stamp')) as datetime,