Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 41778.00000000 是一种怎样的时间记录格式

41778.00000000 是一种怎样的时间记录格式

WBOY
Release： 2016-06-23 13:55:38
Original
987 people have browsed it

41778.00000000
41778.77877315
这是一种什么形式的时间记录

在写一个小程序，引用了另一个软件的数据框架，该软件用“41778.77877315”这种形式来记录时间，不懂，不知道如何转换，不是UNIX时间戳，哪位大侠指点一下，多谢了


回复讨论(解决方案)

这是微软的日期表示方式
换算到 unix 时间戳： 

$d = 41778.77877315;echo ($d - 25569) * 86400;
Copy after login

呵呵，非常感谢，刚在PHPExcel中找到了解法，大侠提供的方法更为简便，感谢

Related labels：
time Format Record
source：php.cn
Previous article：如何调用类外的变量 Next article：php-fpm（PHP-FPM是一个PHPFastCGI管理器）
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template