convert datetime to integer

[sodakotahusker]

I have a vendor supplied database which keeps track of phone calls. It has a date time field which contains the number of seconds involved in the call. How can I convert that datetime to an integer - easily - without converting to string and then picking the parts of the string out to calculate the seconds?
Perhaps there is no way? I've been my head against a wall for an hour.

 

[AlexCuse]

Something like this?

 Hour(TimeCol) * 3600 + Minute(TimeCol) * 60 + Second(TimeCol)

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[MichaelRed]

mayhap an example of what you get and what you would expect to be able to transmorgify it to would be helpful?




MichaelRed

 

[sodakotahusker]

Alex - this worked perfectly. Thank you very much! I was not aware of these functions. You have added to my repetoire and I appreciate it!!
Don