Cloud Dataprep can process date information in a variety of sources. When date values are originally imported, they might be typed as String values due to inconsistencies in how they are represented. Using the functions below, you can set the formatting of your date values, so that they are consistently structured throughout your dataset.
Additionally, some of these functions enable you to extract numeric values from dates or to perform comparisons.
You can also convert date values between Unix time values and standard time values, which can be expressed to a precision of milliseconds.
NOTE: Other than the
UNIXTIME function, date functions ignore time zone in Datetime values.
Valid dates fit in the following range: