How to prevent CONCAT function adding space in Postgresql?

1 vote

1 answer

1097 views

                          Postgresql-11

    select tick_time, nano_secs,
        concat( to_char(tick_time, 'MMDD HH24:MI:SS.US'),
                to_char(nano_secs, '000') )
    from ticks
    order by tick_time, nano_secs limit 100;

I want to concat 2 strings like above, but it always add a space char between the two strings.

How to prevent it doing that?

Thanks!
                        

Asked by Leon (411 rep)

Sep 16, 2022, 05:59 AM
Last activity: Sep 16, 2022, 06:56 AM

How to prevent CONCAT function adding space in Postgresql?

Related Questions