SELECT offset ,datetime('now','+offset minutes', 'localtime')

This query i rebuild SELECT time('now','+30 minutes') to a more complex one where the offset (minutes) are my problem.

This query isn't working but how i get it done.

SELECT offset ,datetime('now','+offset minutes', 'localtime') from database where 1

How to put the offset value correct between '+offset minutes'

Thanks in advance