Unix Timestamp Converter Convert Unix Time to Date or Date to Timestamp Online
Current Time:
Seconds
Change Format
Seconds
Seconds
Unix Timestamp Converter - Essential Developer Time Tool
A must-have for system development, API testing, and log analysis! Quickly convert between Unix Timestamps and readable time formats, with support for both seconds and milliseconds.
✨ Key Features
- Bidirectional Conversion: Seamlessly convert from Unix Timestamp to a human-readable date, and from a date back to a Unix Timestamp.
- Live Timestamp: View the current Unix Timestamp in real-time, with options to pause and resume.
- Seconds & Milliseconds Support: Handles both 10-digit (seconds) and 13-digit (milliseconds) timestamps.
- One-Click Copy: Instantly copy the generated timestamp to your clipboard.
🎯 Common Use Cases
- Backend Development: Managing time fields in databases and handling timestamps in API requests.
- Log Analysis: Interpreting server logs and pinpointing the exact time of errors.
- Data Analysis: Processing time-series data and recording event times.
- API Testing: Constructing test data and validating time-related parameters.
- Debugging: Investigating time-related bugs and understanding time calculation logic.
💡 Pro Tips
- Identify the Format: A 10-digit number is a timestamp in seconds, while a 13-digit number is in milliseconds.
- Timezone Awareness: Remember that Unix timestamps are always in UTC. Be mindful of timezone differences when converting to a local time.
- Code Reference: Find quick code snippets for timestamp conversion in various programming languages at the bottom of the page.
- Batch Processing: For converting multiple timestamps, use the provided code examples in your scripts.
❓ What is a Unix Timestamp?
A Unix Timestamp, also known as Unix time or POSIX time, is the total number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC. It is a universal, timezone-independent way of representing a point in time, which makes it incredibly useful in systems that operate across different geographical regions. No matter where you are in the world, the same Unix timestamp always refers to the exact same moment!
Methods to Get Current Unix Timestamp in Different Languages:
| Java | time |
| JavaScript | Math.round(new Date().getTime()/1000) |
| 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 | import time + time.time() |
| Ruby | Time.now、Time.new、Time.now.to_i |
| Go | import time + int32(time.Now().Unix()) |
| 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()) |
Methods to Convert Unix Timestamp to Regular Time in Different Languages:
| Java | String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000)) |
| JavaScript | var unixTimestamp = new Date(Unix timestamp * 1000) + commonTime = unixTimestamp.toLocaleString() |
| Linux | date -d @Unix timestamp |
| MySQL | from_unixtime(Unix timestamp) |
| Perl | my $time = Unix timestamp + 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 | import time + 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") |
Methods to Convert Regular Time to Unix Timestamp in Different Languages:
| 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) |
| Perl | use Time::Local + my $time = timelocal($sec, $min, $hour, $day, $month, $year); |
| PHP | mktime(hour, minute, second, month, day, year) |
| PostgreSQL | SELECT extract(epoch FROM date('YYYY-MM-DD HH:MM:SS')); |
| Python | import time + 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) |
X
☕
Did this tool just save you 10 minutes?
Buy the sleep-deprived developer a cup of coffee ☕
☕ Buy me a coffee