Store multiple value in single column

[devil_vin]

Hi..guys! I have a column which need to store multiple time value,like 11:00am,2:00pm,5:30pm.How can that single column fix it?And how to control time format in between 12-hours and 24-hours format?Thanks....

[Lars_Berg]

You should never store multiple values in a column. Make a normalized data model.

[Sxooter]

devil_vin wrote:

Hi..guys! I have a column which need to store multiple time value,like 11:00am,2:00pm,5:30pm.How can that single column fix it?And how to control time format in between 12-hours and 24-hours format?Thanks....

If you were using PostgreSQL you could use one it's types in an array.

However, without arrayed types, I would strongly advise against storing >1 val in a single column, as you lose all the ability of the db to check the type for correctness and / or join on it or anything else like that.