What database field should this be?

Posted by alex on Stack Overflow See other posts from Stack Overflow or by alex
Published on 2010-04-02T09:44:44Z Indexed on 2010/04/02 9:53 UTC
Read the original article Hit count: 259

Filed under:
|
|
|
|

I have a table called "Event". A column has "duration"--which is...how long that event lasts.

What database type should this be? Integer? (in seconds)?

In the future, I will do statements such as:

If now() > event.duration  THEN don't display the event.

© Stack Overflow or respective owner

Related posts about database

Related posts about mysql