PHP/MySQL Date and Time

[Scotty.T]

I've just been looking at a database for a script I have running to see what info I have available.

In some of the tables I have fields named 'Hour' 'Time' etc that have a number like this in it 341509. I am guessing it is a date and/or timestamp.

I'm trying to understand what format this is in? Any ideas?

I've looked at PHP/MySQL Timestamp stuff online but I can't seem to get it to convert to anything that is recognisable.

[redwhiteandblue]

I've just been looking at a database for a script I have running to see what info I have available.

In some of the tables I have fields named 'Hour' 'Time' etc that have a number like this in it 341509. I am guessing it is a date and/or timestamp.

I'm trying to understand what format this is in? Any ideas?

I've looked at PHP/MySQL Timestamp stuff online but I can't seem to get it to convert to anything that is recognisable.

If you PM me with the relevant column names and types, and an example of one row of data, I'll take a look.

[Scotty.T]

PM sent, thanks.

[Scotty.T]

redwhiteandblue got me sorted.

Thanks again.

[redwhiteandblue]

Same time again next week? Remember to bring the egg whisk though.