how to find out it is PM or AM in mysql ?

[niroshan]

Hi Everyone,

I have a table which has a column named "timeOut" and the data type of that column is datetime. when i inserting data in to that coloum, I insert it as '2003-06-03 03:19:20' and insertion is fine.

But my problem is how can i find out if this value is PM or AM ?.

Is there any way i can differenciate between AM / PM in that datetime field.

I can not make the timeOut field as string.( Cos if it is string i can store any value)

I cannot turn it in to string because if so it would effect my SQL queries.

I need your help desperately. I would really appreciate it if someone can help me.

Thanx in advance,

regards,
Niroshan

[weekender]

you can use the date() function for this...

echo date("a", $timestamp);

the above code, when passed the unix timestamp as $timestamp, will return either "am" or "pm". Look at the date() link above for more formatting.