SQL function returning NULL value .

[venkataramana_paidi]

Hi ,

I have to capture the max date from the table and I am using the below function .

$G_LastUpdate = sql('Omega00', 'select max(LAST_UPDATE) from EMP_DIM');

print($G_LastUpdate);

But it is returning the NULL value instead of the value. I have tried different varchar field in the  table but it is returning the value properly.

Please suggest what is wrong here . Why not it is working for datetime and working for varchar

I have tried in the SQL editor it is working fine . But It is not giving the DS script .

Thanks & Regards,

Venkata Ramana Paidi

[Former Member]

Please check the connection of datastore !! It may be possbile your datastore is pointing to some other database!

Thanks,

SB

[venkataramana_paidi]

Hi Swapnil,

I checked the DEPARTMENT with max function it is working fine. I have tried by changing the variable data type to date  from datetime it is working . What is the problem with the datetime data type here.

Thanks & Regards,

Ramana