UNIX timestamp conversion tool
UNIX timestamp(Unix timestamp) → Beijing time
Beijing time → UNIX timestamp(Unix timestamp)
Beijing time → UNIX timestamp(Unix timestamp)
How to obtain the current UNIX timestamp in different programming languages?
Java | time |
JavaScript |
Math.round(new Date().getTime()/1000) getTime()The returned value is in milliseconds |
Microsoft .NET / C# | epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000 |
MySQL | SELECT unix_timestamp(now()) |
Perl | time |
PHP | time() |
PostgreSQL | SELECT extract(epoch FROM now()) |
Python | before import time then time.time() |
Ruby |
获取UNIX timestamp:Time.now or Time.new 显示UNIX timestamp:Time.now.to_i |
SQL Server | SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) |
Unix / Linux | date +%s |
VBScript / ASP | DateDiff("s", "01/01/1970 00:00:00", Now()) |
Other operating systems (If Perl is installed on the system}) |
Command line status:perl -e "print time" |
How to implement in different programming languagesUNIX timestamp(Unix timestamp) → Normal time?
Java | String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000)) |
JavaScript | before var unixTimestamp = new Date(Unix timestamp * 1000) then commonTime = unixTimestamp.toLocaleString() |
Linux | date -d @Unix timestamp |
MySQL | from_unixtime(Unix timestamp) |
Perl | before my $time = Unix timestamp then my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6] |
PHP | date('r', Unix timestamp) |
PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix timestamp) * INTERVAL '1 second'; |
Python | before import time then time.gmtime(Unix timestamp) |
Ruby | Time.at(Unix timestamp) |
SQL Server | DATEADD(s, Unix timestamp, '1970-01-01 00:00:00') |
VBScript / ASP | DateAdd("s", Unix timestamp, "01/01/1970 00:00:00") |
Other operating systems (If Perl is installed on the system}) |
命令行状态:perl -e "print scalar(localtime(Unix timestamp))" |
How to implement common time in different programming languages → UNIX timestamp(Unix timestamp)?
Java | long epoch = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00"); |
JavaScript | var commonTime = new Date(Date.UTC(year, month - 1, day, hour, minute, second)) |
MySQL |
SELECT unix_timestamp(time) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD |
Perl | before use Time::Local then my $time = timelocal($sec, $min, $hour, $day, $month, $year); |
PHP | mktime(hour, minute, second, day, month, year) |
PostgreSQL | SELECT extract(epoch FROM date('YYYY-MM-DD HH:MM:SS')); |
Python | before import time then int(time.mktime(time.strptime('YYYY-MM-DD HH:MM:SS', '%Y-%m-%d %H:%M:%S'))) |
Ruby | Time.local(year, month, day, hour, minute, second) |
SQL Server | SELECT DATEDIFF(s, '1970-01-01 00:00:00', time) |
Unix / Linux | date +%s -d"Jan 1, 1970 00:00:01" |
VBScript / ASP | DateDiff("s", "01/01/1970 00:00:00", time) |
Tool introduction
What is UNIX timestamp: Unix timestamp, or UNIX time and POSIX time, is a time representation, defined as the total number of seconds from 00:00:00 on January 1, 1970 Greenwich mean time to the present. UNIX timestamp is not only used in UNIX systems and UNIX like systems, but also widely used in many other operating systems
For infringement, consultation or customized technical services, please click QQContact me, thank you!
无限星辰工作室|
无限星辰技术博客|
集热爱圈|
厦门生活网|
厦门社区网|
无限星辰技术网|
厦门商页吧|
有趣游戏|
星熠文化|
集导航|
厦门空间网|
厦门无限星辰|
crx349博客|
星辰站分享|
discuz资源分享站|
星辰个人付款码管理平台|
星辰php加密平台|
星辰免费API|
星辰工具箱|
星辰字帖生成器|
星辰谜语生成器|
星辰网站在线图标生成|
高考倒计时|
星辰在线图片压缩|
新冠病毒防疫指南|
星辰SSL自签名证书生成|
KMS在线激活Bat生成|
繁星客服|
密码在线生成|
毒鸡汤语录|
星辰动态DNS解析平台|
星辰伪原创工具|
星辰聚合搜索引擎|
MD5在线生成|
网站缩略图|
星辰AI象棋|
星辰多合一图床|
国庆头像生成|
人生重开模拟器|
怀旧游戏模拟器|
星辰站长工具|
星辰日记账本|
星辰万年历|
星辰文字水印|
今天吃啥呢|
无限星辰全栈定制|
一品文学|
星辰APP下载中心|
星辰扒站|
星辰在线MYSQL数据库数据字典|
星辰局域网文件隔开投送|
星辰应急网页拍照|
留洋汇-留学汇款|
留学院校搜索|
飘洋过海|
漂洋过海-全球留学服务中心|