All Forums Database
Neha_Potdar 1 post Joined 11/15
01 Apr 2016
Improving query performance

Is there any query to pad a zero only if the hour/ min is single digit? Otherwise display as it is. I am able to do this using substring and trim, but the query is taking too long. Is the any easy way for this? I am having approximately 24 M records. Any help  is appreciated.

dnoeth 4628 posts Joined 11/04
01 Apr 2016

Assuming this is for a date/time column you can use a regex, there was a similar thread:


drmkd17 54 posts Joined 10/12
05 Apr 2016

Just wanted to compare 
CAST and TO_NUMBER. Which one performs betteR?

You must sign in to leave a comment.