Icon

06_​DateTime_​Manipulation

DateTime Manipulation - Exercise
Exercise 6: Date and Time ManipulationIn this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter data based on Date&Time values. 2a) Extract the product purchasesthat were submitted in 20192b) Extract the remaining productpurchases into a separate table 3) Extract quarter and year of eachproduct purchase into separatecolumns 1) Convert order dates from stringto Date&Time Read joined andpreprocessed data Exercise 6: Date and Time ManipulationIn this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter data based on Date&Time values. 2a) Extract the product purchasesthat were submitted in 20192b) Extract the remaining productpurchases into a separate table 3) Extract quarter and year of eachproduct purchase into separatecolumns 1) Convert order dates from stringto Date&Time Read joined andpreprocessed data

Nodes

Extensions

Links