DateAndTimeConverter.com
Try CSV Mode

Free Unix Timestamp & Date Format Converter

Convert Unix timestamps, epoch time, ISO 8601, UTC, and custom date formats instantly. Paste any timestamp — we auto-detect and convert it. Need to transform an entire CSV column? Upgrade to batch processing with no row limits.

✓ 20 Date Formats
✓ 98 Timezones & DST
✓ 100% Browser-Based
✓ Ad-Free Pro Experience

Unix Timestamp, Epoch & Date Format Converter

Paste any date — we'll detect and convert it. Free, unlimited, no sign-up required.

Unix Timestamp (sec & ms) Epoch Converter ISO 8601 UTC / GMT MM/DD/YYYY DD.MM.YYYY 98 Timezones + DST AM/PM Formats

Date & Time Converter

Paste any date — we'll detect and convert it

Source
Target
Adjust
Enter a date above

CSV Batch Date Conversion

Need to convert an entire column of timestamps? Upload your CSV, pick the column, and batch-convert unlimited rows. Ad-free, browser-based, $9.99/mo.

Who Uses a Date & Time Converter?

Whether you're converting a single timestamp or batch-processing a CSV column, these are the most common scenarios our users encounter.

Database Migration
Converting timestamp columns when moving data between systems — for example, MySQL DATETIME to PostgreSQL ISO 8601, or legacy formats to modern standards.
Reporting & Analytics
Standardizing date formats across data exports from different tools so they sort correctly and display consistently in dashboards and spreadsheets.
Financial & Compliance
Reformatting transaction dates and trading timestamps to meet regulatory or accounting standards — converting between US (MM/DD/YYYY) and ISO formats.
CRM & Customer Data
Harmonizing customer interaction timestamps exported from Salesforce, HubSpot, or Zendesk into a single consistent format for analysis.
System Integration
Bridging format differences between APIs and enterprise systems — converting Unix epoch timestamps to human-readable dates, or vice versa.
Timezone Conversion
Converting timestamps between timezones for global teams — EST to UTC, PST to CET, or any of the 98 supported IANA timezones with automatic DST handling.

The single-date converter is free with no limits. For batch CSV conversion, subscribe to process unlimited rows with no file size caps — plus enjoy a completely ad-free workspace.

Date & Time Conversion Features

All 20 Supported Date & Time Formats

Every format works as both source (input) and target (output). Auto-detection for single dates; column-level conversion for CSV files.
Date Only Formats
M/D/YYYYe.g. 6/9/2024
MM/DD/YYYYe.g. 06/09/2024
YYYYe.g. 2024 (year only)
Date + Time — 24-Hour Formats
YYYY-MM-DDTHH:mm:ss.SSSZISO 8601 with milliseconds — e.g. 2024-06-29T00:00:00.000Z
YYYY-MM-DDTHH:mm:ssISO 8601 without Z — e.g. 2024-06-29T00:00:00
YYYY-MM-DD HH:mm:ssSQL / database datetime — e.g. 2022-06-29 13:45:31
M/D/YYYY HH:mm:ssUS date with 24h time — e.g. 6/29/2024 00:00:00
MM/DD/YYYY HH:mm:ssZero-padded US — e.g. 06/29/2024 00:00:00
M/D/YYYY - HH:mm:ssDash-separated — e.g. 8/26/2023 - 13:33:05
DD.MM.YYYY, HH:mm:ssEuropean format — e.g. 15.05.2024, 21:11:29
YYYY.MM.DD HH:mm:ssDot-separated — e.g. 2021.02.05 19:15:47
Unix Timestamp (ms)13-digit epoch milliseconds — e.g. 1719619200000
Unix Timestamp (sec)10-digit epoch seconds — e.g. 1719619200
HH:mm MM/DD/YYYYTime-first format — e.g. 10:27 07/01/2025
Date + Time — 12-Hour AM/PM Formats
YYYY-MM-DD h:mm:ss AISO date + 12h time — e.g. 2024-06-29 2:30:00 PM
M/D/YYYY h:mm:ss AUS + 12h — e.g. 6/29/2024 2:30:00 PM
M/D/YYYY h:mm AUS + 12h no seconds — e.g. 6/29/2024 2:30 PM
MMM DD, YYYY, h:mm:ss AShort month name — e.g. Oct 29, 2024, 12:00:00 AM
MMM D YYYY, h:mm ACompact month — e.g. Apr 1 2024, 8:59 AM
MMMM DD, YYYY at h:mm:ss AFull month name — e.g. December 13, 2023 at 12:24:03 PM

Every format above can be used as both input and output. Convert freely between any pair: Unix timestamp to ISO 8601, epoch to MM/DD/YYYY, DD.MM.YYYY to YYYY-MM-DD, ISO 8601 to Unix seconds, human-readable date to epoch milliseconds, and any other combination.

98 IANA Timezones & 99 Abbreviations with Automatic DST

Every major timezone worldwide — IANA zone IDs for precision, abbreviations for convenience, with automatic daylight saving time handling.
Universal (2 zones)

UTC — Coordinated Universal Time, Etc/GMT — Greenwich Mean Time. The base reference timezones for all conversions.

North America (10 zones)

Eastern Time — America/New_York (EST/EDT), Central Time — America/Chicago (CST/CDT), Mountain Time — America/Denver (MST/MDT), Pacific Time — America/Los_Angeles (PST/PDT), Alaska — America/Anchorage (AKST/AKDT), Hawaii — Pacific/Honolulu (HST), Atlantic — America/Halifax (AST/ADT), Newfoundland — America/St_Johns (NST/NDT), Arizona — America/Phoenix (MST, no DST).

Central America & Caribbean (3 zones)

Mexico City — America/Mexico_City (CST/CDT), Panama — America/Panama (EST), Puerto Rico — America/Puerto_Rico (AST).

South America (14 zones)

São Paulo — America/Sao_Paulo (BRT/BRST), Buenos Aires — America/Argentina/Buenos_Aires (ART), Santiago — America/Santiago (CLT/CLST), Bogotá — America/Bogota (COT), Lima — America/Lima (PET), Caracas — America/Caracas (VET), La Paz — America/La_Paz (BOT), Asunción — America/Asuncion (PYT/PYST), Montevideo — America/Montevideo (UYT), Guayaquil — America/Guayaquil (ECT), Cayenne — America/Cayenne (GFT), Paramaribo — America/Paramaribo (SRT), Georgetown — America/Guyana (GYT), Stanley — Atlantic/Stanley (FKST).

Europe (7 zones)

London — Europe/London (GMT/BST), Paris / Berlin / Rome — Europe/Paris (CET/CEST), Helsinki / Bucharest — Europe/Helsinki (EET/EEST), Athens — Europe/Athens (EET/EEST), Istanbul — Europe/Istanbul (TRT), Moscow — Europe/Moscow (MSK), Lisbon — Europe/Lisbon (WET/WEST).

Middle East (5 zones)

Dubai — Asia/Dubai (GST), Tehran — Asia/Tehran (IRST/IRDT), Riyadh — Asia/Riyadh (AST), Jerusalem — Asia/Jerusalem (IST/IDT), Kabul — Asia/Kabul (AFT).

South Asia (6 zones)

Kolkata (India) — Asia/Kolkata (IST), Karachi (Pakistan) — Asia/Karachi (PKT), Kathmandu (Nepal) — Asia/Kathmandu (NPT), Dhaka (Bangladesh) — Asia/Dhaka (BST), Colombo (Sri Lanka) — Asia/Colombo (IST), Thimphu (Bhutan) — Asia/Thimphu (BTT).

East & Southeast Asia (15 zones)

Bangkok / Hanoi — Asia/Bangkok (ICT), Yangon (Myanmar) — Asia/Yangon (MMT), Singapore — Asia/Singapore (SGT), Kuala Lumpur — Asia/Kuala_Lumpur (MYT), Hong Kong — Asia/Hong_Kong (HKT), Shanghai (China) — Asia/Shanghai (CST), Taipei — Asia/Taipei (CST), Manila (Philippines) — Asia/Manila (PST/PHT), Jakarta — Asia/Jakarta (WIB), Makassar — Asia/Makassar (WITA), Jayapura — Asia/Jayapura (WIT), Brunei — Asia/Brunei (BNT), Dili (Timor-Leste) — Asia/Dili (TLT), Tokyo (Japan) — Asia/Tokyo (JST), Seoul (Korea) — Asia/Seoul (KST).

Australia & Pacific (15 zones)

Sydney — Australia/Sydney (AEST/AEDT), Adelaide — Australia/Adelaide (ACST/ACDT), Perth — Australia/Perth (AWST), Brisbane — Australia/Brisbane (AEST), Auckland — Pacific/Auckland (NZST/NZDT), Fiji — Pacific/Fiji (FJT/FJST), Guam — Pacific/Guam (ChST), Samoa — Pacific/Pago_Pago (SST), Port Moresby — Pacific/Port_Moresby (PGT), Guadalcanal — Pacific/Guadalcanal (SBT), Efate (Vanuatu) — Pacific/Efate (VUT), Noumea — Pacific/Noumea (NCT), Majuro — Pacific/Majuro (MHT), Funafuti — Pacific/Funafuti (TVT), Tongatapu — Pacific/Tongatapu (TOT).

Africa (6 zones)

Lagos — Africa/Lagos (WAT), Johannesburg — Africa/Johannesburg (SAST), Nairobi — Africa/Nairobi (EAT), Maputo — Africa/Maputo (CAT), Cairo — Africa/Cairo (EET/EEST), Casablanca — Africa/Casablanca.

Russia (10 zones)

Samara — Europe/Samara (+04), Yekaterinburg — Asia/Yekaterinburg (+05), Omsk — Asia/Omsk (+06), Novosibirsk — Asia/Novosibirsk (+07), Krasnoyarsk — Asia/Krasnoyarsk (+07), Irkutsk — Asia/Irkutsk (+08), Yakutsk — Asia/Yakutsk (+09), Vladivostok — Asia/Vladivostok (+10), Magadan — Asia/Magadan (+11), Kamchatka — Asia/Kamchatka (+12).

All 99 Recognized Timezone Abbreviations

UTC, GMT, EST, EDT, CST, CDT, MST, MDT, PST, PDT, AKST, AKDT, HST, HDT, AST, ADT, NST, NDT, BRT, BRST, ART, CLT, CLST, COT, PET, VET, ECT, BOT, PYT, PYST, UYT, GFT, SRT, GYT, FKT, FKST, BST, WET, WEST, CET, CEST, EET, EEST, TRT, IST, MSK, SAMT, YEKT, OMST, KRAT, IRKT, YAKT, VLAT, MAGT, PETT, IRST, IRDT, GST, AFT, PKT, NPT, BTT, MMT, ICT, WIB, SGT, MYT, PHT, HKT, WITA, BNT, AWST, KST, JST, WIT, TLT, ACST, ACDT, AEST, AEDT, AWDT, WAT, CAT, SAST, EAT, CHST, PGT, SBT, VUT, NCT, NZST, NZDT, FJT, FJST, MHT, TOT, TVT, SST.

DST transitions are handled automatically: US rules (second Sunday March to first Sunday November), EU rules (last Sunday March to last Sunday October), and region-specific rules for all other zones. Convert between any timezone pair — EST to PST, UTC to JST, CET to IST, AEST to EST, and every other combination.

Smart Features: Auto-Detect, Time Adjustment & Visual Editor

Unique tools that go beyond basic conversion — auto-detect input format, shift dates forward or back, and edit individual date segments visually.
Auto-Detect Input Format

Paste any date or timestamp — the converter automatically identifies the format from all 20 supported patterns. No manual selection needed. Works for both the free single converter and CSV batch mode (samples up to 10 rows to find the best match).

Time Adjustment / Date Shifting

Add or subtract seconds, minutes, hours, days, weeks, months, or years from any converted date. Useful for calculating future or past dates, adjusting for time offsets, or scheduling. Built into the free converter.

Visual Segment Editor

Parsed dates are broken into color-coded, clickable segments — Year, Month, Day, Hour, Minute, Second, Millisecond, AM/PM, and Timezone. Click any segment to edit it directly. See exactly how your date is being interpreted.

Relative Time Display

After conversion, see how far the date is from now — "3 days ago", "in 2 hours", "6 months from now". Helpful for quickly understanding timestamps from logs and databases.

CSV Column Auto-Detection

When you upload a CSV, columns named "date", "time", "created", "updated", "timestamp", "datetime", "modified", "expires", "start", or "end" are automatically selected. No manual searching through column headers.

Diagnostic Report

After CSV processing, a full diagnostic report shows row-by-row parse results, error counts, processing speed (rows/second), and configuration details. Copy the report with one click for debugging or documentation.

Free Converter + Ad-Free Pro CSV Processing

The single-date converter is free with no limits. CSV batch mode adds unlimited file processing and an ad-free experience for $9.99/mo.
Free: Convert Any Date

Paste or type any date and we auto-detect the format. Choose your target format and timezone, adjust by adding or subtracting time, edit individual segments, and copy the result. Free, unlimited, no sign-in required.

Pro: Web Worker Processing

CSV conversion runs on a background thread so your browser stays responsive. Progress bar shows completion percentage and rows-per-second speed for large files.

Pro: Preview & Diagnostic

See the first 5 rows converted side by side before processing. After processing, get a full diagnostic report with row-by-row results, error counts, and timing data.

Pro: Multi-File & Ad-Free

Drag and drop multiple CSV files. Each file shows row count, column count, and column names. Process and download each file independently. Completely ad-free workspace.

Privacy & Error Handling

All processing happens locally in your browser. No files are uploaded, no data is stored on any server.
100% Browser-Based

Both the free converter and CSV processing run entirely in your browser using JavaScript. No server uploads, no data transmission. Safe for financial data, PII, healthcare records, and GDPR-sensitive data.

Error Reporting

Rows that can't be parsed don't stop the conversion. Errors are counted and reported so you know exactly how many rows need attention. A Date.parse fallback catches edge cases.

Column Auto-Detection

CSV headers are parsed and presented in a dropdown. Select the column containing your timestamps, whether it's called 'date', 'created_at', 'timestamp', or any custom header.

Progress & Cancel

Real-time progress bar with rows-per-second counter. Cancel mid-processing if the format selection is wrong, no need to wait for a large file to finish.

How to Convert Date & Time Formats

Convert a single date instantly with the free tool, or batch-convert an entire CSV column with Pro mode.

  1. 1

    Paste or type any date into the converter above. We auto-detect the format, or you can select it manually from the dropdown.

  2. 2

    Choose your target format from 20+ options including ISO 8601, Unix timestamp, MM/DD/YYYY, DD.MM.YYYY, and more.

  3. 3

    Optionally adjust the timezone or add/subtract time (hours, days, weeks, etc.) to shift the result.

  4. 4

    Copy the converted date with one click. For single dates, that's it — free, unlimited, no sign-in needed.

  5. 5

    For CSV files, scroll down to CSV Batch Mode and sign in with Google to subscribe ($9.99/mo).

  6. 6

    Upload your CSV file or drag and drop it. Select the column that contains your date/time data.

  7. 7

    Pick the source format and target format, then preview the first 5 rows to verify accuracy.

  8. 8

    Process the full file and download the converted CSV. All processing happens in your browser.

Pro Tip: Use the free converter first to figure out exactly which source and target formats you need. Then apply the same conversion to your entire CSV file in batch mode.

Frequently Asked Questions

What date and time formats does this converter support?

The converter supports 20 date and time formats that each work as both source (input) and target (output). These include ISO 8601 (with and without milliseconds), Unix timestamps in seconds and milliseconds, US formats (MM/DD/YYYY, M/D/YYYY), European formats (DD.MM.YYYY), SQL datetime (YYYY-MM-DD HH:mm:ss), verbose formats with AM/PM and month names, and more. The free tool auto-detects the format when you paste a date.

Is the date converter free?

Yes. The single-date converter is completely free with no limits and no sign-in required. You can convert as many individual dates as you want. CSV batch processing (converting an entire column of dates in a file) requires a subscription at $9.99/month, which includes an ad-free experience and can be canceled anytime.

How does timezone conversion work?

The converter supports 98 IANA timezone options and recognizes 99 timezone abbreviations covering every major region. North America: EST, EDT, CST, CDT, MST, MDT, PST, PDT, AKST, AKDT, HST. Canada: AST, ADT, NST, NDT. South America: BRT, BRST, ART, CLT, CLST, COT, PET, VET, BOT, PYT, PYST, UYT, ECT, GFT, SRT, GYT, FKT, FKST. Europe: GMT, BST, WET, WEST, CET, CEST, EET, EEST, MSK, TRT. Middle East: GST, IRST, IRDT, AFT. Asia: IST, PKT, NPT, BTT, MMT, ICT, WIB, SGT, MYT, HKT, PHT, WITA, BNT, WIT, TLT, KST, JST. Africa: WAT, CAT, SAST, EAT. Australia/Pacific: AWST, ACST, ACDT, AEST, AEDT, NZST, NZDT, FJT, FJST, ChST, SST, PGT, SBT, VUT, NCT, MHT, TOT, TVT. Daylight saving time transitions are handled automatically using IANA zone rules.

Is my data safe? Do you upload my files?

No files are ever uploaded. Both the free converter and the CSV batch processor run entirely in your browser using JavaScript. Your data never leaves your device. This makes it safe for financial data, healthcare records, customer PII, and any data subject to GDPR or HIPAA requirements.

How does CSV batch conversion work?

After signing in and subscribing, upload a CSV file (or drag and drop it). Select the column containing your dates, choose the source and target formats, preview the conversion on the first 5 rows, then process the entire file. The converted CSV downloads with all other columns unchanged. Large files are processed using Web Workers so your browser stays responsive.

What is a Unix timestamp and how do I convert it?

A Unix timestamp is the number of seconds (or milliseconds) since January 1, 1970 UTC. A 10-digit number like 1719619200 is seconds; a 13-digit number like 1719619200000 is milliseconds. Paste either into the converter and it will auto-detect the format and convert it to any human-readable date format.

Can I convert between US and European date formats?

Yes. The converter handles both MM/DD/YYYY (US) and DD.MM.YYYY (European) formats, including variants with time components. For single dates, paste and convert. For CSV files, select the source column and convert the entire column from one convention to the other.

Are there row limits on CSV processing?

No. There are no artificial row limits or file size caps. The converter processes files with thousands or millions of rows. Processing runs on a Web Worker thread, and you can see real-time progress with a rows-per-second counter. You can cancel at any time if needed.

How do I cancel my subscription?

Click 'Manage Subscription' in the CSV section (when signed in) to open the Stripe customer portal. From there you can cancel, update your payment method, or view invoices. Cancellation takes effect at the end of your current billing period.

What browsers are supported?

The converter works in all modern browsers including Chrome, Firefox, Safari, and Edge on both desktop and mobile. Web Workers are used for CSV processing, which are supported in all current browsers.

Need to Convert Dates in a CSV File?

Batch-convert an entire column of timestamps — unlimited rows, no data uploaded, all processing in your browser. Plus a clean, ad-free workspace.

Try CSV Processing — $9.99/mo

The single-date converter above is free forever. CSV batch mode is $9.99/mo — ad-free, cancel anytime.