StackOverflow Questions for Tag: convert-tz

BhavikKama
BhavikKama

Reputation: 8800

How to Convert UTC Date To Local time Zone in MySql Select Query

Score: 65

Views: 233203

Answers: 4

Read More
Johan
Johan

Reputation: 20773

Can MySQL convert a stored UTC time to local timezone?

Score: 93

Views: 174552

Answers: 6

Read More
SuspectT3
SuspectT3

Reputation: 3

my query is incorrect. convert_tz is causing incorrect values

Score: 0

Views: 64

Answers: 0

Read More
BostonAreaHuman
BostonAreaHuman

Reputation: 1469

convert_tz is taking on GMT at the end of the date although I'm converting to East Coast Time

Score: 0

Views: 25

Answers: 0

Read More
mohur
mohur

Reputation: 1895

convert_tz returns null

Score: 136

Views: 68226

Answers: 9

Read More
Gobi
Gobi

Reputation: 291

MySQL default time format UTC or GMT?

Score: 1

Views: 7716

Answers: 1

Read More
Martin Petercak
Martin Petercak

Reputation: 833

Mysql timezone and selecting rows from one day

Score: 4

Views: 4250

Answers: 4

Read More
TenG
TenG

Reputation: 4004

Mysql str_to_date with convert_tz returns NULL

Score: 0

Views: 631

Answers: 0

Read More
Stackoverflow
Stackoverflow

Reputation: 477

why SELECT in (IDENTIC: [version MySQL + SESSION.sql_mode + system_time_zone]) return NULL in CentOs 7 but GOAL + WARNING on W10?

Score: 0

Views: 83

Answers: 1

Read More
HermannMeyer
HermannMeyer

Reputation: 1

SQL Query: Unify Timezones

Score: 0

Views: 62

Answers: 0

Read More
Stephen Maher
Stephen Maher

Reputation: 228

Detect if a date is in Daylight saving time in MySql

Score: 2

Views: 8238

Answers: 4

Read More
BhavikKama
BhavikKama

Reputation: 8800

my sql query for last 7 days data?if data not there then even fetch date and shows with 0 or null

Score: 1

Views: 4100

Answers: 2

Read More
Akshay
Akshay

Reputation: 1

MariaDB convert_tz () (copying data by converting time zone on the fly)

Score: -1

Views: 472

Answers: 2

Read More
Lu Shi
Lu Shi

Reputation: 93

MySQL CONVERT_TZ() returns null when one of the arguments is "+14:00"

Score: 8

Views: 5145

Answers: 2

Read More
Satyr_99
Satyr_99

Reputation: 1

Mysql Timezone with React.js/Node.js

Score: 0

Views: 197

Answers: 1

Read More
Atis
Atis

Reputation: 93

MySQL MIN and сonvert_tz

Score: 0

Views: 94

Answers: 1

Read More
johnnyspo
johnnyspo

Reputation: 471

MySQL CONVERT_TZ()

Score: 47

Views: 97404

Answers: 3

Read More
slthomason
slthomason

Reputation: 383

MySql - Finding "today" and "yesterday" while using CONVERT_TZ

Score: 1

Views: 338

Answers: 1

Read More
Russell C.
Russell C.

Reputation: 1659

MySQL query for current GMT time

Score: 32

Views: 73963

Answers: 9

Read More
Sobin Augustine
Sobin Augustine

Reputation: 3775

How to use mySQL convert_tz functions in Laravel/Lumen query builder

Score: 1

Views: 1516

Answers: 0

Read More
PreviousPage 1Next