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?

Newbie Poster

1 post since Jun 2005

Reputation Points: 10

Solved Threads: 0

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.

The Geek Father

Team Colleague

894 posts since Nov 2003

Reputation Points: 96

Solved Threads: 21

this link should put you on the right path

Junior Poster

123 posts since Jun 2005

Reputation Points: 20

Solved Threads: 5

This article has been dead for over three months

You