Convert date time from zulu format - Revision history

Unknown user at 02:57, 27 April 2023

2023-04-27T02:57:14Z

← Older revision		Revision as of 10:57, 27 April 2023
Line 1:		Line 1:
	Convert date time from Zulu format or convert date time to Zulu format		Convert date time from Zulu format ([https://en.wikipedia.org/wiki/ISO_8601 ISO 8601]) or convert date time to Zulu format

	== Convert date time from Zulu format ==		== Convert date time from Zulu format ==

Unknown user: /* Convert date time from Zulu format */

2023-04-26T11:12:38Z

Convert date time from Zulu format

← Older revision		Revision as of 19:12, 26 April 2023
Line 2:		Line 2:

	== Convert date time from Zulu format ==		== Convert date time from Zulu format ==
	Convert date time from T Z format (ISO 8601 format<ref>[https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]</ref>; Zulu time format<ref>[https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]</ref>) e.g. {{kbd \|key=~~2020-05-08T10~~:01:45Z}} or {{kbd \|key=~~2020-05-06T22~~:48:51.660Z}}		Convert date time from T Z format (ISO 8601 format<ref>[https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]</ref>; Zulu time format<ref>[https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]</ref>) e.g. {{kbd \|key={{Template:Today}}T10:01:45Z}} or {{kbd \|key={{Template:Today}}T22:48:51.660Z}}

	=== PHP approach ===		=== PHP approach ===
Line 36:		Line 36:
	-- returns null		-- returns null
	</pre>		</pre>


	== Convert date time to Zulu format ==		== Convert date time to Zulu format ==

Unknown user at 11:09, 26 April 2023

2023-04-26T11:09:23Z

← Older revision		Revision as of 19:09, 26 April 2023
Line 1:		Line 1:
			Convert date time from Zulu format or convert date time to Zulu format

			== Convert date time from Zulu format ==
	Convert date time from T Z format (ISO 8601 format<ref>[https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]</ref>; Zulu time format<ref>[https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]</ref>) e.g. {{kbd \|key=2020-05-08T10:01:45Z}} or {{kbd \|key=2020-05-06T22:48:51.660Z}}		Convert date time from T Z format (ISO 8601 format<ref>[https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]</ref>; Zulu time format<ref>[https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]</ref>) e.g. {{kbd \|key=2020-05-08T10:01:45Z}} or {{kbd \|key=2020-05-06T22:48:51.660Z}}

	== PHP approach ==		=== PHP approach ===
	Coordinated Universal Time (UTC)		Coordinated Universal Time (UTC)
	<pre>		<pre>
Line 15:		Line 18:
	</pre>		</pre>

	== MySQL approach ==		=== MySQL approach ===
	Coordinated Universal Time (UTC)		Coordinated Universal Time (UTC)
	<pre>		<pre>
Line 34:		Line 37:
	</pre>		</pre>


			== Convert date time to Zulu format ==
			=== PHP approach ===

			<pre>
			// 指定時間
			$dateTimeString = "2023-04-26 19:01:23";

			// 特定時區的 identifier (識別符，例如 UTC+8）
			$timeZoneIdentifier = 'Asia/Taipei'; // 'Asia/Taipei' 是 UTC+8 的其中一個時區識別符

			// 建立 DateTimeZone 物件，指定時區
			$timeZone = new DateTimeZone($timeZoneIdentifier);

			// 建立 DateTime 物件，解析日期時間字串，並設置時區
			$dateTime = new DateTime($dateTimeString, $timeZone);

			// 將 DateTime 物件的時區設置為 UTC
			$dateTime->setTimezone(new DateTimeZone('UTC'));

			// 格式化日期時間為 Zulu 時間格式並輸出
			echo $dateTime->format('Y-m-d\TH:i:s.000\Z');
			// 輸出：2023-04-26T11:01:23Z
			</pre>

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

			== Further readings ==
	* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]		* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]
	* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]		* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]
	* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)]		* MySQL [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)]
	* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format DATE_FORMAT(date,format)]		* MySQL [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format DATE_FORMAT(date,format)]
			* PHP [https://www.php.net/manual/en/function.date-default-timezone-set.php PHP: date_default_timezone_set - Manual]

	[[Category:PHP]]		[[Category:PHP]]

Unknown user: Planetoid moved page Convert date time from t z format to Convert date time from zulu format

2023-04-26T11:02:10Z

Planetoid moved page Convert date time from t z format to Convert date time from zulu format

← Older revision	Revision as of 19:02, 26 April 2023
(No difference)

Unknown user at 10:59, 8 May 2020

2020-05-08T10:59:00Z

← Older revision		Revision as of 18:59, 8 May 2020
Line 1:		Line 1:
	Convert date time from T Z format (ISO 8601 format; Zulu time format) e.g. {{kbd \|key=2020-05-08T10:01:45Z}} or {{kbd \|key=2020-05-06T22:48:51.660Z}}		Convert date time from T Z format (ISO 8601 format<ref>[https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]</ref>; Zulu time format<ref>[https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]</ref>) e.g. {{kbd \|key=2020-05-08T10:01:45Z}} or {{kbd \|key=2020-05-06T22:48:51.660Z}}

	== PHP approach ==		== PHP approach ==
Line 36:		Line 36:

	== References ==		== References ==
	* [https:/~~/en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]~~		<references />
	* [https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]

	* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]		* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]
	* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]		* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]

Unknown user: /* References */

2020-05-08T10:57:40Z

References

← Older revision		Revision as of 18:57, 8 May 2020
Line 37:		Line 37:
	== References ==		== References ==
	* [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]		* [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]
			* [https://greenwichmeantime.com/articles/history/zulu/ Zulu Time \| GMT]
	* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]		* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]
	* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]		* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]

Unknown user at 10:57, 8 May 2020

2020-05-08T10:57:09Z

← Older revision		Revision as of 18:57, 8 May 2020
Line 1:		Line 1:
	Convert date time from T Z format (ISO 8601 format~~, Z(ulu)~~ time) e.g. {{kbd \|key=2020-05-08T10:01:45Z}} or {{kbd \|key=2020-05-06T22:48:51.660Z}}		Convert date time from T Z format (ISO 8601 format; Zulu time format) e.g. {{kbd \|key=2020-05-08T10:01:45Z}} or {{kbd \|key=2020-05-06T22:48:51.660Z}}

	== PHP approach ==		== PHP approach ==

Unknown user: /* References */

2020-05-08T10:56:11Z

References

← Older revision		Revision as of 18:56, 8 May 2020
Line 38:		Line 38:
	* [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]		* [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]
	* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]		* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]
			* [https://stackoverflow.com/questions/44802061/convert-string-to-datetime-in-my-sql mysql - convert string to datetime in my sql - Stack Overflow]
	* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)]		* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)]
	* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format DATE_FORMAT(date,format)]		* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format DATE_FORMAT(date,format)]

Unknown user: /* PHP approach */

2020-05-08T10:54:06Z

PHP approach

← Older revision		Revision as of 18:54, 8 May 2020
Line 8:		Line 8:
	</pre>		</pre>

	{{exclaim}} The returned result is server timezone dependent if you ~~specify~~ the timezone		{{exclaim}} The returned result is server timezone dependent if you set the timezone using [https://www.php.net/manual/en/function.date-default-timezone-set.php date_default_timezone_set].
	<pre>		<pre>
	date_default_timezone_set("Asia/Taipei");		date_default_timezone_set("Asia/Taipei");

Unknown user: Created page with "Convert date time from T Z format (ISO 8601 format, Z(ulu) time) e.g. {{kbd |key=2020-05-08T10:01:45Z}} or {{kbd |key=2020-05-06T22:48:51.660Z}} == PHP approach == Coordinate..."

2020-05-08T10:52:03Z

Created page with "Convert date time from T Z format (ISO 8601 format, Z(ulu) time) e.g. {{kbd |key=2020-05-08T10:01:45Z}} or {{kbd |key=2020-05-06T22:48:51.660Z}} == PHP approach == Coordinate..."

New page

Convert date time from T Z format (ISO 8601 format, Z(ulu) time) e.g. {{kbd |key=2020-05-08T10:01:45Z}} or {{kbd |key=2020-05-06T22:48:51.660Z}}

== PHP approach ==
Coordinated Universal Time (UTC)
<pre>
echo date('Y-m-d H:i:s', strtotime('2020-05-08T09:59:08Z')) . PHP_EOL;
// returns 2020-05-08 09:59:08
</pre>

{{exclaim}} The returned result is server timezone dependent if you specify the timezone
<pre>
date_default_timezone_set("Asia/Taipei");
echo date('Y-m-d H:i:s', strtotime('2020-05-08T09:59:08Z')) . PHP_EOL;
// returns 2020-05-08 17:59:08
</pre>

== MySQL approach ==
Coordinated Universal Time (UTC)
<pre>
-- case1: end with decimal & Z
SET @myTime := '2020-05-06T22:48:51.660Z';
SELECT str_to_date(@myTime, '%Y-%m-%dT%H:%i:%s.%fZ');
-- returns 2020-05-06 22:48:51.660000

-- case2: not end with decimal & Z
SET @myTime := '2020-05-08T09:59:08Z';
SELECT str_to_date(@myTime, '%Y-%m-%dT%H:%i:%sZ');
-- returns 2020-05-08 09:59:08

SET @myTime := '2020-05-08T09:59:08Z';
SELECT str_to_date(@myTime, '%Y-%m-%dT%H:%i:%s.%fZ');
-- returns null
</pre>

== References ==
* [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601 - Wikipedia]
* [https://stackoverflow.com/questions/15902464/format-of-2013-04-09t100000z-in-php Format of 2013-04-09T10:00:00Z in php - Stack Overflow]
* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)]
* [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format DATE_FORMAT(date,format)]

[[Category:PHP]]
[[Category:MySQL]]
[[Category:Programming]]
[[Category:Data Science]]
[[Category:Time river]]