0

Column Convert - from String to DateTime

Hello, 

I am using in a MODEL the column convert function. I try and convert a String into a DateTime format, but the feature does not seem to act consistently. For instance : 

  • 05/02/2018 13:44:15 converts into 2018-05-02 13:44:15 (not good)
  • 16/02/2018 14:23:05 converts into 2018-02-16 14:23:05 (OK)

Any idea ?

 

Clément

2 replies

null
    • Daniel
    • 5 yrs ago
    • Reported - view

    Hi Clement,

    Please set the format string as below and it will work for you.

    d/M/u H:m:s

    • Clement
    • 5 yrs ago
    • Accepted
    • Reported - view

    Daniel Thanks !

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 2Replies
  • 39Views
  • 2 Following