Hello – I have a SQL 2008 R2 Database that stores a Start Time as a Decimal (4,0) value. The output appears as: 700, 1100, 1330 etc.
I want to display the time as 0700 AM, 1100 AM, 1330 PM etc.
I attempted to convert the data type but run into all sorts of errors. I have found several posts regarding converting a time value to decimals but not the other way around.
Since I am going to use this information in a report, I would prefer to create a SQL view that will contact the data fields I need. I need help with the time conversion please. The Date field is a DateTime field, so that is less painful.