'How to extract Hour Year and Month?

SELECT DATEPART(year, (select convert (nvarchar(20),[DateFacture]) FROM [ArcoCerame].[dbo].[FactureClient]))  
    ,DATEPART(month, (select convert (nvarchar(20),[DateFacture]) FROM [ArcoCerame].[dbo].[FactureClient]))  
    ,DATEPART(day, (select convert (nvarchar(20),[DateFacture]) FROM [ArcoCerame].[dbo].[FactureClient]))  
    ,DATEPART(dayofyear, (select convert (nvarchar(20),[DateFacture]) FROM [ArcoCerame].[dbo].[FactureClient]))  
    ,DATEPART(weekday, (select convert (nvarchar(20),[DateFacture]) FROM [ArcoCerame].[dbo].[FactureClient]));

Error:

Msg 512, Niveau 16, État 1, Ligne 1 La sous-requête a retourné plusieurs valeurs. Cela n'est pas autorisé quand la sous-requête suit =, !=, <, <= , >, >= ou quand elle est utilisée en tant qu'expression.

Can you help me guys to correct my statement and thanks in advance

sqlsql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions