DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   MS SQL (http://www.daniweb.com/forums/forum127.html)
-   -   Convert timstamp to hh:mm:ss (http://www.daniweb.com/forums/thread25826.html)

pervenches Jun 15th, 2005 6:27 am
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?

Zachery Jun 15th, 2005 7:39 am
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.

jwshepherd Jun 16th, 2005 1:25 am
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


All times are GMT -4. The time now is 10:35 pm.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC