Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date and time from TimeStamp

Hi,

How can return only the date from a Time Stamp field.

Time Stamp return: 1/1/2011 4.44 PM for example!

It will be great if i can have the time seperated as well.

Note that I am loading the data from QVD.

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

floor(TimeStamp) will give data

TimeStamp - Floor(TimeStamp) will give Time

Both will have to be formatted.

View solution in original post

12 Replies
m_woolf
Master II
Master II

floor(TimeStamp) will give data

TimeStamp - Floor(TimeStamp) will give Time

Both will have to be formatted.

Not applicable
Author

you can truncate the time using function:

DayStart()

Not applicable
Author

An do you know how to format the time..?

Thxs

m_woolf
Master II
Master II

use the timestamp function

Not applicable
Author

Thxs..

Not applicable
Author

Hi,

I am getting wrong nrs on the time ..

would you please explain how to frmat the time from TimeStamp?

Thxs

m_woolf
Master II
Master II

What wrong numbers are you getting?

Not applicable
Author

Example of time: 0.60395833332586 while I want it to show as hh:MM AM or something simillar

Thxs

m_woolf
Master II
Master II

For example:

=timestamp(YourField,'h:mm:ss TT')