Spliting datatime variable

zal28
2017-04-16
2017-04-17
  • zal28 - 2017-04-16

    Hi,

    How to split up datatime variable?
    I would like to get day, month, year and time separetly?

    Thanks

     
  • chris.beard - 2017-04-16

    I always convert to string and use the standard functions string RIGHT(), DELETE() etc to isolate them.

     
  • zal28 - 2017-04-16

    Thanks for your answer.

     
  • e.kislov - 2017-04-17

    Use CAA DTUTil for Split/Concat DT, Date and TOD.

    It seems easy then string functions.

     

Log in to post a comment.