Javascript: How to sort a date field?

Question

0.00/5 (No votes)

See more:

How to sort a date field using web sql query?
query = 'SELECT * FROM invoice ORDER BY inv_date';Original table:

C#

id   inv_date    code    amt1
1   03/03/2003  C00002   400   
2   02/02/2001  C00002   300   
3   12/02/2000  C00001   300

Sorted table:

C#

id  inv_date    code   amt1
3  02/02/2001  C00001  300  
1  03/03/2003  C00002  400  
2  12/02/2000  C00002  300

This is the output after sorting how can i sort properly from smallest date to higher?
Can anybody please help me to trigger this out?

Posted 15-Jul-14 21:26pm

p@y@l

Updated 15-Jul-14 21:29pm

Thanks7872

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2014-07-15T21:40:00

Simple: change your database.

Stop storing date (and other numeric values) as strings: store them as an appropriate numeric datatype - in this case DATETIME - and you will be able to sort and compare them without problems.

At the moment, they are strings - NVARCHAR - so the comparison that is used at all times, including for sorting, is a string comparison. Which works by looking at the two values character by character and bases the whole comparison on the first different pair of characters.

It would be possible to convert the date string to a DATETIME for sorting, but that relies on the values always being correct - which is not necessarily correct with strings as it is far too easy to get "bad" data in there.

Sort your DB out - and always use appropriate datatypes!

agent_kruger · Answer 2 · 2014-07-15T22:49:00

Solution 2

sir, best way to store the value lets say "16/07/2014" is like this in numeric format "20140716" and at time of sorting it will manage everything on its own.

Posted 15-Jul-14 22:49pm

agent_kruger