Formatting time in datalist

[primagic]

I have a field in an sql server table with a fieldtype of time.

I am trying to use the following code to format the time in a datalist

<%# Eval("AppointmentTime", "{0:hh:mm tt}") %>'

However I am getting the error 'Input string was not in a correct format.'

Help please

Thanks

 

[MarkSweetland]

The format function is expecting a date component along with the time. You can just convert your time column to a datetime in SQL which will introduce 1900-01-01 as the date along with the proper time. Since your eval will extract the time in the format you want, the date is ignored.

select convert(datetime, AppointmentTime) as AppointmentTime

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach