Unanswered: Epoch date functions using INFORMIX 10
I am having a hard time understanding how to use or convert epoch time into database dates or manipulation thereof. I have records that store the date in integer format. I need to be able to group by the "date" of the epoch number and not include the time. Here is an example of a sql statement.
When I run this query I get the grouping down to the seconds. A possible 86400 results could return per user (one for each second of the day).