0

ORIG Date format - strip time & convert to DATE column

 I need some help in converting the datetime to DATE format and then keep it as a date column rather than a string. For example, we have this ORIG_DT which is a datetime and I use the DateFormat to strip the time component but when I do that it converts to text string (see 2nd snip of ORIG_DATE). How can I convert this back to DATE column rather than text string maybe using the createDate function or something.

 

 

 

Thanks

1 reply

null
    • Jashanpreet_Sandhu
    • yesterday
    • Reported - view

    I was actually able to use the ToDate function for this. So, I am good on this 

    Thanks

Content aside

  • Status Answered
  • yesterdayLast active
  • 1Replies
  • 5Views
  • 1 Following