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
-
I was actually able to use the ToDate function for this. So, I am good on this
Thanks