The column must be a datetime dtype, for example after using pd.to_datetime. Then, you can use tz_localize to change the time zone, a naive timestamp corresponds to time zone None: testdata[‘time’].dt.tz_localize(None) Unless the column is an index (DatetimeIndex), the .dt accessor must be used to access pandas datetime functions.
I also recommend using Joda as mentioned before. Solving your problem using standard Java Date objects only can be done as follows: // **** YOUR CODE **** BEGIN **** long ts = System.currentTimeMillis(); Date localTime = new Date(ts); String format = “yyyy/MM/dd HH:mm:ss”; SimpleDateFormat sdf = new SimpleDateFormat(format); // Convert Local Time to UTC (Works … Read more
I have the same issue. I get a date as a String, for example: ‘2016-08-25T00:00:00’, but I need to have Date object with correct time. To convert String into object, I use getTimezoneOffset: var date = new Date(‘2016-08-25T00:00:00’) var userTimezoneOffset = date.getTimezoneOffset() * 60000; new Date(date.getTime() – userTimezoneOffset); getTimezoneOffset() will return ether negative or positive … Read more