Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

SQL Functions

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


Tags (1)
3 Replies

Re: SQL Functions

meet_purushu
New Contributor III

Re: SQL Functions

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

Employee
Employee

Re: SQL Functions

If this is a UNIX date/time, you should use the method described here: transform UNIX date format to ASCII /Windows format

HIC

Community Browser