Validate Syntax

LJ

Good day,

Just want to confirm if my syntax is correct?

CONCAT(FLOOR(([record_age] / 86400000)), ' days, ', FLOOR((([record_age] % 86400000) / 3600000)), ' hours, ', FLOOR((([record_age] % 3600000) / 60000)), ' minutes, and ', FLOOR((([record_age] % 60000) / 1000)), ' seconds')

I was intending to convert a milliseconds column to number of days, hours, minutes, or seconds.

Appreciate anyone suggestions.

Ashleigh

@LJ I think you need to remove or change the [] and the %

DavidChurchman

For the mod operation, you can't use %, you'll need the MOD() function.

For example, for your hours:

FLOOR( (MOD(record_age , 86400000) / 3600000)

Ashleigh

@LJ I think you need to remove or change the [] and the %

DavidChurchman

For the mod operation, you can't use %, you'll need the MOD() function.

For example, for your hours:

FLOOR( (MOD(record_age , 86400000) / 3600000)