Convert Unix timestamps (epoch time) in seconds, milliseconds, or microseconds. Instantly see the human-readable date-time for any timestamp value. Perfect for debugging server logs, database records, and API responses. Supports both 32-bit and 64-bit timestamp ranges.
Full support for ISO 8601 date and time format standard, including UTC (Z suffix), timezone offsets (+08:00), basic format (without separators), and date-only or time-only representations. Also supports RFC 3339, RFC 2822, and other international date formats standard across global systems.
Instantly convert between 12-hour standard time and 24-hour military time. Enter 1430 to get 2:30 PM, or 2:30 PM to get 1430. Includes conversion rules, a reference chart, and support for timezone adjustments. Used by aviation, healthcare, and logistics professionals worldwide.
Easily convert hours and minutes to decimal time for payroll, billing, and time tracking. 8 hours and 45 minutes becomes 8.75 hours. Includes a decimal time conversion chart and supports both total-hours and per-day calculations. Perfect for freelancers and HR departments.
Convert between MySQL TIMESTAMP, PostgreSQL TIMESTAMPTZ, SQLite datetime formats, and standard Unix timestamps. Understand how different databases store date-time values internally. Includes format examples for the most common SQL date time format patterns.
Get the correct format of time stamping for JavaScript, Python, Java, PHP, C#, and Linux. Includes code snippets, language-specific format strings, and best practices for date time formatting in your programming environment. Test your timestamp outputs in real time. Our tool also supports linux time conversion for shell scripts and system logs.
Convert between timezones with the correct UTC offset for any date. Automatically adjusts for daylight saving time (DST) where applicable. See your converted time in multiple timezones simultaneously. Supports all IANA timezone database entries.
Type "2 hours ago," "next Friday at 3pm," or "last Monday" and get instant conversions. Our AI-powered parser understands natural language expressions in multiple languages. No need to know the exact format -- just describe the time you want and we handle the rest.
Epoch time (also called Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 at 00:00:00 UTC (the Unix epoch), not counting leap seconds. It is widely used in programming, databases, and system logs as a compact, timezone-independent way to store and compare time values.
Common epoch time values: 0 = January 1, 1970 (start of Unix epoch); 86400 = January 2, 1970 (one day later); 1720771200 = July 12, 2025. Tools like epoch time converter online help developers quickly translate between these integer values and human-readable dates.
Our converter supports Unix timestamp in seconds, milliseconds, and microseconds, and also handles the year 2038 problem (32-bit overflow) by supporting 64-bit timestamps.
ISO 8601 is the international standard for date and time representation. The basic format is YYYY-MM-DDTHH:mm:ss.sssZ where T separates the date from time, and Z indicates UTC. For example, 2025-07-12T14:30:00Z represents July 12, 2025 at 2:30 PM UTC. If a timezone offset is used instead of UTC, it appears as +HH:mm or -HH:mm (e.g., 2025-07-12T22:30:00+08:00).
ISO 8601 also supports date-only (YYYY-MM-DD), time-only (HH:mm:ss), ordinal dates (YYYY-DDD), and week dates (YYYY-Www-D). Our converter handles all ISO 8601 variants including the basic format without separators (YYYYMMDDTHHmmssZ).
Military time (also called 24-hour time) runs from 0000 (12:00 AM) to 2359 (11:59 PM) without the AM/PM designation. To convert from 12-hour to 24-hour: for 12:00 AM to 12:59 AM, use 0000 to 0059; for 1:00 AM to 11:59 AM, keep the same hours; for 12:00 PM to 12:59 PM, use 1200 to 1259; for 1:00 PM to 11:59 PM, add 12 to the hours.
Common military time conversions: 0000 = 12:00 AM (midnight), 0600 = 6:00 AM, 1200 = 12:00 PM (noon), 1430 = 2:30 PM, 2359 = 11:59 PM.
Decimal time converts hours and minutes into a decimal fraction of an hour. The formula is: minutes / 60 = decimal portion. For example, 8 hours and 45 minutes = 8 + (45 / 60) = 8.75 hours. This format is commonly used in payroll systems, time tracking software, and freelance billing.
Use our decimal time conversion chart for quick lookup: 15 minutes = 0.25, 30 minutes = 0.50, 45 minutes = 0.75. Our converter handles both directions -- decimal to hours:minutes and hours:minutes to decimal.
SQL databases store date-time values in different internal formats. MySQL uses the TIMESTAMP data type (stored as Unix epoch internally with range 1970 to 2038) and DATETIME (stored as plain text with range 1000 to 9999). PostgreSQL uses TIMESTAMP (microsecond precision integer) and TIMESTAMPTZ (timezone-aware). SQLite stores as text (ISO 8601 string), integer (Unix epoch), or real (Julian day number) depending on the declared type.
The standard SQL date time format is YYYY-MM-DD HH:MM:SS (e.g., 2025-07-12 14:30:00). Our converter translates between SQL formats and Unix timestamps, ISO 8601, and other standards.
Different programming languages have their own approaches to date time formatting. In JavaScript, use toISOString() for ISO 8601 format, toLocaleString() for locale-specific formatting, or getTime() to get Unix timestamp in milliseconds. In Python, use datetime.strftime() with format codes like %Y-%m-%d %H:%M:%S. In Java, use SimpleDateFormat or the newer java.time.format.DateTimeFormatter. In Linux, use the date command for shell-based time conversion and timestamp formatting in scripts and system logs.
The correct format of time stamping in code matters for API compatibility, database storage, and log parsing. Our converter helps you test and validate your formatted timestamps before deploying to production.
The most versatile free time converter for developers. Parse and transform Unix timestamps (seconds/milliseconds), ISO 8601, RFC 3339, SQL datetime, and military time in one click. AI-powered natural language input understands "2 hours ago" or "next Friday at 3pm" instantly.