Offset
The time difference between Shanghai and Bogotá is 13 hours.
Shanghai (CST) is ahead of Bogotá (COT).
CST: UTC+8
COT: UTC-5
Neither Shanghai nor Bogotá is currently observing daylight saving time.
When to schedule
Standard business hours (9 AM–5 PM, Mon–Fri) in Shanghai and Bogotá don't overlap on the same weekday. Bogotá is 13 hours behind Shanghai.
Realistic options: hand off asynchronously, or stretch one side by an hour to catch the other team at the start or end of their day.
Public holidays in 2026
National public holidays can affect availability — a counterpart is likely off work on their own holidays, so it's worth planning meetings and deadlines around them.
China
- New Year's DayThu, Jan 1
- Chinese New Year (Spring Festival)Tue, Feb 17
- Labour DayFri, May 1
- Dragon Boat FestivalFri, Jun 19
- Mid-Autumn FestivalFri, Sep 25
- National DayThu, Oct 1
Colombia
- New Year's DayThu, Jan 1
- EpiphanyMon, Jan 12
- Saint Joseph's DayMon, Mar 23
- Maundy ThursdayThu, Apr 2
- Good FridayFri, Apr 3
- Labour DayFri, May 1
- Ascension DayMon, May 18
- Corpus ChristiMon, Jun 8
- Sacred HeartMon, Jun 15
- Saint Peter and Saint PaulMon, Jun 29
- Declaration of IndependenceMon, Jul 20
- Battle of BoyacáFri, Aug 7
- Assumption of MaryMon, Aug 17
- Columbus DayMon, Oct 12
- All Saints’ DayMon, Nov 2
- Independence of CartagenaMon, Nov 16
- Immaculate ConceptionTue, Dec 8
- Christmas DayFri, Dec 25
About these zones
Quick reference
Full 24-hour conversion table — tap any time to open it in the converter.
| Shanghai | Bogotá | Day |
|---|---|---|
| 12:00 am | 11:00 am | -1 day |
| 1:00 am | 12:00 pm | -1 day |
| 2:00 am | 1:00 pm | -1 day |
| 3:00 am | 2:00 pm | -1 day |
| 4:00 am | 3:00 pm | -1 day |
| 5:00 am | 4:00 pm | -1 day |
| 6:00 am | 5:00 pm | -1 day |
| 7:00 am | 6:00 pm | -1 day |
| 8:00 am | 7:00 pm | -1 day |
| 9:00 am | 8:00 pm | -1 day |
| 10:00 am | 9:00 pm | -1 day |
| 11:00 am | 10:00 pm | -1 day |
| 12:00 pm | 11:00 pm | -1 day |
| 1:00 pm | 12:00 am | Same day |
| 2:00 pm | 1:00 am | Same day |
| 3:00 pm | 2:00 am | Same day |
| 4:00 pm | 3:00 am | Same day |
| 5:00 pm | 4:00 am | Same day |
| 6:00 pm | 5:00 am | Same day |
| 7:00 pm | 6:00 am | Same day |
| 8:00 pm | 7:00 am | Same day |
| 9:00 pm | 8:00 am | Same day |
| 10:00 pm | 9:00 am | Same day |
| 11:00 pm | 10:00 am | Same day |
Daylight saving time
Neither Shanghai nor Bogotá observes daylight saving time. The offset between these zones remains constant year-round.
See the daylight saving time page for transition dates across every time zone.
Daylight today
- Sunrise
- 4:51 AM
- Sunset
- 6:56 PM
- Day length
- 14h 5m
- Sunrise
- 5:44 AM
- Sunset
- 6:07 PM
- Day length
- 12h 23m
Daylight overlap: 2h 16m — 4:51 AM–7:07 AM in Shanghai (3:51 PM–6:07 PM in Bogotá). Both locations are in daylight during this window.
Cities in these zones
Other cities in China Standard Time
Other cities in Colombia Time
Browse all cities to see the current local time anywhere.
Airports in these zones
Airports in China Standard Time
- PVG
- SHA
- PEK
- PKX
- SZX
- CAN
- FUO
- CTU
- TFU
- TSN
Airports in Colombia Time
- BOG
- CLO
- EOH
- MDE
Related conversions
Common conversions
- What is 9:00 am Shanghai in Bogotá?
- 9:00 am Shanghai is 8:00 pm Bogotá, the previous day.
- What is 12:00 pm Shanghai in Bogotá?
- 12:00 pm Shanghai is 11:00 pm Bogotá, the previous day.
- What is 12:30 pm Shanghai in Bogotá?
- 12:30 pm Shanghai is 11:30 pm Bogotá, the previous day.
- What is 2:00 pm Shanghai in Bogotá?
- 2:00 pm Shanghai is 1:00 am Bogotá.
- What is 5:00 pm Shanghai in Bogotá?
- 5:00 pm Shanghai is 4:00 am Bogotá.
- What is 11:30 pm Shanghai in Bogotá?
- 11:30 pm Shanghai is 10:30 am Bogotá.