excel 日期与时间戳的相互转换

时间：2024-09-19 17:10 阅读：46

1、日期转时间戳：B1=INT((A1-70*365-19)*86400-8*3600)*1000

2、时间戳转日期：A1=TEXT((B1/1000+8*3600)/86400+70*365+19,"yyyy-mm-dd hh:mm:ss")

以上为精确到毫秒，只精确到秒不需要乘或除1000。

使用以上方法可以进行excel中日期时间格式与时间戳时间格式的相互转化，解决想将excel中数据导入进数据库，但excel中时间格式与数据库格式不一致的情况。

菜鸟工具时间戳转换器

https://www.jyshare.com/front-end/852/

基本文件流程错误 SQL 调试

/www/wwwroot/123zhidao.com/public/index.php ( 1.60 KB )
/www/wwwroot/123zhidao.com/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/wwwroot/123zhidao.com/vendor/composer/autoload_static.php ( 16.61 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/123zhidao.com/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Container.php ( 18.75 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/App.php ( 26.63 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Env.php ( 3.23 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/123zhidao.com/thinkphp/convention.php ( 11.74 KB )
/www/wwwroot/123zhidao.com/application/tags.php ( 1.02 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/wwwroot/123zhidao.com/application/common.php ( 25.83 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Request.php ( 6.32 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Request.php ( 57.54 KB )
/www/wwwroot/123zhidao.com/extend/form/Form.php ( 4.32 KB )
/www/wwwroot/123zhidao.com/application/function.php ( 0.75 KB )
/www/wwwroot/123zhidao.com/thinkphp/helper.php ( 20.40 KB )
/www/wwwroot/123zhidao.com/config/addons.php ( 1.32 KB )
/www/wwwroot/123zhidao.com/config/apidoc.php ( 1.41 KB )
/www/wwwroot/123zhidao.com/config/app.php ( 6.53 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/123zhidao.com/config/cache.php ( 1.59 KB )
/www/wwwroot/123zhidao.com/config/captcha.php ( 1.50 KB )
/www/wwwroot/123zhidao.com/config/cookie.php ( 1.12 KB )
/www/wwwroot/123zhidao.com/config/database.php ( 2.41 KB )
/www/wwwroot/123zhidao.com/config/log.php ( 1.28 KB )
/www/wwwroot/123zhidao.com/config/queue.php ( 1.81 KB )
/www/wwwroot/123zhidao.com/config/session.php ( 1.06 KB )
/www/wwwroot/123zhidao.com/config/site.php ( 1.22 KB )
/www/wwwroot/123zhidao.com/config/template.php ( 2.19 KB )
/www/wwwroot/123zhidao.com/config/token.php ( 1.41 KB )
/www/wwwroot/123zhidao.com/config/trace.php ( 0.84 KB )
/www/wwwroot/123zhidao.com/config/version.php ( 0.91 KB )
/www/wwwroot/123zhidao.com/vendor/symfony/polyfill-php70/bootstrap.php ( 0.85 KB )
/www/wwwroot/123zhidao.com/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/wwwroot/123zhidao.com/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.62 KB )
/www/wwwroot/123zhidao.com/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/wwwroot/123zhidao.com/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/wwwroot/123zhidao.com/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/wwwroot/123zhidao.com/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/wwwroot/123zhidao.com/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/wwwroot/123zhidao.com/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.50 KB )
/www/wwwroot/123zhidao.com/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/wwwroot/123zhidao.com/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/wwwroot/123zhidao.com/vendor/symfony/polyfill-ctype/bootstrap.php ( 1.50 KB )
/www/wwwroot/123zhidao.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.14 KB )
/www/wwwroot/123zhidao.com/vendor/khanamiryan/qrcode-detector-decoder/lib/common/customFunctions.php ( 1.75 KB )
/www/wwwroot/123zhidao.com/vendor/overtrue/pinyin/src/const.php ( 0.49 KB )
/www/wwwroot/123zhidao.com/vendor/yzncms/think-addons/src/common.php ( 12.79 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Route.php ( 25.84 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/RuleItem.php ( 8.82 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/wwwroot/123zhidao.com/vendor/yzncms/think-captcha/src/helper.php ( 1.54 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Validate.php ( 44.12 KB )
/www/wwwroot/123zhidao.com/vendor/yzncms/think-helper/src/helper.php ( 6.05 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Lang.php ( 7.56 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Log.php ( 8.92 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/wwwroot/123zhidao.com/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/123zhidao.com/route/route.php ( 0.73 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/123zhidao.com/addons/apidoc/Apidoc.php ( 1.64 KB )
/www/wwwroot/123zhidao.com/vendor/yzncms/think-addons/src/Addons.php ( 7.45 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/View.php ( 5.74 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Template.php ( 47.40 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/123zhidao.com/addons/cms/Cms.php ( 16.99 KB )
/www/wwwroot/123zhidao.com/addons/cms/config.php ( 3.34 KB )
/www/wwwroot/123zhidao.com/addons/cms/function.php ( 10.31 KB )
/www/wwwroot/123zhidao.com/addons/links/Links.php ( 2.90 KB )
/www/wwwroot/123zhidao.com/addons/queue/Queue.php ( 1.79 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/dispatch/Module.php ( 5.19 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/route/Dispatch.php ( 9.61 KB )
/www/wwwroot/123zhidao.com/application/cms/config/paginate.php ( 0.85 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/123zhidao.com/application/common/behavior/Common.php ( 1.35 KB )
/www/wwwroot/123zhidao.com/application/cms/controller/Index.php ( 18.60 KB )
/www/wwwroot/123zhidao.com/application/cms/controller/Cmsbase.php ( 1.27 KB )
/www/wwwroot/123zhidao.com/application/member/controller/MemberBase.php ( 2.77 KB )
/www/wwwroot/123zhidao.com/application/common/controller/Homebase.php ( 2.49 KB )
/www/wwwroot/123zhidao.com/application/common/controller/Base.php ( 0.93 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/123zhidao.com/addons/member/Member.php ( 5.64 KB )
/www/wwwroot/123zhidao.com/addons/member/config.php ( 1.91 KB )
/www/wwwroot/123zhidao.com/extend/libs/Cache_factory.php ( 2.99 KB )
/www/wwwroot/123zhidao.com/application/member/service/User.php ( 13.62 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/wwwroot/123zhidao.com/application/cms/model/Cms.php ( 23.29 KB )
/www/wwwroot/123zhidao.com/application/common/model/Modelbase.php ( 2.08 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Model.php ( 28.59 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/db/Query.php ( 105.41 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Url.php ( 13.22 KB )
/www/wwwroot/123zhidao.com/runtime/temp/d99d36ffcac8f8ba5b587cdbc76581f7.php ( 14.90 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/model/Collection.php ( 3.23 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Collection.php ( 13.60 KB )
/www/wwwroot/123zhidao.com/application/cms/model/Category.php ( 1.29 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/Response.php ( 9.68 KB )
/www/wwwroot/123zhidao.com/thinkphp/library/think/debug/Html.php ( 4.02 KB )

0.043563s

ThinkPHP - ThinkPHP

excel 日期与时间戳的相互转换

菜鸟工具时间戳转换器

Popular Tags