The format string that you are passing must match the format of your date that you are passing as string.
Try the below and let me know if it works or not:
Yeah, you are right. I tried it while ago and it worked.
Thanks a lot for your reply.
Good to hear that. Please mark the question as answered.
Our string is in the following format, what format string should we pass to the to_date function?
I tried the following format along with a few other other combinations but no luck so far.
to_date(event_instances_start,'YYYY-MM-DD HH24:MI:SS US')
Thanks in advance,
Sorry, I am new to this community. Thanks for guiding me to the correct category.
please accept my apologies for the harsh wording. The fact that I was tired to the bone does in no way excuse me being so rude.
Cross-posting is unfortunate for a simple reason: if I would know in advance that you cross-posted this question, I could prepare my reply in a text editor and simply copy-and-paste it in both forums. That saves me some time.
Now that I didn't know that, I had to look for my previous post first and copy the link. Simply a bit more effort.
And I admit, I'm a lazy bastard. ;-)