MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Change data type | Examples
 
Examples
Source format: "22.3.2009"
Time format: "d.M.y" or "DDDD.MM.YYYY",
but not "DD.MMM.YYYY "
Source format:"03/22/09 30:24 PM"
Time format: "MM/DD/YY hh:mm a" or "M/d/y HH:mm A"
but not "M/d/y HH:MM A" or "m/d/y HH:mm A"
Source format: "Time: 2009-FEBRUARY-01T22:33:44"
Time format: "Time: 'y-MMM-d'T'h:m:s" or "'Time:' y-MMMMM-d'T'h:m:s",
but not "'Time: 'y-MM-d'T'h:m:s"
Source format: "3. quarter 2009"
Time format: "QY" or "Q'. quarter' y or "QQ/yyyy";
but not "YQ"

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release