Convert to local date/time when page is rendered?

[Randall Parker]

I realize that methods like DateTime.ToLocalTime() and DateTime.ToUniveralTime() exist.

But suppose one wants to query out data from a database that has UTC times in it.
Suppose one wants to have a DataGrid with BoundColumn rows that are dates and times.
Can one somehow in specifying the formatting for a date column say "date the bound
date and treat it as UTC and convert it to PST when the page is rendered"?

Or does one have to go thru the dataset and do date math on every date column in
every row before doing the DataBind() call?

I'm not even sure whether the database I'm using (MySQL) thinks it is handing me UTC
dates. But I just found out that the data feed I've got comingi in is providing UTC
dates and I'm going to have customers in a few different time zones wanting to look
at forms in theirr time zones.