Extract datetime value from the file name
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 02:47 AM
I've the filename as below and I want to extract the datetime values and convert to datetime data type.
This_is_new_file_2024_12_06T11_00_49_AM.csv
Here I want to extract only '2024_12_06T11_00_49' and convert to datetime value in new field. I tried Substr with yyyyMMddHHmmss and it's not working. It's producing only null values instead of the datetime value.
Any help?
