Method handleToTimestamp

transpiler/transform/functions.go:488–499

handleToTimestamp converts 2-arg PostgreSQL to_timestamp(text, format) to strptime. 1-arg to_timestamp(epoch) is left unchanged (DuckDB handles it natively).

(fc *pg_query.FuncCall, funcNameIdx int)

// handleToTimestamp converts 2-arg PostgreSQL to_timestamp(text, format) to strptime.
// 1-arg to_timestamp(epoch) is left unchanged (DuckDB handles it natively).
func (t *FunctionTransform) handleToTimestamp(fc *pg_query.FuncCall, funcNameIdx int) bool {
	if len(fc.Args) != 2 {
		// 1-arg form: to_timestamp(epoch) — DuckDB handles natively
		return false
	}
	formatStr := extractStringConstant(fc.Args[1])
	if formatStr != "" {
		setStringConstant(fc.Args[1], pgDateFormatToStrftime(formatStr))
	}
	renameFuncAndStripPrefix(fc, funcNameIdx, "strptime")
	return true
}

// renameFuncAndStripPrefix renames a function and removes any pg_catalog/public schema prefix.
func renameFuncAndStripPrefix(fc *pg_query.FuncCall, funcNameIdx int, newName string) {