SNOW-1569842: to_date() function requires column name for the optional fmt parameter

[padhia]

What is the current behavior?

to_date() function signature seems to indicate that only Column names are accepted for the optional fmt parameter

What is the desired behavior?

to_date() function should accept string literals in addition to column names

How would this improve snowflake-snowpark-python?

Feature parity with SQL

References, Other Background

https://docs.snowflake.com/en/sql-reference/functions/to_date#arguments

[sfc-gh-sghosh]

Hello @padhia ,

Thanks for raising the concern.
In Snowpark functions, all parameters are via column name only, applicable to all snowpark functions.
If you want to pass direct string literals values to to_date, you can try using SQL expression, example

`
df = session.create_dataframe([("2021-07-01",)], schema=["date_string"])

df = df.select(expr("TO_DATE('2021-07-01')").alias("converted_date"))

result = df.collect()
for row in result:
print(row)`

Regards,
Sujan

[padhia]

Hello Sujan,

Thank you for getting back. My comment was intended for the second parameter, the format specification. It's almost always the case that the format to convert to is already known. It'd therefore be convenient for the second parameter of the function to be a string literal rather than a Column specification, which requires one to use functions.lit to transform a simple literal string.