Date conversion affects the CPU utilization

[lawrance]

Hi all,

The below mentioned code affects the CPU utilization and it reaches 80.

Could you please someone help me to resolve this problem.

We have three different date field

Date(date#(Field name, 'YYYY-MM-DD hh:mm:ss),' MM/DD/YYYY-MM-DD hh:mm:ss')  as Field_01

Date(date#(Field name, 'YYYY-MM-DD hh:mm:ss),' MM/DD/YYYY-MM-DD hh:mm:ss')  as Field_02

Date(date#(Field name, 'YYYY-MM-DD hh:mm:ss),' MM/DD/YYYY-MM-DD hh:mm:ss')  as Field_03

Thanks,

Lawrance A

[Anil_Babu_Samineni]

How you identify the CPU utilization? Can you explain little more

[pra_kale]

Hi,

Please check the join condition..if joins are not proper between Two tables then CPU utilisation may increase.