How to use SET statements?

[kesavkolla]

Postgres allow to add SET statements to set some parameters.

Eg:
SET datestyle TO postgres, dmy;
SET TIME ZONE 'America/Los_Angeles';

How can use these SET statements as part of executing query?

Eg: I would like to run this

SET TIME ZON 'America/Los_Angeles';
SELECT NOW()

Execute batch is not returning results so can't use executeBatch method. Is there any way to achieve this?

[chandr-andr]

@kesavkolla Maybe do it in different queries?