Time field without seconds

[piranha999]

Hello

Think this is a newbie question:

How can i change time field inside mysql to not append seconds to the time input. So i want time as format HH:MM and not HH:MM:SS stored. Or isnt this possible?

The alot for you help

 

[r937]

a datetime or timestamp field will store a seconds value whether you want it to or not

the most you can do is force the seconds to be zero

however, an easier approach is simply to store whatever datetime or timestamp value you wish, then just don't show the seconds whenever you display the values

see the DATE_FORMAT and TIME_FORMAT functions

rudy

http://r937.com/

SQL Consulting

 

[cdlvj]

Looks like not available. I know INFORMIX allows this, and also lets you define variable types like a typedef in "C". Only thing close is that datetime type lets you define from left as datetime[4] would be the year only.

 

[piranha999]

Alright, thats what i wanted to know.

Thanks alot for the quick answers.

 

[r937]

cdlvj, you do realize this is the mysql forum?

did you look up the DATE_FORMAT and TIME_FORMAT in the mysql manual?

i assure you they are there

rudy

http://r937.com/

SQL Consulting