Date issue

[Mahamed_Qlik]

Hi 

while loading the date column directly from database we are getting long string as result.

for example 

Date

1441618798583

1441618798582

How would I convert it to proper date format

[MartW]

can you also tell what the proper output is you where expecting?

from the looks of it this would be an UNIX timestamp. this can be formatted very easily in the Qlik load script.

take a look at this post:

https://community.qlik.com/t5/QlikView-App-Dev/Convert-unix-time-stamp-to-date-and-time/td-p/384453 

Quick NOTE: when you perform this calculation in QLIK, this can only be done in Qlik script.

so don't use that Qlikscript in the SQL statement.

// Qlik Script
LOAD 
Date#(orderDate, 'YYYYMMDD') as OrderDate;
// SQL statement: 
SELECT OrderDate FROM _;