Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlikview and I am working in cognos for last 2 years. I came accross a situation and I am unable to find a solution for that.
I want to convert EPOCh dates to date format. we have a function in oracle database which we use in cognos to do the same.
Is it possible to do that in QlikView? If not, Is there any other way to achieve this?
Thanks In Advance
Have a look on these various blog-postings: http://community.qlik.com/search.jspa?q=date+format&author=%2Fpeople%2F4003&type=post
- Marcus
Hi,
1. If that function is simple then Call the function as normal sql statement from Qlik View as below.
QVtable:
Load *;
select * from [DB]..StringToList('1:2',':');
2. Else Use stored procedure to call the function and execute the procedure in Qlik View
If this is a UNIX date/time, you should use the method described here: transform UNIX date format to ASCII /Windows format
HIC