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

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

ds = rasgo.get.dataset(id)

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

Last updated 2 years ago