how to find which date is greater using SQL (urgent Help neeed please)

Question

Post reply

how to find which date is greater using SQL (urgent Help neeed please)

dhananjay.nagarkar

Default port

Points: 1496
More actions
November 7, 2013 at 3:34 pm

#279001

Dear friends ,
being new to SQL i needed to know how to find -
“Work Order End Date_WO”is greater than “Previous Work Order Start Date_WO”
Note-both are in same format (date Time) as below:-
Work Order End Date_WO= "2013-01-10 00:00:00.000" and
Previous Work Order Start Date_WO = "2012-12-03 00:00:00.000"
Thanks
Dhananjay

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

You're not new to SQL Server, you've been here long enough to keep posting simple questions.

Please read about data types and Comparison operators.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

dhananjay.nagarkar Default port Points: 1496 More actions · Answer 2

New in the sense for Date related stuff never worked with DATES in SQL much no worries i fgured out the solution.

thanks

Dhananjay

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Well, if you're new to dates, the single best piece of advice I can possibly give you is to store dates in date fields. Don't use string data types or anything else to store a date or a point in time.

Once you get the basics down, Lynn has a good list of common date routines posted at http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/. Please make sure you understand the basics and how they work first. Dates are powerful when used properly and trouble when used improperly.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

CKX SSCrazy Points: 2519 More actions · Answer 4

This one is also a good read.

http://www.karaszi.com/sqlserver/info_datetime.asp