Timestamp SQL Conversion

[#1]

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 · Accepted solution]

if you want a date fromDateRaised

date(Floor(DateRaised))

[#3]

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

[jpenuliar]

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

Load *,

floor(date) as x;

select

...

from

[Gysbert_Wassenaar]

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

[#6]

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

As always the QV Community Rocks !