I've looked at the existing date variable conversion threads and can't find one that helps for this specific type of format. Here's examples of the strings in the variable
TIMESTAMP
20210219_193618
20210219_195936
20210220_143856
20210220_161023
20210221_154242
20210221_161101
20210221_172955
20210221_181902
20210221_185542
20210221_192824
As you can see the format has the year, month then day, followed by an underscore, then the hours, minutes and seconds.
How can I convert this to a date format? I've tried the following code -
Code:
generate voucher_date=clock(TIMESTAMP, "yyyymmdd_hhmmss")
0 Response to Date variable conversion from string format
Post a Comment