Topic

#timezone

A time zone is an area which observes a uniform standard time for legal, commercial and social purposes. Time zones tend to follow the boundaries between countries and their subdivisions instead of strictly following longitude, because it is convenient for areas in frequent communication to keep the same time.

2 articles

0 followers

Explore #timezone

Articles

Mahabubur Rahman

Sep 22, 2024

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

SELECT CONVERT_TZ(displaytime,'GMT','MET'); should work if your column type is timestamp, or date Test how this works: SELECT CONVERT_TZ(a_ad_display.displaytime,'+00:00','+04:00')

#mysql #timezone

♡ 0 reactions0 comments577 views1 min read

You’re all caught up.

Topic

#timezone

2 articles

0 followers

Explore #timezone

Articles

Mahabubur Rahman

Sep 22, 2024

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

SELECT CONVERT_TZ(displaytime,'GMT','MET'); should work if your column type is timestamp, or date Test how this works: SELECT CONVERT_TZ(a_ad_display.displaytime,'+00:00','+04:00')

#mysql #timezone

♡ 0 reactions0 comments577 views1 min read

You’re all caught up.