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
Microsoft SQL Server 2008MySQL Server
Last Comment
blossompark
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
apologies for my lateness in closing this out, i hadnt realised i left it open....sorry !!
hi Sharath, my guess is they are hr: min: sec values....i need to present them as such