Two dates

Started by miguelcorreia, 23 February 2016, 23:40:26

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9
Print
Go Down Pages1
User actions

miguelcorreia

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,
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

miguelcorreia

#1
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.

federica

#2
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.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]
Print
Go Up Pages1
User actions