Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0811


  • If the source Datetime value does not include a valid input for this function, a missing value is returned.
  • D s product
    supports a wide variety of formats for Datetime fields. For more information on supported date formats, see Datetime Data Type. 
  • You can explore the available Datetime formats through the Transformer page. From a column's type drop-down, select Date/Time . Then, select the formatting category. From the displayed drop-down, you can select a specific format. When this transform step is added to your recipe, you can edit it to see how the format is specified in
    D s lang



NOTE: If the platform cannot recognize the date format string, the generated result is written as a string value.



  • Missing values for this function in the source data result in missing values in the output.
  • Multiple columns and wildcards are not supported.



2/15/16 13:26:58.123

3/12/99 2:45:21.456

11/21/11 23:02:18.000

D trans
WrangleTextderive type:single value:dateformat(Timestamp,'h:mm:ss a') as:'newTimestamp'
p01NameFormula type
p01ValueSingle row formula
p02Valuedateformat(Timestamp,'h:mm:ss a')
p03NameNew column name
SearchTermNew formula


NOTE: For this function, use of the lower-case hour indicator (h or hh) requires the use of an AM/PM indicator (a).



1:26:58 PM

2:45:21 AM

11:02:18 PM


D s also