Figuring out database timezone

Question

Does anybody know of a way to alter a time zone on a SQL database? Is there any tool that could find the objects using the date and time?

Answer 1

The easiest way I have used to see if any objects are using a particular command is syscomments. The text column of this table in SQL 2000 has the actual command that makes up the object.

The caveat to this is if the procedure was created using WITH ENCRYPTION you will not be able to see or check the text column. I believe something like this should return what you are looking for:

SELECT OBJECT_NAME(ID), Text
FROM syscomments
WHERE Text LIKE '%GetDate%'

Answer 2

Assuming SQL Server

• getdate gives local server time
• getutcdate gives utc / gmt

There is no timezone setting or changes possible inside SQL Server

Answer 3

To alter the database's timezone you might be able to use something like

ALTER DATABASE your-database-name SET TIMEZONE TO 'AST';

The syntax varies from vendor to vendor. Some platforms rely on the host operating system instead. To get platform-specific answers, tag your question with the dbms you use--PostgreSQL, SQL Server, Oracle, etc.

It's not clear what objects you want to find by date and time.