In what timezone does the table calculation now() return?

Looker Tips & Resources Technical Tips & Tricks
,
1

Knowledge Drop

Last Tested: Jul 3, 2018

In databases that support timezone conversion, now() returns the time in the timezone set in the Query Time Zone property of the database connection for the explore.

In the case that the database does not support timezone conversion, now() returns the time in the timezone of the Application Time Zone in the general settings admin page.

2

Can you give an example?