To Date

Creates a column of a date/timestamp type from a string or other non-date column.

See this Snowflake doc for information about valid formats.

Parameters

Name	Type	Description	Is Optional
dates	column_value_dict	dict where the values are the date columns and the keys are the date formats to use for the conversion
overwrite_columns	boolean	Optional: if true, the output columns will overwrite the input columns	True

Example

ds = rasgo.get.dataset(id)

ds2 = ds.to_date(dates={
    'DATE_STRING':'YYYY-MM-DD',
    'DATE2_STR':'YYYY-DD-MM'
  })
ds2.preview()

Source Code

RasgoTransforms/rasgotransforms/rasgotransforms/transforms/to_date/to_date.sql at main · rasgointelligence/RasgoTransformsGitHub