Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > converting from...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 8801 of 9053
Post > Topic >>

converting from time in seconds to timestamp format

by alexs <A.Sharaz@[EMAIL PROTECTED] > Apr 17, 2008 at 04:54 AM

hi,

I'm moving a mysql database over to using db2 V9.5

The database is used by our radius server to store network accounting
information from our switches.
One parameter is the length of a network session in seconds.

In mysql there is a sec_to_time function which i then used to store
the session time as a char string
I want to do something similar in db2 and thought that the best way
would be to store it in a timestamp column.

Can i do that?

any better way of storing the time?

TIA
alex




 7 Posts in Topic:
converting from time in seconds to timestamp format
alexs <A.Sharaz@[EMAIL  2008-04-17 04:54:14 
Re: converting from time in seconds to timestamp format
Serge Rielau <srielau@  2008-04-17 08:26:24 
Re: converting from time in seconds to timestamp format
"Serman D." <  2008-04-18 00:38:55 
Re: converting from time in seconds to timestamp format
"Serman D." <  2008-04-18 03:22:37 
Re: converting from time in seconds to timestamp format
Serge Rielau <srielau@  2008-04-18 07:42:01 
Re: converting from time in seconds to timestamp format
alexs <A.Sharaz@[EMAIL  2008-04-20 11:38:02 
Re: converting from time in seconds to timestamp format
Serge Rielau <srielau@  2008-04-21 06:43:12 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 22:32:33 CDT 2008.