1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| DECLARE @MaDate DATETIME2 = '2017-12-09T12:30:14.657';
-- SQL Server 2008 R2 et versions d'avant
SELECT 'CONVERT(VARCHAR(30) , @MaDate , 126)' As Expression, CONVERT(VARCHAR(30) , @MaDate , 126) AS Resultat, 'Format ISO8601' AS Commentaire
UNION ALL SELECT 'CONVERT(VARCHAR(10), @MaDate, 103)' As Expression, CONVERT(VARCHAR(10), @MaDate, 103) AS Resultat, '103 = jj/mm/aaaa' AS Commentaire
-- SQL Server 2012 et versions suivantes
UNION ALL SELECT 'FORMAT(@MaDate, ''dd/MM/yyyy'')' AS Expression, FORMAT(@MaDate, 'dd/MM/yyyy') AS Resultat, '' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''dd/MM/yyyy hh:mm'')' AS Expression, FORMAT(@MaDate, 'dd/MM/yyyy hh:mm') AS Resultat, '' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''dd/MM/yyyy hh:mm:ss'')' AS Expression, FORMAT(@MaDate, 'dd/MM/yyyy hh:mm:sss') AS Resultat, '' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''dd/MM/yyyy hh:mm:ss.fff'')' AS Expression, FORMAT(@MaDate, 'dd/MM/yyyy hh:mm:sss.fff') AS Resultat, '' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''d'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'd', 'fr-FR') AS Resultat, 'Modèle de date courte' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''D'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'D', 'fr-FR') AS Resultat, 'Modèle de date longue' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''f'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'f', 'fr-FR') AS Resultat, 'Modèle de date/heure complet (heure courte)' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''F'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'F', 'fr-FR') AS Resultat, 'Modèle de date/heure complet (heure longue)' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''g'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'g', 'fr-FR') AS Resultat, 'Modèle de date/heure général (heure courte)' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''G'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'G', 'fr-FR') AS Resultat, 'Modèle de date/heure général (heure longue)' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''m'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'm', 'fr-FR') AS Resultat, 'Modèle de mois/jour' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''M'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'M', 'fr-FR') AS Resultat, 'Modèle de mois/jour' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''o'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'o', 'fr-FR') AS Resultat, 'Modèle de date/heure aller-retour' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''O'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'O', 'fr-FR') AS Resultat, 'Modèle de date/heure aller-retour' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''r'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'r', 'fr-FR') AS Resultat, 'Modèle RFC1123' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''R'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'r', 'fr-FR') AS Resultat, 'Modèle RFC1123' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''s'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 's', 'fr-FR') AS Resultat, 'Modèle de date/heure pouvant être trié (reflète la norme ISO8601)' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''t'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 't', 'fr-FR') AS Resultat, 'Modèle dheure courte' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''T'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'T', 'fr-FR') AS Resultat, 'Modèle dheure longue' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''u'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'u', 'fr-FR') AS Resultat, 'Modèle de date/heure universel pouvant être trié' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''U'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'U', 'fr-FR') AS Resultat, 'Modèle de date/heure complet universel' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''y'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'y', 'fr-FR') AS Resultat, 'Modèle dannée/mois' AS Commentaire
UNION ALL SELECT 'FORMAT(@MaDate, ''Y'', ''fr-FR'')' AS Expression, FORMAT (@MaDate, 'Y', 'fr-FR') AS Resultat, 'Modèle dannée/mois' AS Commentaire |
Partager