none
Get only date in YYYY-MM-DD format from date time format using derived column RRS feed

  • Question

  • I want to get the date in YYYY-MM-DD format from date time format from a column called CreatedDate using Derived Column like below : 

     

    to 

    

    I tried to use LEFT function but it doesn't support Date Types.Same for getting each part alone using the YEAR,MONTH and DAY function and trying to concatenate the result.So I need to convert it to string.I'm beginner in SSIS

    mercredi 8 mai 2019 11:44

Réponses

Toutes les réponses