Click here to Skip to main content
Search within:



Next

compare two datetime using sql server
Sign Up to vote bad
good
See more: SQL-ServerDateTimecomparision
When i write the following sql query under sql server 2008, i get a syntax error. the query aim to retrieve ll the inscriptions that have a 'datePreInscription'(which has a datetime type)column superior to 2012-05-31 12:00:00.000
select * from Inscription where datePreInscription > 2012-05-31 12:00:00.000
Posted 1 Jun '12 - 8:38
elidrissi.amine1428
Edited 1 Jun '12 - 11:11
Maciej Los54.8K
v2
Add a Solution


3 solutions

write below query
 
Set dateformat dmy
 
select * from Inscription where datePreInscription >convert(datetime,'31-5-2012')
  Permalink  
Posted 1 Jun '12 - 8:53
abhinavvijay2.4K
Edited 1 Jun '12 - 11:11
Maciej Los54.8K
v2
Try this:
DECLARE @sDate VARCHAR(10)
 
SET @sDate = '2012-05-31'
 
SELECT * 
FROM Inscription
WHERE datePreInscription = @sDate
  Permalink  
Posted 1 Jun '12 - 11:16
Maciej Los54.8K
Look at the MSDN article [^]about Cast and Convert.
 
SELECT * FROM Inscription WHERE datePreInscription > CONVERT(DateTime, '2012-05-31 12:00:00.000')
  Permalink  
Posted 1 Jun '12 - 11:16
Manas Bhardwaj59K
Comments
elidrissi.amine1 - 2 Jun '12 - 7:13
this is the error message i get: Msg 242, Level 16, State 3, Line 1 The conversion of a varchar data type to data type datetime created value out of range.
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 470
1 OriginalGriff 228
2 Dave Kreskowiak 165
3 Mayur_Panchal 154
4 Richard MacCutchan 152
0 Sergey Alexandrovich Kryukov 8,123
1 OriginalGriff 6,040
2 CPallini 3,432
3 Rohan Leuva 2,703
4 Maciej Los 2,234


Advertise | Privacy | Mobile
Web01 | 2.6.130516.1 | Last Updated 1 Jun 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid