Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD
Date(floor(loggedintime)) as DateField,
Time(frac(loggedintime)) as TimeField,
...
LOAD
Date(floor(loggedintime)) as DateField,
Time(frac(loggedintime)) as TimeField,
...
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