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]

Hi Venkata ramana paidi,

how did u achieve this , I am facing same problem with Sybase ASE in sap bods,I want to capture the date time in a variable like this format

2016.04.14 15:03:31.450000000

Please help me in that

Thanks,

Narendra