blossompark
asked on
converting integer data type to time data type in sql
hi
i have a teradata sql table with a time column thatbstores data as integers.
it has values ranging from 153 to 235,957.
i want to convert these values when selected to meaningful time values.
any guidance appreciated
i have a teradata sql table with a time column thatbstores data as integers.
it has values ranging from 153 to 235,957.
i want to convert these values when selected to meaningful time values.
any guidance appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
apologies for my lateness in closing this out, i hadnt realised i left it open....sorry !!
ASKER
hi Sharath, my guess is they are hr: min: sec values....i need to present them as such