Green Time converted to normal time, green time converted

Green Time converted to normal time, green time converted

Uscdbmt @ rac1: ~> Date + % s
1414741902

In oracle, how does one convert this 1414741902 to a normal time format?

 

Select Numtodsinterval (1414741902-TO_NUMBER (SUBSTR (TZ_OFFSET (sessiontimezone), 1, 3) * 3600, 'second') + to_date ('2017-1-1 ', 'yyyy/mm/dd') from dual;

Select Numtodsinterval (1414741902-8*3600, 'second') + to_date ('2017-1-1 ', 'yyyy/mm/dd') from dual;

 

 

Current Time to Greenwich Mean Time:

Select (to_number (to_date ('2014/1/31 15:51:42 ', 'yyyy/mm/dd hh24: mi: ss')-to_date ('20140901', 'yyyymmdd ')) * 86400)-TO_NUMBER (SUBSTR (TZ_OFFSET (sessiontimezone), 1, 3) * 3600 from dual;

Green Time is converted to Beijing Time

Green's time plus 8 hours will change to Beijing time.
That is, on January 1, April 4 and on the morning of October 4

How to convert the green rule time to the current time in php

$ Aa = strtotime ("greenlord time ")

Echo date ("Y -- m-d H: I: s", $ aa)