PHP microtime to MySQL timestamp - Revision history

Unknown user: Text replacement - "== references ==" to "== References =="

2022-07-10T09:12:41Z

Text replacement - "== references ==" to "== References =="

← Older revision		Revision as of 17:12, 10 July 2022
Line 25:		Line 25:
	</pre>		</pre>

	== ~~references~~ ==		== References ==
	<references/>		<references/>

Planetoid: /* references */

2019-07-24T03:42:32Z

references

← Older revision		Revision as of 11:42, 24 July 2019
Line 30:		Line 30:
	[[Category:PHP]] [[Category:Programming]]		[[Category:PHP]] [[Category:Programming]]
	[[Category:Web_Dev]]		[[Category:Web_Dev]]
			[[Category:Time river]]

Planetoid at 08:53, 19 May 2017

2017-05-19T08:53:57Z

← Older revision		Revision as of 16:53, 19 May 2017
Line 1:		Line 1:
	{{exclaim}} ~~Lose~~ the accuracy after conversion. Microtime ex: 1426299057.8639 will lost the numeric after point (.8639) after saved to {{kbd \| key = TIMESTAMP}} type ex: 2015-03-14 10:10:57 (equals to 1426299057)		{{exclaim}} Warning: It will lose the accuracy after conversion. Microtime ex: 1426299057.8639 will lost the numeric after point (.8639) after saved to {{kbd \| key = TIMESTAMP}} type ex: 2015-03-14 10:10:57 (equals to 1426299057)

	1. Check the MySQL server's current time zone: {{kbd \| key =<nowiki>show variables like '%time_zone%';</nowiki>}}<ref>[http://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html MySQL :: MySQL 5.7 Reference Manual :: 10.6 MySQL Server Time Zone Support]</ref>. It's also the timezone which the data with {{kbd \| key = TIMESTAMP}} type stored. example output:		1. Check the MySQL server's current time zone: {{kbd \| key =<nowiki>show variables like '%time_zone%';</nowiki>}}<ref>[http://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html MySQL :: MySQL 5.7 Reference Manual :: 10.6 MySQL Server Time Zone Support]</ref>. It's also the timezone which the data with {{kbd \| key = TIMESTAMP}} type stored. example output:

Planetoid at 08:46, 17 April 2015

2015-04-17T08:46:47Z

← Older revision		Revision as of 16:46, 17 April 2015
Line 24:		Line 24:
	//$timestamp: 2015-03-13 10:10:57		//$timestamp: 2015-03-13 10:10:57
	</pre>		</pre>

			== references ==
			<references/>

	[[Category:PHP]] [[Category:Programming]]		[[Category:PHP]] [[Category:Programming]]
	[[Category:Web_Dev]]		[[Category:Web_Dev]]

Planetoid: Created page with "{{exclaim}} Lose the accuracy after conversion. Microtime ex: 1426299057.8639 will lost the numeric after point (.8639) after saved to {{kbd | key = TIMESTAMP}} type ex: 2015-..."

2015-04-17T08:46:30Z

Created page with "{{exclaim}} Lose the accuracy after conversion. Microtime ex: 1426299057.8639 will lost the numeric after point (.8639) after saved to {{kbd | key = TIMESTAMP}} type ex: 2015-..."

New page

{{exclaim}} Lose the accuracy after conversion. Microtime ex: 1426299057.8639 will lost the numeric after point (.8639) after saved to {{kbd | key = TIMESTAMP}} type ex: 2015-03-14 10:10:57 (equals to 1426299057)

1. Check the MySQL server's current time zone: {{kbd | key =<nowiki>show variables like '%time_zone%';</nowiki>}}<ref>[http://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html MySQL :: MySQL 5.7 Reference Manual :: 10.6 MySQL Server Time Zone Support]</ref>. It's also the timezone which the data with {{kbd | key = TIMESTAMP}} type stored. example output:

<pre>
Variable_name Value
system_time_zone CST
time_zone SYSTEM ## my SYSTEM timezone is Asia/Taipei
</pre>

2. PHP codes ([http://ideone.com/iRy0fI online demo])
<pre>
//set the current timezone
date_default_timezone_set("Asia/Taipei");

$microtime = microtime(true);
//1426299057.8639

list($second, $numeric_after_point) = explode(".", $microtime);
//$second: 1426299057
//$numeric_after_point: 8639

$timestamp = date('Y-m-d H:i:s', $second);
//$timestamp: 2015-03-13 10:10:57
</pre>

[[Category:PHP]] [[Category:Programming]]
[[Category:Web_Dev]]