MS SQL

MS SQL RSS

Convert timstamp to hh:mm:ss

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2005

Posts: 1

Reputation: pervenches is an unknown quantity at this point

Solved Threads: 0

pervenches pervenches is offline

Offline

Newbie Poster

Convert timstamp to hh:mm:ss

Jun 15th, 2005

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

•

Join Date: Nov 2003

Posts: 781

Reputation: Zachery has a spectacular aura about

Solved Threads: 21

Zachery

Offline

The Geek Father

Re: Convert timstamp to hh:mm:ss

Jun 15th, 2005

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.

Firefox: no, its not the end all solution, it has its own issues and in time it will be just as insecure as IE, when its hit Firefox 6, if it makes it that far. Oh, and AOL pays for it, incase you didn't know.

Microsoft & Windows: If you hate it so much, move to linux, or bsd, or anything else, stop complaning and move on.
Good starting places: Gentoo Novell SUSE Fedora Core Apple