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

Hi,
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.
Thanks.

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:
http://forums.teradata.com/forum/enterprise/convert-varchar-to-timestamp#comment-147303

Dieter

drmkd17 54 posts Joined 10/12
05 Apr 2016

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

You must sign in to leave a comment.