Time database fields
Hi,
Could someone please help me to convert TIMESPENT fields to hh:mm:ss.
I get numbers such as 97200000, or 71000 but do not know how to convert this.
I can't use FROM_UNIXTIME because I am using an Access database for reporting.
The data is stored in Access, therefore it must be queried in Access. Beforehand the data is imported from the MySQL database.
Can someone please help, we need to do the first month's billing.
Peter Bardenhagen
Could someone please help me to convert TIMESPENT fields to hh:mm:ss.
I get numbers such as 97200000, or 71000 but do not know how to convert this.
I can't use FROM_UNIXTIME because I am using an Access database for reporting.
The data is stored in Access, therefore it must be queried in Access. Beforehand the data is imported from the MySQL database.
Can someone please help, we need to do the first month's billing.
Peter Bardenhagen