PYTHON

epoch to datetime

#--------------------------------SQL SERVER----------------------------------
#use this to convert forom bigint unix to datetime
#replace 1500123123 with your number
select  DATEADD(second,1500123123, CAST('1970-01-01 00:00:00' AS datetime))

#it's way better to put this in a function and call the function 

convert epoch time

moment(epoch * 1000).toISOString()

epoch time convert

	long epoch = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").parse("01/01/1970 01:00:00").getTime()