Convert timstamp to hh:mm:ss

Expand Post »

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

Similar Threads

How to convert wav to mp3 using VB? in Visual Basic 4 / 5 / 6
cannot convert from 'double' to 'float [6][3]' in C
problem with convert jumbled text file to unjumbled text file in C
Need help to convert Int64 to Base36 ? in PHP
VC++:convert File IStream to hex and store...? in C++

pervenches

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2005

Permalink

Jun 15th, 2005

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.

Zachery

Team Colleague

Reputation Points: 96

Solved Threads: 21

The Geek Father

Offline

781 posts
since Nov 2003

Permalink

Jun 16th, 2005

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

jwshepherd

Reputation Points: 20

Solved Threads: 5

Junior Poster

Offline

123 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Problem with Rewriting Subqueries as Joins

Next Thread in MS SQL Forum Timeline: Copying database from one server to another

DaniWeb Message

Cancel Changes

User Name
Password