Your question is Date Format Conversion in SQL. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Mphasis reporting teams need service dates displayed consistently in client-facing operational reports. The source values are stored as PostgreSQL DATE values, which normally display as YYYY-MM-DD.
Write a SQL query against the service_requests table that converts each request_date to the MM/DD/YYYY format using PostgreSQL's built-in TO_CHAR function.
request_date is NULL, returning NULL for the formatted value, and order the results by request_id.| Column | Type | Description |
|---|---|---|
| request_idPK | INTEGER | Unique service request identifier |
| request_date | DATE | Date when the request was received |
| service_type | VARCHAR(40) | Type of Mphasis service requested |