data type

[berry]

Hi,
May I know what type should I assign for the hour that user had key in? i mean the user will key in hour in format: "8:00". To store it in the server, what type I should assign?

[Killer42]

Hi,
May I know what type should I assign for the hour that user had key in? i mean the user will key in hour in format: "8:00". To store it in the server, what type I should assign?

We'd need a bit more detail about exactly what you want to do with this data. You could jsut store the string "8:00" to be displayed again. Or you could save an actualy date/time value. Or just the number 8. Or 480 (8 hours as a number of minutes). Or the number 28,800 (same in seconds). Or whatever.

It's really up to you.