String and Date Manipulation Questions

Covers practical skills for manipulating textual and temporal data. Typical expectations include string operations such as concatenation, substring extraction, case transformation, pattern replacement, and trimming, as well as date and time operations such as truncation, extracting date parts, computing differences, adding intervals, formatting, and handling time zones and daylight saving edge cases. Candidates may be asked to write or explain queries and small code snippets, reason about correctness and performance, and discuss pitfalls such as locale formats, leap seconds, and ambiguous input.