Thread

Is there any particular reason why “year”, “month” and “day” are set to CHAR type instead of INT in exp_channel_titles? I’m was trying to make a custom query that ordered the months and because the sorting logic recognized the data as a string instead of an integer, October (10), November(11) and December(12) would show up directly after January.

I changed the column types to INT myself, but I’m hesitant about it breaking some functionality somewhere. If there is a reason this is done, I would like to know so I can figure out another way to get around this.

Thanks.

It won’t hurt anything to change it. Likely there won’t be any additional changes to the database schema. But I’d add a Feature Request for this.

Does that help?

Sure, it helps. Thanks for the info!

Glad that’ll work for you. Don’t hesitate to post again as needed.