Monthly Archives: August 2018

convert epochtime to localtime in python

value = dt.datetime.fromtimestamp(1534953600)
print(value.strftime(‘%Y-%m-%d %H:%M:%S’))
print(time.strftime(“%Y-%m-%d %H:%M:%S”, time.localtime(1534953600)))

traffic_data[‘day1’] = pd.Series([dt.datetime.fromtimestamp(int(ts)).strftime(‘%Y-%m-%d %H:%M:%S’)
for ts in traffic_data[‘starttime’]]).values

traffic_data[‘day’] = pd.Series([time.strftime(“%Y-%m-%d %H:%M:%S”, time.localtime(int(ts)))
for ts in traffic_data[‘starttime’]]).values

postgres windows pgdump command

D:\downloads\postgresql-10.3-2-windows-x64-binaries\pgsql\bin>pg_dump.exe -U postgres -h 100.1.27.9 -p 5432 -d pldt -f D:\Onebox\HW-Projects\abcd\dbji.sql