locked
Partitioning Output - Changing Time to CST vs UTC RRS feed

  • Question

  • If I have an output being written to either blob or ADL Store, and I want to partition the output into folders by time: 

    "folderPath": "Directory/{Year}/{Month}/{Day}/{Hour}"

    How can I make the time component use something other than UTC (like CST)?  I tried to use a function in patitionedBy against the "date" attribute to try and move the time back 6 hours, but got an error saying this is an invalid value:

    {
                        "name": "Year",
                        "value": {
                            "type": "DateTime",
                            "date": "AddHours(SliceStart, -6)",
                            "format": "yyyy"
                        }
                    }

    Basically, since my whole organization runs on CST, I'd like to utilize CST across all of the DateTime related attributes.

    Thanks in advance!

     

    • Edited by DataMic Monday, January 25, 2016 8:40 PM
    Thursday, January 21, 2016 6:51 PM

All replies

  • You could try stating the start time in the pipeline as

    "start": "2016-02-27T06:00:00-06:00",

    or use either among anchor date time/offset/data delay in the dataset definition.

    Thanks, Harish

    Wednesday, March 9, 2016 1:45 AM