Posted by Joseph, Jan. 4, 2024, 6:30 a.m.

Parse field with two dates?

hi

I have a field with a start and end date (sometimes no end date) in a varchar(4000) format(as below)  .

How can I parse this out to have two fields start and end dates?

Data looks like

~__2019121407025301GMTOFFSET=-18000~__2019121415164202GMTOFFSET=-18000~

desired out is

Start Date 12/14/2019 7:02 AM

End Date 12/14/2019 3:16 PM

 

Thanks

Answer

Answers


Comment
SQLPad user: Leon Wei

- Leon (934)

Jan. 12, 2024, 10:28 a.m.