Mysql Reader关于时区设置问题
Open
- 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