Day of the week: Difference between revisions
Content added Content deleted
Line 5,314: | Line 5,314: | ||
=={{header|SQL}}== |
=={{header|SQL}}== |
||
===Oracle=== |
|||
SQL has good support for date functions; care must be taken with NLS settings (globalization support), in the code below the date format language is passed in as an argument to the relevant function. (Or, see a variation that does not depend on language settings, after the output shown below.) |
SQL has good support for date functions; care must be taken with NLS settings (globalization support), in the code below the date format language is passed in as an argument to the relevant function. (Or, see a variation that does not depend on language settings, after the output shown below.) |
||
Line 5,356: | Line 5,356: | ||
<syntaxhighlight lang="sql">where dt - trunc(dt, 'iw') = 6</syntaxhighlight> |
<syntaxhighlight lang="sql">where dt - trunc(dt, 'iw') = 6</syntaxhighlight> |
||
===SQLite3=== |
|||
<syntaxhighlight lang="sql">WITH RECURSIVE cte AS ( |
|||
SELECT DATE('2008-12-25', '+'||(12*0)||' months') as dt, 1 AS level |
|||
UNION ALL |
|||
SELECT DATE('2008-12-25', '+'||(12*level)||' months') as dt, c.level + 1 |
|||
FROM cte c |
|||
WHERE c.level <= 2121 - 2008 + 1 |
|||
) |
|||
SELECT strftime('%Y', dt) |
|||
FROM cte |
|||
where strftime('%w', dt) = '0'; |
|||
</syntaxhighlight> |
|||
=={{header|PostgreSQL}}== |
=={{header|PostgreSQL}}== |