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?
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.