Re: TimeZone shift problem in Flink SQL

2019-01-27 Thread 徐涛
Hi Rongrong, The event is really happens in Tuesday, January 22, 2019 9:03:02.001 PM, so I think the first function returns 1548162182001 is correct. It is the Unix epoch time when the event happens. But why the timestamp passed into the from_unixtime is changed to

Re: TimeZone shift problem in Flink SQL

2019-01-25 Thread Rong Rong
Hi Henry, Unix epoch time values are always under GMT timezone, for example: - 1548162182001 <=> GMT: Tuesday, January 22, 2019 1:03:02.001 PM, or CST: Tuesday, January 22, 2019 9:03:02.001 PM. - 1548190982001 <=> GMT: Tuesday, January 22, 2019 9:03:02.001 PM, or CST: Wednesday, January 23, 2019

Re: TimeZone shift problem in Flink SQL

2019-01-24 Thread Bowen Li
Hi, Did you consider timezone in conversion in your UDF? On Tue, Jan 22, 2019 at 5:29 AM 徐涛 wrote: > Hi Experts, > I have the following two UDFs, > unix_timestamp: transform from string to Timestamp, with the > arguments (value:String, format:String), return Timestamp >