ToTime / String Layer

Convert string values to time-of-day without date components. Similar to Python's datetime.strptime().time() or Rust's NaiveTime::parse_from_str(). Creates a time-only column. Useful for:

Processing daily schedules
Working with business hours
Analyzing time patterns
Standardizing time formats

Table

Select

column

The string column containing time text. Values not matching the format will become null.

Format

string

Time format pattern using strftime syntax. Common formats:

%H:%M:%S for 24-hour time (15:30:45)
%I:%M:%S %p for 12-hour time (03:30:45 PM)
%H:%M for hour/minute only (15:30)

If not provided, attempts to infer format from data.

Exact

bool

true

Controls format matching behavior:

true: String must exactly match format (15:30:45)
false: Format can match within text (Time: 15:30:45 GMT)

Use true for strict parsing, false for flexible text

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.