topic How to display only the timestamp from a date? in QlikView

How to display only the timestamp from a date?

ecrobles18 — Tue, 23 Feb 2016 15:58:46 GMT

Currently I have a table with multiple date fields that contain a timestamp. I have been asked to separate these two values into separate fields. To isolate the date in the table I have used date(floor(datefield)) and it has worked as it should however, I have used timestamp(datefield) to isolate the timestamp and it seems to be working for only one date. All the other date fields are returning 12:00 am for the timestamp. I should also mention that I have changed the number format to time and still nothing. Below I have provided an example of the issue I am facing. Any help can be provided would be greatly appreciated. Thank you in advance.

Time should be showing up as 9:12:25 AM

Time shows up correctly and I have used the same function to isolate time.

Re: How to display only the timestamp from a date?

sunny_talwar — Tue, 23 Feb 2016 18:23:30 GMT

Try this:

Time(Frac([Receive Dt])) as Receive_Time

Re: How to display only the timestamp from a date?

ecrobles18 — Tue, 23 Feb 2016 19:06:56 GMT

So, essentially I would have to script this in order get the result I am looking for?

Re: How to display only the timestamp from a date?

sunny_talwar — Tue, 23 Feb 2016 19:19:41 GMT

My bad, I think the issue might be that those dates don't have time component attached to them. The way you can check the time component is by adding a num() function and see if the number is an integer or decimal. If it is decimal, then you do have time component, else you just have date with no time.