Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

How to split this in to Date & Time Fields?

Capture.JPG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

LOAD

     Date(floor(loggedintime)) as DateField,

     Time(frac(loggedintime)) as TimeField,

...

View solution in original post

2 Replies
swuehl
MVP
MVP

LOAD

     Date(floor(loggedintime)) as DateField,

     Time(frac(loggedintime)) as TimeField,

...

Colin-Albert

Splitting a timestamp into separate date and time values will reduce the memory required to hold the data compared to a timestamp field. This is often a good idea!

You can use floor() to extract the date part of a timestamp, and frac() to get the time portion.

Have a look at these documents for more details

Get the Dates Right

QlikView Date fields