Get the Time of Day from a Field that is all seconds.
Hope somebody can help with this one:
I have a field that is defined as having all seconds, how can I get the Time of Day out of that field.
field is 908022961 (seconds)
to_date('19900101','yyyymmdd') + "starttime"/86400 as startDate, (From SQL---but would like to use Crystal to get the Time of Day).
it will convert to this date 2018-10-10 with the above statement.
Date is 10/10/2018, but I need to find the time of day for this.
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.