## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> | | CONVERTNUMERICTOTIME[CONVERTNUMERICTOTIME]:::quoted CONVERTNUMERICTOTIME --> End((END)) ``` ## Purpose The `CONVERTNUMERICTOTIME` SQL function converts hours with decimal numbers to time Parameters: - Input: number to be converted to time. - Show Seconds (optional): accepts boolean input. - Zero Change (optional): when enabled and input is 0, shows Zero Text. - Zero Text (optional): text to display when input is 0 and Zero Change is true. - Show Days (optional): accepts boolean input. Returns: the trimmed text.