Show date time in two separate columns

[bhavvibudagam]

Hi,

        Can any one please help me.

I have one date filed in the format of '23/08/2016 06:55:60 PM' I want to display this Date in two separate columns i.e Date contains 23/08/2016 in one column and Time contains 06:55:60 PM in another column in script.

[marcus_sommer]

You could do it with:

date(floor(YourTimestamp)) as date,

time(frac(YourTimestamp)) as time

...

and please choose the next time another community area maybe New to QlikView - then this isn't a bug.

- Marcus

[oknotsen]

This is not a bug.

Topic started multiple times. Other topic here:

Show date time in two separate columns

Topic locked. Warning send.