I have a table photos
with columns description
and capture_date
. I need to:
- Extract photos captured on the 10th day of any month.
- Summarize the description to be up to 10 characters long, including an ellipsis if the original description is longer than 10 characters.
- Format the
capture_date
as ‘DD.MM HH24:MI’.
Here is the query I have tried:
<code>SELECT
CASE
WHEN LENGTH(description) > 10 THEN SUBSTRING(description, 1, 7) || '...'
ELSE description
END AS summary,
TO_CHAR(capture_date, 'DD.MM HH24:MI') AS date
FROM photos
WHERE EXTRACT(DAY FROM capture_date) = 10
ORDER BY capture_date DESC;
Here is the query I have tried:
```sql
SELECT
CASE
WHEN LENGTH(description) > 10 THEN SUBSTRING(description, 1, 7) || '...'
ELSE description
END AS summary,
TO_CHAR(capture_date, 'DD.MM HH24:MI') AS date
FROM photos
WHERE EXTRACT(DAY FROM capture_date) = 10
ORDER BY capture_date DESC;
</code>
<code>SELECT
CASE
WHEN LENGTH(description) > 10 THEN SUBSTRING(description, 1, 7) || '...'
ELSE description
END AS summary,
TO_CHAR(capture_date, 'DD.MM HH24:MI') AS date
FROM photos
WHERE EXTRACT(DAY FROM capture_date) = 10
ORDER BY capture_date DESC;
Here is the query I have tried:
```sql
SELECT
CASE
WHEN LENGTH(description) > 10 THEN SUBSTRING(description, 1, 7) || '...'
ELSE description
END AS summary,
TO_CHAR(capture_date, 'DD.MM HH24:MI') AS date
FROM photos
WHERE EXTRACT(DAY FROM capture_date) = 10
ORDER BY capture_date DESC;
</code>
SELECT
CASE
WHEN LENGTH(description) > 10 THEN SUBSTRING(description, 1, 7) || '...'
ELSE description
END AS summary,
TO_CHAR(capture_date, 'DD.MM HH24:MI') AS date
FROM photos
WHERE EXTRACT(DAY FROM capture_date) = 10
ORDER BY capture_date DESC;
Here is the query I have tried:
```sql
SELECT
CASE
WHEN LENGTH(description) > 10 THEN SUBSTRING(description, 1, 7) || '...'
ELSE description
END AS summary,
TO_CHAR(capture_date, 'DD.MM HH24:MI') AS date
FROM photos
WHERE EXTRACT(DAY FROM capture_date) = 10
ORDER BY capture_date DESC;
New contributor
Mirolsav Tsintsarski is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.