sql - To bifurcate integer value into HH:MM format -
I have a column with an integer datatype and it includes the time period in the format. I want to split these values in the MM format:
Time HHM ----------------- ---- 3 00 03 17 00 17 207 02 07 786 07 86 1234 12 34
with this string combination You can:
select time / 100 hh, mod (time, 100) mm as
If you They want zero-padded wire:
choose the correct ('00 '+ cast (time / 100), 2) in the form of HH, right (' 00 '+ modern Time (time, 100), 2) mm as
Comments
Post a Comment