Method handleToDate

transpiler/transform/functions.go:474–484

handleToDate converts PostgreSQL to_date(text, format) to strptime with converted format.

(fc *pg_query.FuncCall, funcNameIdx int)

// handleToDate converts PostgreSQL to_date(text, format) to strptime with converted format.
func (t *FunctionTransform) handleToDate(fc *pg_query.FuncCall, funcNameIdx int) bool {
	if len(fc.Args) != 2 {
		return false
	}
	formatStr := extractStringConstant(fc.Args[1])
	if formatStr != "" {
		setStringConstant(fc.Args[1], pgDateFormatToStrftime(formatStr))
	}
	renameFuncAndStripPrefix(fc, funcNameIdx, "strptime")
	return true
}

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