Insert AM/PM in datetime column? 1

[minkisi]

I have a datetime column (0000-00-00 00:00:00) in my table. I update the column from form fields for month, day, year, hour and minute. I always set the seconds to 00. This is all in PHP.

Where and how can I indicate AM or PM values? Are they part of the datetime column? I know you can use '%p' in the SELECT for display but how do I insert them?. Do I have to use the 24 hour time format? I would prefer not to do that.

Thanks,
minkisi

 

[r937]

yes, i think you do have to use 24-hr format

i've just tested inserting a bunch of values using PM and mysql either just ignores it or invalidates the date

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[minkisi]

Thanks r937!

I made the users enter 24 hour time in the form. Then when you select from the table it brings back the correct AM or PM.

minkisi