SQL Functions

[#1]

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

[marcus_sommer]

Have a look on these various blog-postings: http://community.qlik.com/search.jspa?q=date+format&author=%2Fpeople%2F4003&type=post

- Marcus

[Anonymous]

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

[hic]

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

HIC