alibaba / alibaba/DataX

Mysql Reader关于时区设置问题

Open
#1,093 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

我的查询语句是需要进行计算的
例如
```
where time >= UNIX_TIMESTAMP( '2021-09-07' )
```
这个时候算出来的时间戳是使用的Mysql系统时间戳,

我想通过设置时区来解决
```
SET time_zone = '+08:00';
```
但是 mysql reader 不支持 多条SQL语句,也不能写preSql。
请问这种情况怎么解决。

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue names the MySQL reader and shows a query using UNIX_TIMESTAMP plus SET time_zone = '+08:00'; start by locating the reader's query and SQL-statement handling. There are no files or tests named, and done would require an agreed way to apply the requested timezone before this query runs.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.