在数据库中存储时间 (hh:mm) 的最佳方式

我想将时间存储在数据库表中,但只需要存储小时和分钟.我知道我可以只使用 DATETIME 并忽略日期的其他组成部分,但是在不存储比我实际需要的更多信息的情况下执行此操作的最佳方法是什么?

I want to store times in a database table but only need to store the hours and minutes. I know I could just use DATETIME and ignore the other components of the date, but what's the best way to do this without storing more info than I actually need?

推荐答案

您可以将其存储为午夜过后分钟数的整数:

You could store it as an integer of the number of minutes past midnight:

例如.

0 = 00:00 
60 = 01:00
252 = 04:12

然而,您需要编写一些代码来重构时间,但这应该不难.

You would however need to write some code to reconstitute the time, but that shouldn't be tricky.

相关文章