Time out timestamp

[#1]

I would like to get the time out of my timestamp field.

in the format: HH:MM:SS

I can get the date out of it with the next expression:

=Date(Floor(emptyings_date_time))

Now I need the time part

In addition, I would also want to calculate the differece between each time out of the timestamp.

[#2]

It's an application with SQL connection, I don't know how to make a small example with sample data

[Anonymous]

Hi,

It means the column "emptyings_date_time" is not in date format. You have to convert it first in date format before creating time field.

[Anonymous]

Just export few rows will be enough to understand the problem area.

[#5]

I exported the Time table to excel and loaded it into a new qvw.

[Anonymous]

Hi,

No issue in files. Getting below result,

[PradeepReddy]

now it's coming perfectly...

Date(A) - Giving Date

Time(A) - Giving  Time

so there might be some date format issue in your original application

[#8]

Apparently it does work, but only when I select one time from te timestamp field.

The date however always works.

I added two printscreens from my application.

The first one:

One city is selected and I want the hours to be filled in.

The second view:

I selected also one field from the timestamp table, now it fills in an hour.

The problem is that I want them to show like the dates in the first view.

[Anonymous]

Hi,

Just to check, are you calculating the time field in front end? Because I could see there are few timestamps in each days so calculating this in frontend won't be giving you expected result. Try using min or max function in your existing logic or calculate this in backend.

[#10]

I'am calculating this in the front-end.

The timestamp is the exact day and moment when a container was emptied.

I want to show for each day al the hours that a container was emptied.

For the date I just did: date(emptyings_date_time)

Now I have a problem with still linking the times to a certain date.

I also need the first and the last time that a container was emptied each day.

How do I make the link to the day?