Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion
Partner - Champion

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