topic Re: Timestamp SQL Conversion in QlikView

Timestamp SQL Conversion

Fri, 01 May 2015 10:33:23 GMT

Hi All,

I am having an issue with some timestamp columns in Qlikview

I want to convert DateRaised to a Date format in Qlikview (DD/MM/YYY) so it works better with my master calendar.

The data all runs through but when presented in a table the Master Calendar field does not populate every row as it is only looking for DD/MM/YYYY

What is the best way in a SQL Select to convert the timestamp?

Thanks in advance.

maxgro — Fri, 01 May 2015 10:40:49 GMT

if you want a date fromDateRaised

date(Floor(DateRaised))

Fri, 01 May 2015 10:43:37 GMT

Thanks Massimo, that does not work in the Select statement though, so do I need to declare it in a Load Statement?

jpenuliar — Fri, 01 May 2015 10:45:09 GMT

You can do a preceding load on top of your select script.

Load *,

floor(date) as x;

select

...

from

Gysbert_Wassenaar — Fri, 01 May 2015 10:48:07 GMT

Use the convert or cast function. See CAST and CONVERT (SQL Server Compact)

Fri, 01 May 2015 10:51:46 GMT

Thanks for your help guys a combination of Massimo and Jonathans answers have done the trick

As always the QV Community Rocks !