Convert timstamp to hh:mm:ss
 

Hello,
How can a timestamp field (int, 4) witch displays as hhmmss be converted that it looks like hh:mm:ss?
Can anyone help?

Re: Convert timstamp to hh:mm:ss
 

I would assume you'd either need to store it differntly or use a function in php, asp, asp.net or your programming language of choice.

Re: Convert timstamp to hh:mm:ss
 

here
http://www.databasejournal.com/featu...0894_2197931_2

this link should put you on the right path