Stack Overflow
Stack Overflow

Questions tagged [date-sorting]

68 questions
87
votes
28 answers

Datatable date sorting dd/mm/yyyy issue

I am using a Jquery plugin called datatables Its fantastic, however I cannot get the dates to sort correctly according to the dd/mm/yyyy format. I have looked at their support formats but none of these fixes seem to work. Can anybody here help me…
jaget
  • 1,909
  • 4
  • 20
  • 27
53
votes
9 answers

how to re-format datetime string in php?

I receive a datetime from a plugin. I put it into a variable: $datetime = "20130409163705"; That actually translates to yyyymmddHHmmss. I would need to display this to the user as a transaction time but it doesn't look proper. I would like to…
Psychocryo
  • 1,863
  • 8
  • 25
  • 31
33
votes
16 answers

Need a way to sort a 100 GB log file by date

So, for some strange reason I end up with a 100GB log file that is unsorted (actually it's partially sorted), while the algorithms that I'm attempting to apply require sorted data. A line in the log file looks like so data data data more…
Gleno
  • 15,466
  • 11
  • 59
  • 81
12
votes
2 answers

Conditional Sorting in ElasticSearch

I have some documents that I would like to sort on a date field. For documents with date equal to a specified date, example today, and all dates after that I would like to sort ascending. For dates before the specified date I would like to sort in…
Javid Al Karuzi
  • 1,243
  • 1
  • 11
  • 10
8
votes
2 answers

How to sort HashMap based on Date?

I trying to sort this HashMap based on date in keys My Hash map: Map m = new HashMap();
Amer
  • 1,820
  • 4
  • 17
  • 24
4
votes
2 answers

Sorting in order of time with two rows

I have my SQL table: +----+-----+-------+-------+ | id | reg | in | out | +----+-----+-------+-------+ | 1 | a | 11:10 | | | 2 | a | | 11:30 | | 3 | b | 06:10 | | | 4 | c | | 07:10…
Browners
  • 81
  • 3
  • 5
4
votes
2 answers

Sort Months PowerBI Designer

I am trying to sort months into PowerBI Designer Preview, it looks like it only can be done alphabetically. But when I look on the internet at images of PowerBI it looks like they are all sorted correctly. Can somebody help me? And there must be…
Birgit Antonissen
  • 41
  • 1
  • 2
4
votes
2 answers

Date string format that sorted lexicographically ascending is chronologically descending?

Encoding calendar dates as strings in the YYYY-MM-DD format (with or without separators, e.g. 2014-04-21, 2014.04.21 or 20140421) has the following properties: Sorting the strings lexicographically ascending (treating them as simple strings,…
Amber Jade Fontana
  • 43
  • 5
3
votes
1 answer

WordPress posts sorted by category and year

I've been on a long google search trying to find the solution to this... I am creating a cv manager theme using a WordPress install to control content. I have managed to organise all WP posts in categories but would also like to list those posts in…
Niels
  • 343
  • 4
  • 15
3
votes
4 answers

java - sorting a hashmap with date inside value object

Possible Duplicate: How to sort a Map on the values in Java? Suppose am having a map like Map studDetails = new HashMap(); And the map contains entries like…
Tijo
  • 41
  • 2
  • 4
2
votes
2 answers

How to select unique row according to last accessed time

I want to get only distinct rows with their respective AnsId, like Qid: 01 have last AnsId: 01 I have following data structure, Qid Time AnsId 01 2011-09-26 12:55:10 01 02 2011-09-26 12:58:32 03 03 2011-09-26 12:59:05 …
user841123
2
votes
0 answers

How to get last date from all dates for each student

I'm making query, which takes all driving courses students had in some period and compares if student has driven all courses that he paid for. I need to get for each student, their last drives startTime, for example - "Martin paid for 5 courses…
user3801263
  • 51
  • 6
2
votes
1 answer

Data table sort by date only sorts the day

I have a Datatable which is a project list and i want to sort the date column into descending. It works but it sorts only the day. What I want is the last added project to come first. My script is: