Write a SELECT statement that changes the phrase Today is Monday to Today is Tuesday
1
2018-02-26T06:53:07-0500
You can use REPLACE function to change the phrase.
Syntax:
replace(<string>,<matching_string>,<replace_with>)
MySQL, SQL Server, PostgreSQL:
SELECT replace('Today is Monday', 'Monday', 'Tuesday') AS phrase;
Oracle:
SELECT replace('Today is Monday', 'Monday', 'Tuesday') AS phrase FROM dual;
Need a fast expert's response?
Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!
Comments