Bon, ca avance, ca avance...
Mais c'est pas encore ca!
Ca, ca marche:
select id, convert(varchar,datepart("dd",date)) from table group by id, convert(varchar,datepart("dd",date))
Ca aussi:
select id, convert(varchar,datepart("mm",date)) from table group by id, convert(varchar,datepart("mm",date))
Mais comment je peux faire pour avoir un format dd/mm/yyyy?????
Parce que ca:
select id, convert(varchar,datepart("dd/mm/yy",date)) from table group by id, convert(varchar,datepart("dd/mm/yy",date))
..ben ca marche pas
Partager