topic Convert timestamp to Date in QlikView

Convert timestamp to Date

stekol61 — Thu, 19 May 2016 08:29:59 GMT

Hi!

In the enclosed qvw i have loaded Date with the format "2016/05/18 00:00:00"

I want to covert this to the format "2016-05-18".

How can this be done in the load script?

/Stefan

sunny_talwar — Thu, 19 May 2016 13:00:54 GMT

Try this:

SET DateFormat='YYYY-MM-DD';

LOAD Date(Date#(Left(Date, 10), 'YYYY/MM/DD')) as Date,

[peakCpuUsage (avg)],

[averageCpuUsage (avg)],

ENTRY

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

swuehl — Thu, 19 May 2016 13:02:49 GMT

Set your default formats to your format used to correctly interpret your timestamps as such:

SET DateFormat='YYYY-MM-DD';

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff]';

Then you can use

DayName(Date) as PureDate

= DayName(Date)

in an expression

swuehl — Thu, 19 May 2016 13:04:05 GMT