jemz — 2013-11-09T09:08:25-05:00 — #1
HI, Can i ask some help i am confuse...i want to store this time
,is it okay to use varchar datatype on this ?.or what datatype should i use on this ?
Thank you in advance.
guido2004 — 2013-11-09T09:26:43-05:00 — #2
jemz — 2013-11-09T09:54:31-05:00 — #3
i want to insert this 14:53:49 PM but i don't know what datatype for my column field.
Thank you in avdvance.
r937 — 2013-11-09T15:29:53-05:00 — #4
first of all, that doesn't make sense
it's either 14:53:49, without the PM, or else it's 2:53:49 PM -- but 14:something along with PM doesn't make sense
and the datatype you're looking for is TIME
it won't "store" the PM part, so if you want to see AM/PM when you retrieve the value, you need to use the DATE_FORMAT function
jemz — 2013-11-11T09:46:22-05:00 — #5
Thank you so much r937