Hi

I hope I can explain this correctly...

I have had to manually upload some files to my site and then using a script it adds then to the correct table in the database... but the time is always the same... as I do not know what the time is in the format shown..

the time in the table for 1 file is displayed like the is 1232582020 and in my site it will show correctly like this 2009/01/22 - 00:53

firstly does anyone know of a quick explanation as to the format mysql displays the time and secondly is it easier to work out manually so I can change each line to display the correct time I uploaded the file...

Thank you for any help

   

____________
Mods and themes for Icy Phoenix 1.3

IcyPhoenix UK is off-line permanently due to lack of time to update mods.
if anyone is interested in my templates I will upgrade them to Icy 2.0.

Try - Google for "Unix Time"  values / variables / strings / functions.

Fantastic thank very much makes it a lot easier once you know what to look for...

and if anyone else needs help with this here is a site that will convert it for you.

Convert a Date/Time to a Unix timestamp

Thank you again...

Marked as solved

   

____________
Mods and themes for Icy Phoenix 1.3

IcyPhoenix UK is off-line permanently due to lack of time to update mods.
if anyone is interested in my templates I will upgrade them to Icy 2.0.

You're welcome  

And thanks for the link.

Never gave it a thought to add "Convert" as a search word - Must be slipping!  

  

____________
Mods and themes for Icy Phoenix 1.3

IcyPhoenix UK is off-line permanently due to lack of time to update mods.
if anyone is interested in my templates I will upgrade them to Icy 2.0.