{"id":7900,"date":"2018-05-31T00:00:00","date_gmt":"2018-05-30T22:00:00","guid":{"rendered":"https:\/\/blog.ouidou.fr\/?p=7900"},"modified":"2024-08-22T12:22:45","modified_gmt":"2024-08-22T10:22:45","slug":"translation-temporelle","status":"publish","type":"post","link":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle","title":{"rendered":"Translation temporelle"},"content":{"rendered":"<p><em>Article \u00e9crit par Fran\u00e7ois <\/em><\/p>\n<p><em>Cette semaine, je me suis essay\u00e9 \u00e0 un nouveau format d\u2019article qui se pr\u00e9sente sous la forme d\u2019une nouvelle de Science-Fiction. Je tiens en passant \u00e0 remercier Valentin pour ses illustrations. N\u2019h\u00e9sitez pas \u00e0 laisser vos impressions dans la section commentaires\u00a0! Bonne lecture.<\/em><\/p>\n<h2 id=\"le-bon-jour\">Le bon jour<\/h2>\n<p>\u00ab\u00a0Le 30 mai\u00a0? C\u2019est une blague\u00a0!? D\u2019o\u00f9 sort cette fichue date\u00a0? \u00c7a n\u2019a strictement aucun sens\u00a0! N\u2019est-on pas fichu de calculer une simple translation temporelle, bon sang\u00a0! Ce n\u2019est pas comme si je vous demandais de faire de l\u2019alg\u00e8bre quantique\u00a0!<br \/>\n\u2014\u00a0Si vous faites r\u00e9f\u00e9rence aux groupes quantiques, intervint J\u00e9r\u00e9mie, tels que pr\u00e9sent\u00e9s par Vladimir Drinfeld, Professeur, on peut toutefois y voir une certaine similitude, en extrapolant un peu \u2014\u00a0bon d\u2019accord, beaucoup\u00a0\u2014 si on les observe tous deux sous l\u2019angle de la commutativit\u00e9. Laissez-moi vous pr\u00e9ciser mon point de vue, si vous me permettez d\u2019enfoncer quelques portes ouvertes et de proc\u00e9der \u00e0 quelques simplifications de notre mod\u00e8le math\u00e9matique afin que tout le monde ici puisse suivre le fil de mes explications.\u00a0\u00bb<\/p>\n<p>Et ce faisant, il s\u2019installa devant la console qui faisait face \u00e0 l\u2019assembl\u00e9e.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/synbioz-website-attachments.s3.eu-west-1.amazonaws.com\/articles\/20180530\/article_franc%CC%A7ois01_thumb_650.png\" alt=\"console\" loading=\"lazy\" \/><\/p>\n<p>\u00ab\u00a0La translation temporelle est chose ais\u00e9e \u00e0 concevoir, reprit-il, mais d\u00e9pendant de tant de param\u00e8tres tous plus sensibles et intangibles les uns que les autres, qu\u2019elle en devient extr\u00eamement complexe \u00e0 impl\u00e9menter dans les faits. Pour illustrer mon propos en faisant abstraction de toute la complexit\u00e9 superflue pouvant entraver la compr\u00e9hension de celui-ci, j\u2019utiliserai un syst\u00e8me de gestion de bases de donn\u00e9es qui a connu ses heures de gloire dans les premi\u00e8res d\u00e9cennies de notre si\u00e8cle et qui, encore de nos jours, reste couramment utilis\u00e9, notamment dans les domaines n\u2019ayant pas l\u2019utilit\u00e9 d\u2019unit\u00e9s de calcul quantiques. Par chance, le fonctionnement interne de cet outil est en tout point similaire aux outils que nous utilisons r\u00e9ellement\u00a0; tout du moins pour le sujet qui nous int\u00e9resse ici.\u00a0\u00bb<\/p>\n<p>Ouvrant une session PostgreSQL sur sa console, J\u00e9r\u00e9mie poursuivit.<\/p>\n<p>\u00ab\u00a0Si je vous demandais quel jour \u00e9tions-nous il y a cinq mois de cela, il y a fort \u00e0 parier que la majorit\u00e9 d\u2019entre vous me r\u00e9pondrait le 31 d\u00e9cembre. Et vous auriez raison. Cela semble \u00e9vident, mais si l\u2019on y regarde de plus pr\u00e8s, \u00e7a ne l\u2019est pas tant que \u00e7a\u00a0! Voyez plut\u00f4t.\u00a0\u00bb<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'5 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"o\">?<\/span><span class=\"k\">column<\/span><span class=\"o\">?<\/span>            <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">---------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span><span class=\"o\">-<\/span><span class=\"mi\">12<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">001<\/span><span class=\"n\">s<\/span>  <span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'4 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">)<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'1 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"o\">?<\/span><span class=\"k\">column<\/span><span class=\"o\">?<\/span>            <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">---------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span><span class=\"o\">-<\/span><span class=\"mi\">12<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">002<\/span><span class=\"n\">s<\/span>  <span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'1 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">)<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'4 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"o\">?<\/span><span class=\"k\">column<\/span><span class=\"o\">?<\/span>            <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">---------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span><span class=\"o\">-<\/span><span class=\"mi\">12<\/span><span class=\"o\">-<\/span><span class=\"mi\">30<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">002<\/span><span class=\"n\">s<\/span>  <span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'3 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">)<\/span> <span class=\"o\">-<\/span> <span class=\"s1\">'2 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"o\">?<\/span><span class=\"k\">column<\/span><span class=\"o\">?<\/span>            <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">---------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span><span class=\"o\">-<\/span><span class=\"mi\">12<\/span><span class=\"o\">-<\/span><span class=\"mi\">29<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">002<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0Il apparait tr\u00e8s clairement que les op\u00e9rations arithm\u00e9tique, m\u00eame les plus triviales, ne sont ni associatives, ni commutatives.<br \/>\n\u2014 Mais on peut ais\u00e9ment \u00e9viter de tomber dans ce genre d\u2019\u00e9cueil\u00a0! se r\u00e9cria un jeune assistant.<br \/>\n\u2014\u00a0En effet, r\u00e9torqua J\u00e9r\u00e9mie, la solution de contournement commun\u00e9ment employ\u00e9e consiste, dans cette situation, \u00e0 se baser initialement sur le premier jour du mois. Car vous l\u2019aviez compris, l\u2019\u00e9cart constat\u00e9 r\u00e9side ici dans le fait que tous les mois ne se ressemblent pas\u00a0: certains comptent 30 jours, d\u2019autres 31, et m\u00eame 28, voire 29 les ann\u00e9es bissextiles, pour le mois de f\u00e9vrier. En s\u2019effor\u00e7ant \u00e0 toujours avoir pour r\u00e9f\u00e9rence le premier jour du mois, nous retombons syst\u00e9matiquement sur nos pattes.\u00a0\u00bb<\/p>\n<p>Pianotant fr\u00e9n\u00e9tiquement sur sa console, J\u00e9r\u00e9mie en fit la d\u00e9monstration sur le champ.<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span>     <span class=\"n\">make_date<\/span><span class=\"p\">(<\/span><span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"nb\">year<\/span> <span class=\"k\">from<\/span> <span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">)::<\/span><span class=\"nb\">int<\/span><span class=\"p\">,<\/span>               <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"k\">month<\/span> <span class=\"k\">from<\/span> <span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">)::<\/span><span class=\"nb\">int<\/span><span class=\"p\">,<\/span>               <span class=\"mi\">1<\/span><span class=\"p\">)<\/span>     <span class=\"o\">-<\/span> <span class=\"s1\">'3 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span>     <span class=\"o\">-<\/span> <span class=\"s1\">'2 months'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span>     <span class=\"o\">+<\/span> <span class=\"n\">make_interval<\/span><span class=\"p\">(<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">,<\/span> <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"k\">day<\/span> <span class=\"k\">from<\/span> <span class=\"s1\">'2068-05-31'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">)::<\/span><span class=\"nb\">int<\/span><span class=\"p\">)<\/span>     <span class=\"o\">-<\/span> <span class=\"s1\">'1 day'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"o\">?<\/span><span class=\"k\">column<\/span><span class=\"o\">?<\/span>            <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">---------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span><span class=\"o\">-<\/span><span class=\"mi\">12<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">---------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">003<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0En passant, juste une petite digression, si vous me le permettez, pour insister sur l\u2019usage d\u2019intervalles, et notamment sur leur int\u00e9r\u00eat lorsqu\u2019on souhaite restreindre \u00e0 une p\u00e9riode donn\u00e9e le champ d\u2019une requ\u00eate. Il serait tentant, pour ce faire, de proc\u00e9der de la sorte.\u00a0\u00bb<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nb\">date<\/span>   <span class=\"k\">FROM<\/span> <span class=\"n\">generate_series<\/span><span class=\"p\">(<\/span><span class=\"s1\">'2060-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2070-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'1 month'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">)<\/span>     <span class=\"k\">AS<\/span> <span class=\"n\">t<\/span><span class=\"p\">(<\/span><span class=\"nb\">date<\/span><span class=\"p\">)<\/span>   <span class=\"k\">WHERE<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nb\">date<\/span> <span class=\"k\">BETWEEN<\/span> <span class=\"s1\">'2068-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span> <span class=\"k\">AND<\/span> <span class=\"s1\">'2068-02-29'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"nb\">date<\/span>                   <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"o\">+<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">02<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"o\">+<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">12<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">017<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0Cependant, l\u2019emploi ici du mot-cl\u00e9 <em>between<\/em> nous force \u00e0 consid\u00e9rer deux dates distinctes, dont une date de fin de p\u00e9riode qui peut s\u2019av\u00e9rer difficile \u00e0 calculer en amont. De plus, les bornes seront, elles, obligatoirement inclusives. Il nous est toutefois possible de ne manipuler qu\u2019une seule date, la date de d\u00e9but de p\u00e9riode, tout en b\u00e9n\u00e9ficiant d\u2019une approche plus souple. Voici donc le m\u00eame exemple trait\u00e9 \u00e0 l\u2019aide d\u2019un intervalle.\u00a0\u00bb<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code> <span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nb\">date<\/span>   <span class=\"k\">FROM<\/span> <span class=\"n\">generate_series<\/span><span class=\"p\">(<\/span><span class=\"s1\">'2060-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2070-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'1 month'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">)<\/span>     <span class=\"k\">AS<\/span> <span class=\"n\">t<\/span><span class=\"p\">(<\/span><span class=\"nb\">date<\/span><span class=\"p\">)<\/span>   <span class=\"k\">WHERE<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nb\">date<\/span> <span class=\"o\">&gt;=<\/span> <span class=\"s1\">'2068-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span>     <span class=\"k\">AND<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nb\">date<\/span> <span class=\"o\">&lt;<\/span> <span class=\"s1\">'2068-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span> <span class=\"o\">+<\/span> <span class=\"mi\">2<\/span> <span class=\"o\">*<\/span> <span class=\"s1\">'1 month'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span> <span class=\"o\">+<\/span><span class=\"c1\">------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"nb\">date<\/span>                   <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"o\">+<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">02<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"p\">:<\/span><span class=\"mi\">00<\/span><span class=\"o\">+<\/span><span class=\"mi\">00<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">2<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">003<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0J\u2019aurais pu \u00e9viter un peu d\u2019arithm\u00e9tiques en employant directement un intervalle de deux mois. Mais en proc\u00e9dant ainsi, il nous est plus ais\u00e9 d\u2019adapter la p\u00e9riode \u00e9tudi\u00e9e. Fin de la parenth\u00e8se. Revenons \u00e0 nos dates, dont nous n\u2019avons l\u00e0 qu\u2019effleur\u00e9 le probl\u00e8me\u00a0! Mais restons cependant dans ce cadre simpliste et t\u00e2chons d\u2019observer ce qu\u2019il se passe lorsque nous manipulons des semaines, cette fois. Question\u00a0: qu\u2019est-ce qu\u2019une semaine\u00a0?<br \/>\n\u2014 Une suite cons\u00e9cutive de sept jours commen\u00e7ant le lundi pour finir le dimanche, r\u00e9pondit l\u2019assistant z\u00e9l\u00e9.<br \/>\n\u2014 C\u2019est exact. D\u2019apr\u00e8s la norme ISO 8601 du moins, car certains pays comme les \u00c9tats-Unis d\u2019Am\u00e9rique, le Canada ou encore l\u2019Australie consid\u00e8rent que la semaine commence le dimanche. Et combien l\u2019ann\u00e9e compte-t-elle de semaines\u00a0? 52, en effet. Parfois 53\u00a0; 52 semaines de 7 jours ne totalisant que 364 jours. \u00c7a se complique d\u00e9j\u00e0 un peu.\u00a0\u00bb<\/p>\n<p>Faisant du regard le tour de l\u2019assembl\u00e9e, J\u00e9r\u00e9mie demanda\u00a0:<\/p>\n<p>\u00ab\u00a0Si maintenant je vous posais la question suivante\u00a0: Quand commence la premi\u00e8re semaine de l\u2019ann\u00e9e\u00a0? Ou exprim\u00e9 autrement, quel est le premier jour de la premi\u00e8re semaine de l\u2019ann\u00e9e\u00a0?\u00a0\u00bb<\/p>\n<p>Tous semblaient r\u00e9fl\u00e9chir \u00e0 cette question, subodorant une subtilit\u00e9 quelconque. J\u00e9r\u00e9mie ne leur laissa pas le temps d\u2019exposer le fruit de leur r\u00e9flexion.<\/p>\n<p>\u00ab\u00a0Pour r\u00e9pondre \u00e0 cette question, voyons ce que nous dit la norme ISO.\u00a0\u00bb<\/p>\n<p>Projetant un court extrait sur les terminaux personnels de ses auditeurs, l\u2019on pouvait y lire\u00a0:<\/p>\n<blockquote><p>By definition, ISO weeks start on Mondays and the first week of a year contains January 4 of that year.<\/p><\/blockquote>\n<p>\u00ab\u00a0En d\u2019autres termes, reprit-il, la premi\u00e8re semaine de l\u2019ann\u00e9e est celle qui inclut le premier jeudi de ladite ann\u00e9e. Prenons quelques exemples pour \u00e9valuer l\u2019impact de ceci.\u00a0\u00bb<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">SELECT<\/span> <span class=\"nb\">date<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span>          <span class=\"n\">to_char<\/span><span class=\"p\">(<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'TMDay'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">jour<\/span><span class=\"p\">,<\/span>          <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"s1\">'isoyear'<\/span> <span class=\"k\">FROM<\/span> <span class=\"nb\">date<\/span><span class=\"p\">)::<\/span><span class=\"nb\">int<\/span> <span class=\"k\">AS<\/span> <span class=\"nv\">\"ann\u00e9e ISO\"<\/span><span class=\"p\">,<\/span>          <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"s1\">'week'<\/span> <span class=\"k\">FROM<\/span> <span class=\"nb\">date<\/span><span class=\"p\">)::<\/span><span class=\"nb\">int<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">semaine<\/span><span class=\"p\">,<\/span>          <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"s1\">'day'<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">(<\/span><span class=\"nb\">date<\/span> <span class=\"o\">+<\/span> <span class=\"s1\">'2 month - 1 day'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">))::<\/span><span class=\"nb\">int<\/span> <span class=\"k\">AS<\/span> <span class=\"nv\">\"f\u00e9v.\"<\/span><span class=\"p\">,<\/span>          <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"s1\">'year'<\/span> <span class=\"k\">FROM<\/span> <span class=\"nb\">date<\/span><span class=\"p\">)::<\/span><span class=\"nb\">int<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">ann<\/span><span class=\"err\">\u00e9<\/span><span class=\"n\">e<\/span>   <span class=\"k\">FROM<\/span> <span class=\"n\">generate_series<\/span><span class=\"p\">(<\/span><span class=\"s1\">'2060-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span>                        <span class=\"s1\">'2070-01-01'<\/span><span class=\"p\">::<\/span><span class=\"nb\">date<\/span><span class=\"p\">,<\/span>                        <span class=\"s1\">'1 year'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">t<\/span><span class=\"p\">(<\/span><span class=\"nb\">date<\/span><span class=\"p\">);<\/span> <span class=\"o\">+<\/span><span class=\"c1\">------------+----------+-------------+-----------+--------+---------+<\/span> <span class=\"o\">|<\/span> <span class=\"nb\">date<\/span>       <span class=\"o\">|<\/span> <span class=\"n\">jour<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">ann<\/span><span class=\"err\">\u00e9<\/span><span class=\"n\">e<\/span> <span class=\"n\">ISO<\/span>   <span class=\"o\">|<\/span> <span class=\"n\">semaine<\/span>   <span class=\"o\">|<\/span> <span class=\"n\">f<\/span><span class=\"err\">\u00e9<\/span><span class=\"n\">v<\/span><span class=\"p\">.<\/span>   <span class=\"o\">|<\/span> <span class=\"n\">ann<\/span><span class=\"err\">\u00e9<\/span><span class=\"n\">e<\/span>   <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">------------+----------+-------------+-----------+--------+---------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2060<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Jeudi<\/span>    <span class=\"o\">|<\/span> <span class=\"mi\">2060<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">1<\/span>         <span class=\"o\">|<\/span> <span class=\"mi\">29<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2060<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2061<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Samedi<\/span>   <span class=\"o\">|<\/span> <span class=\"mi\">2060<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">53<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2061<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2062<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Dimanche<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2061<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">52<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2062<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2063<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Lundi<\/span>    <span class=\"o\">|<\/span> <span class=\"mi\">2063<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">1<\/span>         <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2063<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2064<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Mardi<\/span>    <span class=\"o\">|<\/span> <span class=\"mi\">2064<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">1<\/span>         <span class=\"o\">|<\/span> <span class=\"mi\">29<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2064<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2065<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Jeudi<\/span>    <span class=\"o\">|<\/span> <span class=\"mi\">2065<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">1<\/span>         <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2065<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2066<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Vendredi<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2065<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">53<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2066<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Samedi<\/span>   <span class=\"o\">|<\/span> <span class=\"mi\">2066<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">52<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Dimanche<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2067<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">52<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">29<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2069<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Mardi<\/span>    <span class=\"o\">|<\/span> <span class=\"mi\">2069<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">1<\/span>         <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2069<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2070<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span><span class=\"o\">-<\/span><span class=\"mi\">01<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Mercredi<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2070<\/span>        <span class=\"o\">|<\/span> <span class=\"mi\">1<\/span>         <span class=\"o\">|<\/span> <span class=\"mi\">28<\/span>     <span class=\"o\">|<\/span> <span class=\"mi\">2070<\/span>    <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">------------+----------+-------------+-----------+--------+---------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">11<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">006<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Apr\u00e8s avoir bu une gorg\u00e9e de l\u2019eau contenue dans la bouteille pos\u00e9e pr\u00e8s de lui, J\u00e9r\u00e9mie expliqua\u00a0:<\/p>\n<p>\u00ab\u00a0Si nous regardons l\u2019ann\u00e9e 2068 de plus pr\u00e8s, nous constatons qu\u2019elle d\u00e9bute un dimanche. Et, de ce fait, le premier jour de la premi\u00e8re semaine de l\u2019ann\u00e9e 2068, si l\u2019on s\u2019en tient \u00e0 la d\u00e9finition \u00e9nonc\u00e9e plus t\u00f4t, sera le lundi 2 janvier. Par chance, nos syst\u00e8mes de gestion de base de donn\u00e9es performent dans la manipulation de dates et nous offrent tout un panel de fonctions pour ce faire, comme vous pouvez le constater. Seulement il nous faut rester vigilant \u00e0 chaque instant, et comprendre la port\u00e9e et la signification des donn\u00e9es que nous manipulons.\u00a0\u00bb<\/p>\n<p>R\u00e9ajustant ses oculaires sur son nez aquilin, il poursuivit.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/synbioz-website-attachments.s3.eu-west-1.amazonaws.com\/articles\/20180530\/article_franc%CC%A7ois02_thumb_650.png\" alt=\"oculaires\" loading=\"lazy\" \/><\/p>\n<p>\u00ab\u00a0Mais tr\u00eave de mises en gardes \u00e0 la port\u00e9e de l\u2019entendement d\u2019un jeune \u00e9tudiant de premi\u00e8re ann\u00e9e et passons, si vous le voulez bien, \u00e0 la vitesse sup\u00e9rieure.\u00a0\u00bb<\/p>\n<h2 id=\"la-bonne-heure\">\u00c0 la bonne heure\u00a0!<\/h2>\n<p>\u00ab\u00a0Stocker et manipuler des dates est somme toute n\u00e9cessaire mais rarement suffisant, argua-t-il. Ne serait-ce que pour convenir d\u2019un rendez-vous\u00a0! En effet, dans ce cas il nous faut conna\u00eetre pr\u00e9cis\u00e9ment l\u2019heure dudit rendez-vous, mais aussi son lieu. Et c\u2019est l\u00e0 que les choses se compliquent, faisant survenir de nouvelles notions telles que les fuseaux horaires \u2014\u00a0les fameuses <em>time zones<\/em>\u00a0\u2014 ainsi que les changements d\u2019heure, qu\u2019ils soient r\u00e9currents \u2014\u00a0comme la <em><abbr title=\"Daylight Saving Time\">DST<\/abbr><\/em>\u00a0\u2014 ou ponctuels. Et si l\u2019on n\u2019y prend pas gare, on peut rapidement se retrouver dans des situations inextricables.\u00a0\u00bb<\/p>\n<p>Jouant de son clavier ergopr\u00e9dictif avec toute l\u2019aisance due \u00e0 une longue habitude, J\u00e9r\u00e9mie projeta de nouvelles donn\u00e9es \u00e0 son attentif auditoire.<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">BEGIN<\/span><span class=\"p\">;<\/span>    <span class=\"k\">DROP<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">IF<\/span> <span class=\"k\">EXISTS<\/span> <span class=\"n\">tempo<\/span><span class=\"p\">;<\/span>    <span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">tempo<\/span><span class=\"p\">(<\/span><span class=\"n\">ts<\/span> <span class=\"nb\">timestamp<\/span><span class=\"p\">,<\/span> <span class=\"n\">tstz<\/span> <span class=\"n\">timestamptz<\/span><span class=\"p\">);<\/span>    <span class=\"k\">SET<\/span> <span class=\"n\">TIMEZONE<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'Europe\/Paris'<\/span><span class=\"p\">;<\/span>   <span class=\"k\">SELECT<\/span> <span class=\"n\">now<\/span><span class=\"p\">();<\/span>   <span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">tempo<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"n\">now<\/span><span class=\"p\">(),<\/span> <span class=\"n\">now<\/span><span class=\"p\">());<\/span>    <span class=\"k\">SET<\/span> <span class=\"n\">TIMEZONE<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'Asia\/Pyongyang'<\/span><span class=\"p\">;<\/span>   <span class=\"k\">SELECT<\/span> <span class=\"n\">now<\/span><span class=\"p\">();<\/span>   <span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">tempo<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"n\">now<\/span><span class=\"p\">(),<\/span> <span class=\"n\">now<\/span><span class=\"p\">());<\/span>    <span class=\"k\">SET<\/span> <span class=\"n\">TIMEZONE<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'Europe\/Paris'<\/span><span class=\"p\">;<\/span>   <span class=\"k\">TABLE<\/span> <span class=\"n\">tempo<\/span><span class=\"p\">;<\/span>    <span class=\"k\">SET<\/span> <span class=\"n\">TIMEZONE<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'Asia\/Seoul'<\/span><span class=\"p\">;<\/span>   <span class=\"k\">TABLE<\/span> <span class=\"n\">tempo<\/span><span class=\"p\">;<\/span>    <span class=\"k\">COMMIT<\/span><span class=\"p\">;<\/span>  <span class=\"k\">BEGIN<\/span> <span class=\"k\">DROP<\/span> <span class=\"k\">TABLE<\/span> <span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"k\">SET<\/span> <span class=\"o\">+<\/span><span class=\"c1\">-------------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"n\">now<\/span>                           <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">-------------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">15<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span><span class=\"o\">+<\/span><span class=\"mi\">02<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">-------------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"k\">INSERT<\/span> <span class=\"mi\">0<\/span> <span class=\"mi\">1<\/span> <span class=\"k\">SET<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"n\">now<\/span>                              <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">----------------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">22<\/span><span class=\"p\">:<\/span><span class=\"mi\">18<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span><span class=\"o\">+<\/span><span class=\"mi\">08<\/span><span class=\"p\">:<\/span><span class=\"mi\">30<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"k\">INSERT<\/span> <span class=\"mi\">0<\/span> <span class=\"mi\">1<\/span> <span class=\"k\">SET<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------+-------------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"n\">ts<\/span>                         <span class=\"o\">|<\/span> <span class=\"n\">tstz<\/span>                          <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">----------------------------+-------------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">15<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">15<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span><span class=\"o\">+<\/span><span class=\"mi\">02<\/span> <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">22<\/span><span class=\"p\">:<\/span><span class=\"mi\">18<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">15<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span><span class=\"o\">+<\/span><span class=\"mi\">02<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------+-------------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">2<\/span> <span class=\"k\">SET<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------+-------------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"n\">ts<\/span>                         <span class=\"o\">|<\/span> <span class=\"n\">tstz<\/span>                          <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">----------------------------+-------------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">15<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">22<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span><span class=\"o\">+<\/span><span class=\"mi\">09<\/span> <span class=\"o\">|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">22<\/span><span class=\"p\">:<\/span><span class=\"mi\">18<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">22<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span><span class=\"o\">+<\/span><span class=\"mi\">09<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------+-------------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">2<\/span> <span class=\"k\">COMMIT<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">017<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0Notez l\u2019impact du fuseau horaire\u00a0! Pour l\u2019exemple, j\u2019ai ici demand\u00e9 au syst\u00e8me de gestion de bases de donn\u00e9es de simuler diff\u00e9rentes localisations avant de persister l\u2019horodatage courant. Les plus observateurs parmi vous auront remarqu\u00e9 qu\u2019au sein d\u2019une transaction, le temps est fig\u00e9. Vous vous serez \u00e9galement aper\u00e7us qu\u2019en tout dernier lieu j\u2019ai consult\u00e9 ma donn\u00e9e depuis S\u00e9oul, alors qu\u2019elle a \u00e9t\u00e9 enregistr\u00e9e depuis un fuseau horaire aujourd\u2019hui d\u00e9suet, \u2014\u00a0et ce depuis 50 ans, tr\u00e8s exactement\u00a0\u2014 celui de Pyongyang, ancienne capitale de ce que l\u2019on appelait autrefois la Cor\u00e9e du Nord, aujourd\u2019hui simple pr\u00e9fecture de la R\u00e9publique R\u00e9unifi\u00e9e de Cor\u00e9e\u2026 mais je m\u2019\u00e9gare. L\u2019emploi de ce fuseau horaire me permet de mettre en \u00e9vidence un fait souvent n\u00e9glig\u00e9\u00a0: un d\u00e9calage entre deux fuseaux horaires ne se mesure pas n\u00e9cessairement en heures pleines. La preuve en est, nous avons ici un d\u00e9calage positif de huit heures et trente minutes par rapport au temps universel terrestre.\u00a0\u00bb<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/synbioz-website-attachments.s3.eu-west-1.amazonaws.com\/articles\/20180530\/article_franc%CC%A7ois03_thumb_650.png\" alt=\"une main se leva\" loading=\"lazy\" \/><\/p>\n<p>Une main se leva dans l\u2019assistance, et son propri\u00e9taire prit la parole\u00a0:<\/p>\n<p>\u00ab\u00a0Pardonnez-moi de vous interrompre, et corrigez-moi si je me trompe, mais j\u2019ai le sentiment que ce que l\u2019on gagne d\u2019un c\u00f4t\u00e9, on le perd de l\u2019autre. L\u2019horodatage prenant en compte le fuseau horaire nous pr\u00e9sentant l\u2019information du point de vue de l\u2019observateur, toute trace du fuseau horaire d\u2019origine semble avoir disparue. Y a-t-il un quelconque moyen de retrouver cette donn\u00e9e\u00a0?<br \/>\n\u2014 Ceci est finement observ\u00e9, r\u00e9torqua J\u00e9r\u00e9mie. Et le seul moyen de garder une trace de ce fuseau horaire \u2014\u00a0plus pr\u00e9cis\u00e9ment du d\u00e9calage par rapport \u00e0 UTC\u00a0\u2014 est de stocker ce d\u00e9calage dans une colonne \u00e0 part enti\u00e8re, comme ceci.\u00a0\u00bb<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">BEGIN<\/span><span class=\"p\">;<\/span>    <span class=\"k\">SET<\/span> <span class=\"n\">TIMEZONE<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'Europe\/Paris'<\/span><span class=\"p\">;<\/span>   <span class=\"k\">SELECT<\/span> <span class=\"k\">extract<\/span><span class=\"p\">(<\/span><span class=\"n\">timezone<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">now<\/span><span class=\"p\">());<\/span>    <span class=\"k\">commit<\/span><span class=\"p\">;<\/span>  <span class=\"k\">BEGIN<\/span> <span class=\"k\">SET<\/span> <span class=\"o\">+<\/span><span class=\"c1\">-------------+<\/span> <span class=\"o\">|<\/span> <span class=\"n\">date_part<\/span>   <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">-------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">7200<\/span><span class=\"p\">.<\/span><span class=\"mi\">0<\/span>      <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">-------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"k\">COMMIT<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">002<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0Ainsi, vous l\u2019aurez devin\u00e9, l\u2019unit\u00e9 utilis\u00e9e pour d\u00e9finir ce d\u00e9calage est la seconde. Je vous remercie, cher coll\u00e8gue, pour cette interruption fort \u00e0 propos qui me donne l\u2019occasion de rebondir sur la question de l\u2019utilisation de cette donn\u00e9e une fois recueillie qui, je le vois, br\u00fble les l\u00e8vres de plusieurs de nos confr\u00e8res.\u00a0\u00bb<\/p>\n<p>Un murmure d\u2019approbation parcouru bri\u00e8vement la salle.<\/p>\n<p>\u00ab\u00a0Rien de plus simple, je vous assure\u00a0! En effet, le d\u00e9calage \u00e9tant fonction du fuseau horaire universel, il suffit de s\u2019y positionner pour r\u00e9f\u00e9rence et d\u2019appliquer notre d\u00e9calage sous la forme d\u2019un intervalle de temps en secondes. Regardez.\u00a0\u00bb<\/p>\n<p>Et instantan\u00e9ment furent projet\u00e9es de nouvelles lignes de code illustrant ses dires.<\/p>\n<div class=\"language-sql highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"err\">\u276f\u00a0<\/span><span class=\"k\">BEGIN<\/span><span class=\"p\">;<\/span>    <span class=\"k\">SET<\/span> <span class=\"n\">TIMEZONE<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'UTC'<\/span><span class=\"p\">;<\/span>   <span class=\"k\">SELECT<\/span> <span class=\"n\">now<\/span><span class=\"p\">()<\/span> <span class=\"o\">+<\/span> <span class=\"mi\">7200<\/span> <span class=\"o\">*<\/span> <span class=\"s1\">'1 second'<\/span><span class=\"p\">::<\/span><span class=\"n\">interval<\/span><span class=\"p\">;<\/span>    <span class=\"k\">COMMIT<\/span><span class=\"p\">;<\/span>  <span class=\"k\">BEGIN<\/span> <span class=\"k\">SET<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------+<\/span> <span class=\"o\">|<\/span> <span class=\"o\">?<\/span><span class=\"k\">column<\/span><span class=\"o\">?<\/span>                   <span class=\"o\">|<\/span> <span class=\"o\">|<\/span><span class=\"c1\">----------------------------|<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">2068<\/span><span class=\"o\">-<\/span><span class=\"mi\">05<\/span><span class=\"o\">-<\/span><span class=\"mi\">31<\/span> <span class=\"mi\">15<\/span><span class=\"p\">:<\/span><span class=\"mi\">48<\/span><span class=\"p\">:<\/span><span class=\"mi\">04<\/span><span class=\"p\">.<\/span><span class=\"mi\">505633<\/span> <span class=\"o\">|<\/span> <span class=\"o\">+<\/span><span class=\"c1\">----------------------------+<\/span> <span class=\"k\">SELECT<\/span> <span class=\"mi\">1<\/span> <span class=\"nb\">Time<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">.<\/span><span class=\"mi\">003<\/span><span class=\"n\">s<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>\u00ab\u00a0D\u00e8s lors, vous en conviendrez, en appliquant avec un tant soit peu de rigueur quelques notions \u00e9l\u00e9mentaires, et en anticipant les \u00e9ventuels al\u00e9as que nous r\u00e9serve la g\u00e9opolitique et que nous enseigne la scientonomie, nombre d\u2019erreurs et de situations baroques pourraient \u00eatre \u00e9vit\u00e9es.\u00a0\u00bb<\/p>\n<p>Subjugu\u00e9e par la perspicacit\u00e9 de cette d\u00e9monstration, la foule assembl\u00e9e, claquant des doigts, acclama J\u00e9r\u00e9mie qui se sentit aussit\u00f4t transport\u00e9 par une vague de bien-\u00eatre onirique. La cacophonie de cette multitude se fondit, claquant \u00e0 l\u2019unisson, pour ne devenir qu\u2019un\u2026<\/p>\n<p><em>snap\u00a0! snap\u00a0!<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/synbioz-website-attachments.s3.eu-west-1.amazonaws.com\/articles\/20180530\/article_franc%CC%A7ois04_thumb_650.png\" alt=\"snap snap\" loading=\"lazy\" \/><\/p>\n<p>\u00ab\u00a0J\u00e9r\u00e9mie\u00a0? J\u00e9r\u00e9mie\u00a0! Ma parole, mon gar\u00e7on, voil\u00e0 que vous r\u00eavassez encore\u00a0! Gaston lui-m\u00eame ferait figure d\u2019employ\u00e9 z\u00e9l\u00e9 \u00e0 vos c\u00f4t\u00e9s\u00a0! Je ne sais pas \u00e0 quoi vous occupez vos nuits, mais t\u00e2chez de leur r\u00e9server vos r\u00eaveries et d\u2019\u00eatre davantage attentif, bon sang\u00a0!<br \/>\n\u2014 Pardonnez-moi, Professeur, marmonna J\u00e9r\u00e9mie sorti de sa stupeur.<br \/>\n\u2014 Passons. Le 30\u00a0mai, disais-je, reprit le Professeur, c\u2019est tout bonnement impossible, c\u2019est le jour du mariage de ma fille\u00a0!<br \/>\n\u2014 Bien s\u00fbr. Toutes mes excuses, Professeur. Je vais imm\u00e9diatement vous trouver un autre rendez-vous.<\/p>\n<h2 id=\"sources\">Sources<\/h2>\n<ul>\n<li><a href=\"https:\/\/momjian.us\/main\/blogs\/pgblog\/2017.html#September_27_2017\">Bruce Momjian\u00a0\u2014\u00a0Storing the Original Time Zone<\/a><\/li>\n<li><a href=\"https:\/\/momjian.us\/main\/blogs\/pgblog\/2017.html#June_21_2017\">Bruce Momjian\u00a0\u2014\u00a0Odd Month Arithmetic<\/a><\/li>\n<li><a href=\"https:\/\/momjian.us\/main\/blogs\/pgblog\/2017.html#June_19_2017\">Bruce Momjian\u00a0\u2014\u00a0Use With Time Zone<\/a><\/li>\n<li><a href=\"https:\/\/www.timeanddate.com\/news\/time\/north-korea-aligns-with-south.html\">TimeAndDate.com\u00a0\u2014\u00a0North Korea Turns Its Clocks to Align with South<\/a><\/li>\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/functions-datetime.html\">PostgreSQL.org\u00a0\u2014\u00a0Date\/Time Functions and Operators<\/a><\/li>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/18188151\/how-to-convert-local-time-to-utc#18194874\">StackOverflow\u00a0\u2014\u00a0How to convert local time to UTC\u00a0?<\/a><\/li>\n<li><a href=\"https:\/\/tapoueh.org\/blog\/2017\/06\/postgresql-and-the-calendar\/\">Dimitri Fontaine\u00a0\u2014\u00a0PostgreSQL and the calendar<\/a><\/li>\n<li><a href=\"https:\/\/tapoueh.org\/blog\/2018\/04\/postgresql-data-types-date-and-time-processing\/\">Dimitri Fontaine\u00a0\u2014\u00a0PostgreSQL Data Types\u00a0: Date and Time Processing<\/a><\/li>\n<li><a href=\"https:\/\/tapoueh.org\/blog\/2018\/04\/postgresql-data-types-date-timestamp-and-time-zones\/\">Dimitri Fontaine\u00a0\u2014\u00a0PostgreSQL Data Types\u00a0: Date, Timestamp, and Time Zones<\/a><\/li>\n<li><a href=\"https:\/\/scientowiki.com\/Main_Page\">Encyclopedia of Scientonomy<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>R\u00e9cit d&rsquo;un voyage temporel<\/p>\n","protected":false},"author":10,"featured_media":10274,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[34],"tags":[],"class_list":["post-7900","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles-techniques"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Translation temporelle - Ouidou<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez la traduction temporelle, une approche innovante pour g\u00e9rer les changements et \u00e9volutions dans vos syst\u00e8mes et applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Translation temporelle - Ouidou\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couvrez la traduction temporelle, une approche innovante pour g\u00e9rer les changements et \u00e9volutions dans vos syst\u00e8mes et applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle\" \/>\n<meta property=\"og:site_name\" content=\"Ouidou\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-30T22:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-22T10:22:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/05\/Etat-des-lieux-des-polices-6.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1105\" \/>\n\t<meta property=\"og:image:height\" content=\"564\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sara Lourties\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sara Lourties\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle\"},\"author\":{\"name\":\"Sara Lourties\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/person\\\/e1d66085fb7c22ede319ce56adc373a4\"},\"headline\":\"Translation temporelle\",\"datePublished\":\"2018-05-30T22:00:00+00:00\",\"dateModified\":\"2024-08-22T10:22:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle\"},\"wordCount\":2048,\"publisher\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Etat-des-lieux-des-polices-6.png\",\"articleSection\":[\"Articles Techniques\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle\",\"name\":\"Translation temporelle - Ouidou\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Etat-des-lieux-des-polices-6.png\",\"datePublished\":\"2018-05-30T22:00:00+00:00\",\"dateModified\":\"2024-08-22T10:22:45+00:00\",\"description\":\"D\u00e9couvrez la traduction temporelle, une approche innovante pour g\u00e9rer les changements et \u00e9volutions dans vos syst\u00e8mes et applications.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#primaryimage\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Etat-des-lieux-des-polices-6.png\",\"contentUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Etat-des-lieux-des-polices-6.png\",\"width\":1105,\"height\":564},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/translation-temporelle#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Translation temporelle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\",\"name\":\"Blog Ouidou\",\"description\":\"Conseil et expertise en technologies\",\"publisher\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\",\"name\":\"Ouidou\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/image_2022-04-13_150237378.png\",\"contentUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/image_2022-04-13_150237378.png\",\"width\":180,\"height\":180,\"caption\":\"Ouidou\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/person\\\/e1d66085fb7c22ede319ce56adc373a4\",\"name\":\"Sara Lourties\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"caption\":\"Sara Lourties\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Translation temporelle - Ouidou","description":"D\u00e9couvrez la traduction temporelle, une approche innovante pour g\u00e9rer les changements et \u00e9volutions dans vos syst\u00e8mes et applications.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle","og_locale":"fr_FR","og_type":"article","og_title":"Translation temporelle - Ouidou","og_description":"D\u00e9couvrez la traduction temporelle, une approche innovante pour g\u00e9rer les changements et \u00e9volutions dans vos syst\u00e8mes et applications.","og_url":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle","og_site_name":"Ouidou","article_published_time":"2018-05-30T22:00:00+00:00","article_modified_time":"2024-08-22T10:22:45+00:00","og_image":[{"width":1105,"height":564,"url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/05\/Etat-des-lieux-des-polices-6.png","type":"image\/png"}],"author":"Sara Lourties","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Sara Lourties","Dur\u00e9e de lecture estim\u00e9e":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#article","isPartOf":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle"},"author":{"name":"Sara Lourties","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/person\/e1d66085fb7c22ede319ce56adc373a4"},"headline":"Translation temporelle","datePublished":"2018-05-30T22:00:00+00:00","dateModified":"2024-08-22T10:22:45+00:00","mainEntityOfPage":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle"},"wordCount":2048,"publisher":{"@id":"https:\/\/ouidou.fr\/blog\/#organization"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#primaryimage"},"thumbnailUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/05\/Etat-des-lieux-des-polices-6.png","articleSection":["Articles Techniques"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle","url":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle","name":"Translation temporelle - Ouidou","isPartOf":{"@id":"https:\/\/ouidou.fr\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#primaryimage"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#primaryimage"},"thumbnailUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/05\/Etat-des-lieux-des-polices-6.png","datePublished":"2018-05-30T22:00:00+00:00","dateModified":"2024-08-22T10:22:45+00:00","description":"D\u00e9couvrez la traduction temporelle, une approche innovante pour g\u00e9rer les changements et \u00e9volutions dans vos syst\u00e8mes et applications.","breadcrumb":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#primaryimage","url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/05\/Etat-des-lieux-des-polices-6.png","contentUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/05\/Etat-des-lieux-des-polices-6.png","width":1105,"height":564},{"@type":"BreadcrumbList","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/translation-temporelle#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/ouidou.fr\/blog\/"},{"@type":"ListItem","position":2,"name":"Translation temporelle"}]},{"@type":"WebSite","@id":"https:\/\/ouidou.fr\/blog\/#website","url":"https:\/\/ouidou.fr\/blog\/","name":"Blog Ouidou","description":"Conseil et expertise en technologies","publisher":{"@id":"https:\/\/ouidou.fr\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ouidou.fr\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/ouidou.fr\/blog\/#organization","name":"Ouidou","url":"https:\/\/ouidou.fr\/blog\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2022\/04\/image_2022-04-13_150237378.png","contentUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2022\/04\/image_2022-04-13_150237378.png","width":180,"height":180,"caption":"Ouidou"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/person\/e1d66085fb7c22ede319ce56adc373a4","name":"Sara Lourties","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","caption":"Sara Lourties"}}]}},"_links":{"self":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/7900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/comments?post=7900"}],"version-history":[{"count":2,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/7900\/revisions"}],"predecessor-version":[{"id":10275,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/7900\/revisions\/10275"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/media\/10274"}],"wp:attachment":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/media?parent=7900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/categories?post=7900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/tags?post=7900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}