TimeStamp Converter: UNIX, UTC, DateTime, ISO, RFC
Convert time between Unix Timestamp, ISO 8601, RFC 2822, SQL datetime and custom formats. A universal tool for developers and analysts.
Convert time between Unix Timestamp, ISO 8601, RFC 2822, SQL datetime and custom formats. A universal tool for developers and analysts.
Convert dates and times between Unix Timestamp, ISO 8601, RFC 2822, SQL datetime and local custom formats. Everything in one tool - without extra settings.
The tool automatically recognizes the format and instantly converts the data. Convenient when working with logs, APIs, SQL queries and dates in texts.
Customize the output format according to your template: yyyy-MM-dd HH:mm:ss, dd.MM.yyyy, MM/dd/yyyy hh:mm:ss and others. Template flexibility allows you to create any format.
A Unix timestamp is the number of seconds that have passed since January 1, 1970 (UTC). It is widely used in programming, APIs, and databases to store time in a universal format.
Unix timestamps can be in seconds (10 digits) or milliseconds (13 digits).
This tool operates in four modes:
Mode | Description |
|---|---|
Current Time | Displays the current time (UTC and your local timezone) in Unix format. Also converts the timestamp into common date and time formats. |
Timestamp → Date | Converts a Unix timestamp into human-readable date and time formats. |
Date → Timestamp | Converts a specific date and time into a Unix timestamp and other common formats. |
Formatter | Formats a date using a custom pattern with macros. |
Unix timestamps are always stored in UTC. When converting to a date, the result depends on the user’s timezone, so the same value may appear differently.
Period | Convert to seconds |
|---|---|
Second | 1 sec |
Minute | 60 sec |
Hour | 3600 sec |
Day | 86400 sec |
Week | 604800 sec |
Month (30 days) | 2592000 sec |
Year (365 days) | 31536000 sec |
Month and year values are approximate and used for reference only. The actual duration depends on the calendar and leap years. The converter correctly accounts for real calendar values.
Period | Macros |
|---|---|
Year | YYYY, YY, Y |
Month | MMMM, MMM, MM, M |
Day | DDDD, DDD, DD, D |
Hour (24h) | HH, H |
Hour (12h) | hh, h |
Minute | mm, m |
Second | ss, s |
Millisec | SSS, SS, S |
AM/PM | A, a |
You can build custom date/time formats using macros:
Format | Result |
|---|---|
YYYY-MM-DD | 2026-04-15 |
DD.MM.YYYY | 15.04.2026 |
HH:mm:ss | 14:32:10 |
YYYY-MM-DD HH:mm | 2026-04-15 14:32 |
Language | Current Timestamp | Date → Timestamp | Timestamp → Date |
|---|---|---|---|
JavaScript | Math.floor(Date.now() / 1000) | Math.floor(new Date('2026-04-15T12:00:00Z').getTime()/1000) | new Date(1776254400 * 1000) |
Python | int(time.time()) | int(datetime.datetime(2026,4,15,12,0).timestamp()) | datetime.datetime.fromtimestamp(1776254400) |
PHP | time() | strtotime('2026-04-15 12:00:00') | date('Y-m-d H:i:s', 1776254400) |
Java | Instant.now().getEpochSecond() | LocalDateTime.of(2026,4,15,12,0).toEpochSecond(ZoneOffset.UTC) | Instant.ofEpochSecond(1776254400) |
C# (.NET) | DateTimeOffset.UtcNow.ToUnixTimeSeconds() | new DateTimeOffset(2026,4,15,12,0,0,TimeSpan.Zero).ToUnixTimeSeconds() | DateTimeOffset.FromUnixTimeSeconds(1776254400) |
Go | time.Now().Unix() | time.Date(2026,4,15,12,0,0,0,time.UTC).Unix() | time.Unix(1776254400, 0) |
Ruby | Time.now.to_i | Time.new(2026,4,15,12,0,0).to_i | Time.at(1776254400) |
Bash (Linux) | date +%s | date -d "2026-04-15 12:00:00" +%s | date -d @1776254400 |
SQL (PostgreSQL) | EXTRACT(EPOCH FROM NOW()) | EXTRACT(EPOCH FROM TIMESTAMP '2026-04-15 12:00:00') | TO_TIMESTAMP(1776254400) |
SQL (MySQL) | UNIX_TIMESTAMP() | UNIX_TIMESTAMP('2026-04-15 12:00:00') | FROM_UNIXTIME(1776254400) |
In most languages, timestamps are returned in seconds, but in JavaScript they are in milliseconds (you need to divide by 1000). Methods without an explicit timezone may use local time, which can lead to errors. When working with APIs, always use UTC instead of local time — this eliminates most time-related issues.
confusing UTC with local time
using milliseconds instead of seconds
incorrect date format
invalid or inconsistent timezones
The timestamp converter allows you to quickly convert data between Unix Timestamp, ISO 8601, RFC 2822, SQL datetime and custom formats.
The service automatically recognizes the input format and instantly converts the date or time. Custom format settings are supported, which is convenient for working with logs, APIs, databases and reports.
The tool is convenient for developers, analysts and administrators who need to work with timestamps in various formats.
A Unix timestamp is the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC. It is a standard way to represent time in computer systems, independent of time zone.
Timestamps provide a universal, time-zone independent way to represent time. They simplify time difference calculations, chronological sorting, and avoid time zone conversion issues in distributed systems.
Unix timestamps count seconds since 1970. Other formats include milliseconds (JavaScript), microseconds, or different epoch dates. Some systems use ISO 8601 strings instead of numerical timestamps.
The Timestamp converter works with standard date formats (ISO 8601, UTC, RFC, local time, and many others), and also correctly handles numbers in seconds and milliseconds. This allows the tool to be used for different systems and applications.
The Year 2038 problem affects 32-bit systems where Unix timestamps will overflow on January 19, 2038. Modern 64-bit systems extend this limit by billions of years, but legacy systems may need updates.
Yes, the tool allows you to enter any date and time (past, present, or future) and convert them to the corresponding Unix timestamp and vice versa. This is useful for planning, historical analysis, or creating your own services.
Yes, a custom format option is available in the builder. You can choose the display order of year, month, day, hours, minutes, and seconds, and also set separators — for example, YYYY-MM-DD HH:mm:ss. This is convenient for working with specific standards or corporate requirements.
The most commonly used formats are: ISO 8601 (2025-08-30T12:34:56Z), UTC (Sat, 30 Aug 2025 12:34:56 GMT), local time (30.08.2025 12:34:56), UNIX Timestamp in seconds and milliseconds. Our converter supports all these options and allows you to quickly switch between them.