Calculateur de Différence de Dates

// Calculer la différence entre deux dates en JavaScript
const date1 = new Date("2023-12-21T10:30:00Z");
const date2 = new Date("2023-12-22T15:45:30Z");
const diffInMs = Math.abs(date2 - date1);
const diffInDays = Math.floor(diffInMs / (1000 * 60 * 60 * 24));
const diffInHours = Math.floor(diffInMs / (1000 * 60 * 60));
const diffInMinutes = Math.floor(diffInMs / (1000 * 60));

console.log(`Différence : ${diffInDays} jours, ${diffInHours} heures, ${diffInMinutes} minutes`);

// Utilisation de moment.js pour des calculs de dates avancés
const moment = require("moment");
const start = moment("2023-12-21 10:30:00");
const end = moment("2023-12-22 15:45:30");
const duration = moment.duration(end.diff(start));

console.log(`Jours : ${duration.days()}`);
console.log(`Heures : ${duration.hours()}`);
console.log(`Minutes : ${duration.minutes()}`);
console.log(`Total heures : ${duration.asHours()}`);

<?php
// Calculer la différence entre deux dates en PHP
$date1 = new DateTime("2023-12-21 10:30:00");
$date2 = new DateTime("2023-12-22 15:45:30");
$interval = $date1->diff($date2);

echo "Différence : " . $interval->days . " jours, ";
echo $interval->h . " heures, ";
echo $interval->i . " minutes, ";
echo $interval->s . " secondes\n";

// Différence totale dans différentes unités
echo "Total heures : " . $interval->days * 24 + $interval->h . "\n";
echo "Total minutes : " . ($interval->days * 24 + $interval->h) * 60 + $interval->i . "\n";

<?php
// Utilisation de Carbon pour des calculs de dates avancés
use Carbon\Carbon;

$start = Carbon::parse("2023-12-21 10:30:00");
$end = Carbon::parse("2023-12-22 15:45:30");

$diffInDays = $start->diffInDays($end);
$diffInHours = $start->diffInHours($end);
$diffInMinutes = $start->diffInMinutes($end);
$diffInSeconds = $start->diffInSeconds($end);

// Calcul des jours ouvrables
$businessDays = $start->diffInWeekdays($end);

echo "Jours ouvrables : " . $businessDays . "\n";
echo "Total jours : " . $diffInDays . "\n";

# Calculer la différence entre deux dates en Python
from datetime import datetime, timedelta

date1 = datetime.strptime("2023-12-21 10:30:00", "%Y-%m-%d %H:%M:%S")
date2 = datetime.strptime("2023-12-22 15:45:30", "%Y-%m-%d %H:%M:%S")

difference = date2 - date1
total_seconds = difference.total_seconds()
total_hours = total_seconds / 3600
total_days = total_seconds / 86400

print(f"Total secondes : {total_seconds}")
print(f"Total heures : {total_hours}")
print(f"Total jours : {total_days}")
print(f"Jours : {difference.days}")
print(f"Secondes : {difference.seconds}")

# Utilisation de pandas pour le calcul des jours ouvrables
import pandas as pd
from datetime import datetime

start_date = pd.to_datetime("2023-12-21")
end_date = pd.to_datetime("2023-12-22")

# Calculer les jours ouvrables (excluant les week-ends)
business_days = pd.bdate_range(start=start_date, end=end_date, freq="B").size

# Calculer le total des jours
total_days = (end_date - start_date).days

print(f"Jours ouvrables : {business_days}")
print(f"Total jours : {total_days}")

-- Calcul de différence de dates MySQL
SELECT 
    DATEDIFF("2023-12-22 15:45:30", "2023-12-21 10:30:00") AS difference_jours,
    TIMESTAMPDIFF(HOUR, "2023-12-21 10:30:00", "2023-12-22 15:45:30") AS difference_heures,
    TIMESTAMPDIFF(MINUTE, "2023-12-21 10:30:00", "2023-12-22 15:45:30") AS difference_minutes,
    TIMESTAMPDIFF(SECOND, "2023-12-21 10:30:00", "2023-12-22 15:45:30") AS difference_secondes;

-- Calcul de différence de dates PostgreSQL
SELECT 
    "2023-12-22 15:45:30"::timestamp - "2023-12-21 10:30:00"::timestamp AS difference_intervalle,
    EXTRACT(EPOCH FROM ("2023-12-22 15:45:30"::timestamp - "2023-12-21 10:30:00"::timestamp)) AS difference_secondes,
    EXTRACT(EPOCH FROM ("2023-12-22 15:45:30"::timestamp - "2023-12-21 10:30:00"::timestamp)) / 3600 AS difference_heures;