Unix Timestamp Converter

Unix Timestamp, Unix Timestamp Conversion Tool
Current Timestamp
　Beijing Time

Unix Timestamp (Unix timestamp) → Beijing Time

Unix Timestamp
Beijing Time

Beijing Time → Unix Timestamp (Unix timestamp)

Beijing Time
Unix Timestamp

Unix Timestamp Conversion Tool Introduction

The Unix timestamp conversion tool can convert Unix timestamps to standard format Beijing time, and convert standard format Beijing time to UNIX timestamps;

What is a Unix Timestamp (Unix timestamp): A timestamp refers to the total number of seconds from Greenwich Mean Time (GMT) starting from 00:00:00 on January 1, 1970 (Beijing Time 00:00:00 on January 1, 1970).

PHP Example of Unixtime Usage:

Get current timestamp: $time = time(); Convert to Beijing time: $datetime = date('Y-m-d H:i:s',$time); Convert to timestamp: $unixtime = strtotime($datetime);（www.pcjson.com）

1. Methods to Get the Current Unix Timestamp (Unix timestamp) in Different Programming Languages or Databases:

PHP time()
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime() returns the value in milliseconds
.NET / C# time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PostgreSQL SELECT extract(time FROM now())
Python first import time then time.time()
Ruby Get Unix timestamp: Time.now or Time.new
Display 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())

2. Converting Common Time → Unix Timestamp (Unix timestamp) in Different Programming Languages or Databases:

PHP mktime(hour, minute, second, day, month, year)
Java long datetime = 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 first use Time::Local then my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PostgreSQL SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));
Python first 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', datetime)
Unix / Linux date +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", datetime)

3. Converting Unix Timestamp (Unix timestamp) to Common Time (YYYY-MM-DD HH:MM:SS) in Different Programming Languages or Databases:

PHP date('r', Unix timestamp)
Java String datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000))
JavaScript first var unixTimestamp = new Date(Unix timestamp * 1000) then commonTime = unixTimestamp.toLocaleString()
Linux date -d @Unix timestamp
MySQL from_unixtime(Unix timestamp)
Perl first my $time = Unix timestamp then my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';
Python first 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")

Unix Timestamp Conversion Tool

Using our Unix Timestamp Conversion Tool, you can easily convert Unix timestamps to Beijing Time. Whether you are a developer or an ordinary user, this tool can help you quickly convert timestamps and dates, supporting conversions from Unix timestamps to current time, converting to Beijing Time, and vice versa.

Feature Introduction

  • Unix Timestamp to Beijing Time: Converts Unix timestamps to the current Beijing Time, suitable for various development environments.
  • Datetime to Unix Timestamp: Converts date and time (e.g., yyyy-mm-dd hh:mm:ss) to a Unix timestamp for easy time calculations.
  • Supports multiple programming languages: Provides implementation methods for Unix timestamp conversion in different programming languages (such as Python, Java, JavaScript, PHP, etc.), making it easy for developers to quickly integrate.
  • Online Conversion: Offers a free online tool, allowing users to convert Unix timestamps and dates online without needing to download any software.

How to Use the Unix Timestamp Conversion Tool

1. Select input format: You can choose to convert Unix timestamps to Beijing Time or convert datetime to Unix timestamps.
2. Input Timestamp or Date: Fill in the timestamp or datetime in the input box.
3. Click the "Convert" button: The tool will automatically calculate and output the conversion result, allowing you to view the converted time.

Definition of Unix Timestamp

Unix timestamps, also known as POSIX time or epoch time, are the number of seconds that have elapsed since 00:00:00 UTC on January 1, 1970. Unix timestamps are a commonly used time format in many computer systems and programming languages.

Applicable Scenarios

  • Developers: Convert dates to Unix timestamps for time calculations and comparisons.
  • Data Analysts: Convert timestamps to readable date formats for time series analysis.
  • General Users: Help users convert Unix timestamps to Beijing Time to understand the corresponding date and time of a specific moment.

Why Choose Our Unix Timestamp Conversion Tool?

  • Simple and Easy to Use: No complex operations required, just input the timestamp or date, and click the convert button to get results.
  • Fast and Accurate: Provides fast timestamp conversion services, ensuring accuracy and that the results match the actual time.
  • Diverse Functions: Supports various common timestamp conversion needs, suitable for both developers and ordinary users.
  • Multi-language Support: Provides code examples for timestamp conversion in common programming languages, making it easy for developers to implement quickly.

Start Using the Unix Timestamp Conversion Tool

Use our Unix Timestamp Conversion Tool now to easily convert Unix timestamps to Beijing Time or other formats, making it convenient to handle your time data.

Your footpath:
Choose Language