Author Topic: Two dates  (Read 819 times)

Offline miguelcorreia

  • Coccinella
  • *
  • Posts: 23
  • Karma: +0/-0
Two dates
« on: 23 February 2016, 23:40:26 »
I have some cases where I  need to set two dates.
Probably this field is limited to only 4 digits. Is there a way to extend it to 9, separated by a hyphen? For example: 2010-2016?
Any workaround for this?

Thanks,

Offline miguelcorreia

  • Coccinella
  • *
  • Posts: 23
  • Karma: +0/-0
Re: Two dates
« Reply #1 on: 26 February 2016, 11:58:02 »
Solved. This has to be done in MySQL tables and allow more characters,
I choosed VARCHAR, because i can make use of special characters like a question mark, where we are not sure of the date.

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.026
  • Karma: +1/-0
Re: Two dates
« Reply #2 on: 26 February 2016, 12:02:31 »
ok, but you will not be able to order the books by year.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!