plsql left() function 1

plsql left() function

SUBSTR( "20190601", 0, 6 )

Here is what the above code is Doing:
1. We’re using the SUBSTR function to extract the first 6 characters of the date string.
2. We’re using the CONCAT function to concatenate the first 6 characters of the date string with the string “01”.
3. We’re using the CAST function to convert the result of the CONCAT function to a date.

Similar Posts