Go Back
Date Formatting Examples
Publisher
: Lingk
Run In Lingk
Description
This recipe parses some static dates and shows how to convert them into other formats. To use this recipe, click Run!
Browse the knowledge base
Twitter
E-Mail
# _____ _ _____ __ # | __ \ (_) |_ _| / _| # | |__) |___ ___ _ _ __ ___ | | _ __ | |_ ___ # | _ // _ \/ __| | '_ \ / _ \ | | | '_ \| _/ _ \ # | | \ \ __/ (__| | |_) | __/ _| |_| | | | || (_) | # |_| \_\___|\___|_| .__/ \___| |_____|_| |_|_| \___/ # | | # |_| # Project Name - DATE FORMATTING EXAMPLES # Recipe URL - https://app.lingk.io/a/10932/tf/17855 # Description - # This recipe parses some static dates and shows how to convert them into other formats. # To use this recipe, click Run! # Industry - Higher Ed # Business Process - Graduate Reporting # Systems - # Connectors - JSON # Data Flows - Single Direction # Connection Type - JSON # Add Recipe notes / Change log information here! # _____ _ # / ____| | | # | | ___ _ __ _ __ ___ ___| |_ ___ _ __ ___ # | | / _ \| '_ \| '_ \ / _ \/ __| __/ _ \| '__/ __| # | |___| (_) | | | | | | | __/ (__| || (_) | | \__ \ # \_____\___/|_| |_|_| |_|\___|\___|\__\___/|_| |___/ # # CONNECTORS specify what data will be pulled into the in-memory database during processing connectors: # JSON Setup - https://help.lingk.io/en/articles/74-json-connector-reference ###### Start: JSON Connectors ####### - name: placeholder type: json properties: jsonObject: "[]" ###### Start: JSON Connectors ####### # _____ _ _ _ # / ____| | | | | | # | (___ | |_ __ _| |_ ___ _ __ ___ ___ _ __ | |_ ___ # \___ \| __/ _` | __/ _ \ '_ ` _ \ / _ \ '_ \| __/ __| # ____) | || (_| | || __/ | | | | | __/ | | | |_\__ \ # |_____/ \__\__,_|\__\___|_| |_| |_|\___|_| |_|\__|___/ # STATEMENTS specify how the data should be processed while in memory statements: #******************************************************************** D I S C L A I M E R *********************************************************************************************** # * # Note that in an effort to keep recipes optimized for DPH (Data Processing Hours), print statements should be commented out after development has concluded for a recipe. * # For more information on DPH optimization, please visit the following help article - https://help.lingk.io/en/articles/212-minimizing-data-processing-hours-on-the-lingk-platform * # * #******************************************************************** D I S C L A I M E R *********************************************************************************************** # to_date : convert a string a date object # to_timestamp : convert a string a timestamp object # Then - through "date_format" function it provides the format needed to the date retrieved - statement: | (dates) => select to_date("01/18/99", 'MM/dd/yy'), to_date('2009-07-30 04:17:52'), to_date('2016-12-31', 'yyyy-MM-dd'), to_timestamp('2016-12-31', 'yyyy-MM-dd'), date_format(to_date("01/18/99", 'MM/dd/yy'), 'yyyy-MM-dd'), date_format(to_date("2009-07-30 04:17:52"), 'EEE MMM dd HH:mm:ss zzz yyyy'), date_format(current_timestamp(), 'EEE MMM dd HH:mm:ss zzz yyyy'), date_format(current_timestamp(), "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'") #- statement: print dates # Add more statements to convert, join, aggregrate, transform, and integrate your data
Salesforce Org to Org Migration with Record Types
Automatic Union of Multiple JSON files