Question

Write the SQL queries which will perform the following operations:

1. To display the year from your Date of Admission which is '2023-05-15'.
2. To convert your email id '[email protected]' to lowercase.
3. To remove leading spaces from a string 'my country'.
4. To display current date.
5. To display the value of 10⁶.

Answer 1

1. select year('2023-05-15');
2. select lower('[email protected]');
3. select ltrim('my country');
4. select cur date();
5. select pow(10,6);