Generate now as a time

We are trying to calculate the difference between a created time and the actual time and date it is now. We can do DATEDIFF between two dates but we need to generate NOW.

Any ideas how we create the NOW in a column?

Many thanks

Hi Ray,

You can use function NOW(). Refer this link.

Lets say new column name is
rightnow = NOW()

Regards,
Hemant

Many thanks we will give it a go