2012-05-31 12:00:00.000
select * from Inscription where datePreInscription > 2012-05-31 12:00:00.000
SELECT * FROM Inscription WHERE datePreInscription > CONVERT(DateTime, '2012-05-31 12:00:00.000')
DECLARE @sDate VARCHAR(10) SET @sDate = '2012-05-31' SELECT * FROM Inscription WHERE datePreInscription = @sDate
Set dateformat dmy select * from Inscription where datePreInscription >convert(datetime,'31-5-2012')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)