i'm saving in mySQL tables the datetime as unixtimestap to save space...

is it possible to select now that field by SQL and formatting it in a human readable way?

such as with DATE_FORMAT mysql func?

i already know how to do it byPHP but i wish i can do it via mysql client too...

    kante;10969636 wrote:

    i'm saving in mySQL tables the datetime as unixtimestap to save space...

    Why? You're not saving that much space, and you're just shooting yourself in the foot by storing the date in a format that MySQL can't really use without converting it every time.

      Write a Reply...