J
John
I have time from a table that comes in in clicks. I have a SQL to change it
to a non click format. but for some reason it is giveing me a output with
just the hours and not the min like this - 8:
Here is the SQL statement that I am using. Any help would be great. Thanks!!
cast(cast(Truncate("- Timecard Basic Detail"."Employee Report To Work Actual
Time",0) as int) as char) || ':' || left(right(cast( ((("- Timecard Basic
Detail"."Employee Report To Work Actual Time" - Truncate("- Timecard Basic
Detail"."Employee Report To Work Actual Time",0))*60)+100) as char),5),2)
to a non click format. but for some reason it is giveing me a output with
just the hours and not the min like this - 8:
Here is the SQL statement that I am using. Any help would be great. Thanks!!
cast(cast(Truncate("- Timecard Basic Detail"."Employee Report To Work Actual
Time",0) as int) as char) || ':' || left(right(cast( ((("- Timecard Basic
Detail"."Employee Report To Work Actual Time" - Truncate("- Timecard Basic
Detail"."Employee Report To Work Actual Time",0))*60)+100) as char),5),2)