{"id":270,"date":"2023-02-22T17:42:31","date_gmt":"2023-02-22T16:42:31","guid":{"rendered":"http:\/\/www.sepchat.com\/SC\/?p=270"},"modified":"2023-02-23T15:02:52","modified_gmt":"2023-02-23T14:02:52","slug":"sql-gestion-des-dates","status":"publish","type":"post","link":"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-gestion-des-dates\/","title":{"rendered":"SQL\u00a0– Gestion des Dates"},"content":{"rendered":"\n

Comment r\u00e9cup\u00e9rer la date du jour avec une requ\u00eate SQL <\/strong>:<\/p>\n\n\n\n

select current date from persphy fetch first 1 rows only<\/p>\n\n\n\n

 ou<\/p>\n\n\n\n

SELECT CURRENT DATE FROM SYSIBM\/SYSDUMMY1 Ou SELECT CURDATE() FROM SYSIBM\/SYSDUMMY1
Aujourd\u2019hui en SQL, au format YYYYMMDD
SELECT
 YEAR(CURRENT DATE) * 10000 +
 MONTH(CURRENT DATE) * 100  +
 DAY(CURRENT DATE )          
 FROM SYSIBM\/SYSDUMMY1 <\/p>\n\n\n\n

Calcul de dates,<\/strong><\/p>\n\n\n\n

SELECT DATE(DAYS(CURRENT DATE)-1) FROM SYSIBM\/SYSDUMMY1
SELECT DATE(DAYS(CURRENT DATE)+1) FROM SYSIBM\/SYSDUMMY1
SELECT DATE(DAYS(CURRENT DATE)+7) FROM SYSIBM\/SYSDUMMY1<\/p>\n\n\n\n

 Libell\u00e9 du mois pour une date donn\u00e9e<\/strong>
SELECT                
CASE MONTH(CURRENT DATE)
WHEN  1 THEN ‘Janvier’
WHEN  2 THEN ‘F\u00e9vrier’
WHEN  3 THEN ‘Mars’
WHEN  4 THEN ‘Avril’
WHEN  5 THEN ‘Mai’
WHEN  6 THEN ‘Juin’
WHEN  7 THEN ‘Juillet’
WHEN  8 THEN ‘Ao\u00fbt’
WHEN  9 THEN ‘Septembre’
WHEN 10 THEN ‘Octobre’
WHEN 11 THEN ‘Novembre’
ELSE         ‘D\u00e9cembre’      
END                  
FROM SYSIBM\/SYSDUMMY1 <\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\n
Cet article vous a \u00e9t\u00e9 utile ? N\u2019h\u00e9sitez pas \u00e0 le partager.<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Comment r\u00e9cup\u00e9rer la date du jour avec une requ\u00eate SQL : select current date from persphy fetch first 1 rows only  ou SELECT CURRENT DATE FROM SYSIBM\/SYSDUMMY1 Ou SELECT CURDATE() FROM SYSIBM\/SYSDUMMY1Aujourd\u2019hui en SQL, au format YYYYMMDDSELECT YEAR(CURRENT DATE) * 10000 + MONTH(CURRENT DATE) * 100  + DAY(CURRENT DATE )           FROM SYSIBM\/SYSDUMMY1  Calcul de dates, SELECT DATE(DAYS(CURRENT DATE)-1) FROM SYSIBM\/SYSDUMMY1SELECT […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts\/270"}],"collection":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":3,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":337,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts\/270\/revisions\/337"}],"wp:attachment":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/media?parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/categories?post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/tags?post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}