Menu

#2 Change updated_on data type

open-remind
nobody
None
5
2007-12-04
2007-11-22
Abel
No

Hi,

Are you planning changing the data type format for 'updated_on' from 'text' to 'datetime'. It would be great in order to sort results by date more easily.

Thank you.

Discussion

  • Josh Abraham

    Josh Abraham - 2007-12-04
    • status: open --> pending-remind
     
  • Josh Abraham

    Josh Abraham - 2007-12-04

    Logged In: YES
    user_id=1254539
    Originator: NO

    I am planning a release of 2.05 sometime during the winter break. I will consider this type of change but it depends on how my testing goes. If not for 2.05 or 2.06 I will most likely implement this sort of thing in a future release (2.20).

    Regards,
    Josh

     
  • Abel

    Abel - 2007-12-04

    Logged In: YES
    user_id=1943146
    Originator: YES

    Well, till then I will be using STR_TO_DATE(machines.created_on, '%a %b %d %T %Y')
    I think this could also be accomplished with libdate-manip-perl when inserting the data into the database, but unfortunately I can't write Perl right now.

    Thank you for your response.

     
  • Abel

    Abel - 2007-12-04
    • status: pending-remind --> open-remind
     

Log in to post a comment.

MongoDB Logo MongoDB