Date Format Conversion in SQL | Dataford Interview Questions

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.

Requirements

Return the request identifier and the formatted date.
Preserve rows where request_date is NULL, returning NULL for the formatted value, and order the results by request_id.

Schema

service_requests

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

Your question is Date Format Conversion in SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

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.

Requirements

Return the request identifier and the formatted date.
Preserve rows where request_date is NULL, returning NULL for the formatted value, and order the results by request_id.

Schema

service_requests

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

Your question is Date Format Conversion in SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.