topic Re: Date settings in QlikView

Date settings

Anonymous — Tue, 04 Feb 2014 10:14:59 GMT

Hi,

In a database, I have the following date format that I can not convert to 'dd-mm-yyyy ".

example:

Last_udated_date
1382623150
1391500439
1391500540
1391500803

Who has an idea?

Best regards,

Arjan

Re: Date settings

MayilVahanan — Tue, 04 Feb 2014 10:21:04 GMT

Can you say, which format is in database?

Re: Date settings

luis_pimentel — Tue, 04 Feb 2014 10:21:58 GMT

That looks like Unix Time Format (based on seconds since standard epoch of 1/1/1970)

1391500803 = Tue, 04 Feb 2014 08:00:03 GMT

Re: Date settings

Anonymous — Tue, 04 Feb 2014 10:23:04 GMT

Mysql database Mantis bugtraking

Van: Mayil Vahanan Ramasamy

Verzonden: dinsdag 4 februari 2014 11:22

Aan: Arjan IJlenhave

Onderwerp: Re: - Date settings

Qlik Community<http://community.qlik.com/>

Date settings

reply from Mayil Vahanan Ramasamy<http://community.qlik.com/people/MayilVahanan?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/461463?et=watches.email.thread#461463>

Re: Date settings

agilos_mla — Tue, 04 Feb 2014 10:23:54 GMT

It is the unix date format please convert like this :

QV Date = 25569 + <UnixDate> / 86400

Michael

Re: Date settings

luis_pimentel — Tue, 04 Feb 2014 10:24:51 GMT

Try

In QlikView script a possible implementation to convert from a Unix timestamp to the local time could be:

Timestamp = ConvertToLocalTime(Date(MakeDate(1970, 1, 1) + (<timestamp_field> / 86400)), '<time_zone>')

Timestamp = ConvertToLocalTime(Date(25569 + (<timestamp_field> / 86400)), '<time_zone>')

Re: Date settings

Tue, 04 Feb 2014 10:25:19 GMT

A QV date should be around 40,000

since the calendar starts from 31DEC1899, 00:00:00

Fabrice