Let t=now() not working

[#1]

Not sure what I'm missing here but for some reason I cannot get a result for my Let statement.

Statement:

Let t=now()

Result:  Null

Seems to work fine with a set statement.

Any ideas?

[kaushiknsolanki]

Hi Steve,

     One thing to confirm here, is you want the NOW() word in variable or the  current Date and time.

     If you need only NOW() word in variable then use below.

     SET t  = NOW();

     and

     if you want current date and time, use below statement.

     Let  t = now();

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

I'm looking for current date and time.

Thanks.