2 Replies Latest reply on Dec 13, 2013 11:02 PM by Dude!

    Chronological sequence of 'content'

    EdStevens

      Am noticing this today.  When viewing the 'content' tab of a space, one expects them to be in chronological order, with the newest at the top.

      But take a look at this, just now taken from the "sql pl/sql' space.  Read it from the bottom up

       

      Title    Author    Likes    Bookmarks    Replies    Views    Latest activity   

         

      Executing OS Commands with DBMS_SCHEDULER

          gerhard2001                1    0    6    77    December 13, 2013 1:20 PM    

         

      Join cardinality without statistics interesting result

          NightWing                4    0    6    133    December 13, 2013 1:20 PM    

         

      PL/SQL Insert all rows queried into another table

          NewApexCoder                0    0    6    61    December 13, 2013 1:13 PM    

         

      Oracle not valid function or procedure

          ac23654e-fde2-4d98-8f3b-134f67506269    0    0    0    10    December 13, 2013 1:08 PM    

         

      Auto Invoice Program taking too much time : problem with update sql

          KaranKukreja                0    0    11    96    December 13, 2013 12:55 PM    

         

      select statement

          849776                    0    0    5    35    December 13, 2013 11:54 AM    

         

      Best way to join 2 columns from table A to same column in Table B?

          FJW                    1    0    2    52    December 13, 2013 11:49 AM    

         

      GROUPING WITHING GROUPING using MERGE

          921311                    0    0    9    143    December 13, 2013 11:22 AM    

         

      Copying the tables

          1009273                    0    0    4    50    December 13, 2013 1:25 PM    

         

      2 queries result in different columns

          979596                    0    0    9    105    December 13, 2013 10:50 AM    

         

      SUM table on different database

          user10649758                1    0    6    62    December 13, 2013 7:58 AM    

         

      help with a dummy record in an increment field

          user7618750                2    0    3    37    December 13, 2013 10:36 AM    

        • 1. Re: Chronological sequence of 'content'
          jgarry

          It's almost as though sometimes it is honoring timezone, and other times not.

           

          I once saw that where one db access was started up under csh with no TZ (so defaulted to midwest), while others were pst korn shell.  People accumulating time data from east and west coasts were going nuts.

          • 2. Re: Chronological sequence of 'content'
            Dude!

            Could it be that the system is simply showing the local time of the user? Which is however irrelevant in terms of the order postings come in?

             

            If I had designed the forum system I would not rely on time, but rather use a system generated sequential ID when people are transmitting their stories, similar to Oracle SCN.