Converting a DATETIME value to a DATE value

To convert a DATETIME value to a DATE value:

  1. Use dtextend() to adjust the DATETIME qualifier to year to day.
  2. Apply dttoasc() to create a character string in the form yyyy-mm-dd.
  3. Use rdefmtdate() with a pattern argument of yyyy-mm-dd to convert the string to a DATE value.
Parent topic: Data conversion for DATETIME values
Copyright© 2019 HCL Technologies Limited