Transform

Deconstruct composite ISO timestamps into separate calendar date and clock time columns

Separate composite timestamp columns into distinct date and time components.

🛡️ Your rows never leave your browser.
Why Onfyt: Handles diverse timestamp formats (ISO with 'T', SQL with space, Unix epoch) and outputs clean standardized date and time fields.

Interactive Sample Data

idtimestampactivity
12026-10-05T14:30:00ZUser login
22026-10-06T09:15:22ZFile upload
32026-10-07T18:00:45ZCheckout

How this tool works

While machine learning pipelines and modern databases love composite ISO 8601 timestamps ('2026-10-05T14:30:00Z'), business reporting users working in Excel, Tableau, or Google Sheets often find them clumsy. When grouping sales figures by day, having varying minute and second values attached to each record forces analysts to write complex formulas just to strip out the time component. Conversely, operations and scheduling analysts studying peak call center traffic often want to analyze the time of day independently of which calendar date the call occurred on—grouping all calls occurring between 14:00 and 15:00 regardless of month or year. DataFix deconstructs composite timestamps into separate, cleanly formatted date and time columns. You can format the date component as standard YYYY-MM-DD, and choose whether the extracted time field should retain 24-hour military notation (HH:MM:SS), strip seconds, or convert to 12-hour AM/PM format. Splitting composite timestamps into distinct date and time components simplifies daily aggregation and time-of-day behavioral analysis in business intelligence tools.

Things that usually go wrong

  • Timestamps without a time component (date-only values) produce an empty time column.
  • Timezone suffixes (Z, +03:00) are removed in the output — use Convert Time Zones first.

Edge cases we tested

🧪 Timestamps with timezone offsets ('2026-10-05T14:30:00+03:00')

Extracts local date/time or converts to UTC based on user toggle.

🧪 Timestamps containing milliseconds ('14:30:00.123456')

Truncates or retains fractional seconds according to user preference.

🧪 Dates already lacking a time component ('2026-10-05')

Populates date column and sets time column to empty string.

Frequently Asked Questions

What timestamp formats are supported?

ISO 8601 (2024-10-05T14:30:00Z), Unix epoch (1728138600), and common formats like '2024-10-05 14:30:00'.

Why would I split a timestamp?

To group records by date only, or to create a time-of-day column for hourly analysis.

What if my timestamp column contains Unix epoch integers?

Unix epoch values (e.g. 1728138600) are detected and converted to UTC before splitting into date and time columns.

Can I keep the original timestamp column alongside the split columns?

Yes — by default the original column is preserved and two new columns are added. Toggle 'Replace original' to overwrite.

Related tools

Transform

Column to Comma-Separated List

Extract a CSV column and convert it to a comma-separated list for SQL IN clauses or code arrays.

Open Tool →
Transform

Comma-Separated List to Column

Convert a comma-separated, line-separated, or SQL IN list into a single-column CSV.

Open Tool →
Transform

Lines to CSV

Convert plain-text newline-delimited records into structured CSV tables.

Open Tool →