Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I find the timezone of a SQL Server database? [closed]

Tags:

timezone

sql

database

sql-server

Is there an easy way to find the timezone for datetime dataype of SQL Server database?

like image 321
Suresh Avatar asked Jun 21 '16 12:06

Suresh

1 Answers

You can use SYSDATETIMEOFFSET(). This will tell you the offset from GMT at the end.

SELECT SYSDATETIMEOFFSET()

2016-06-21 08:36:54.9753055 -04:00

like image 141
Siyual Avatar answered Sep 25 '22 19:09

Siyual
Sign in to Comment

Related questions

Using subquery to pull random value reveals same value every time
Switch id numbers of two rows in MySql
PostgreSQL cursors
How to modify datatype of a column with a default value
MYSQL Select from table, get newest/last 10 rows in table
Select the first 150 rows, then the next 150 and so on?
Join SQL Server tables on a like statement
Nesting queries in SQL
MySQL Inner Join Query Multiple Tables
SQL - search by beginning of a word
Get list of column names from a Firebird database table
Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
MySQL insert error : ER_BAD_FIELD_ERROR: Unknown column '2525' in 'field list'
SQL Get "ISO Year" for ISO Week
SQL LocalDb Automatic Instance Startup Failure when called from Visual Studio 2013, but not SQL Server Management Studio
How to select multiple rows filled with constants in Amazon Redshift?
Knex: Create migration with FOREIGN KEY
SUM of only TOP 10 rows
SQL - Unique Key, Primary Key & Foreign Key
indexing and query high dimensional data in postgreSQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!