I have the situation where I am creating a catalog for a sql server 2000 database. This database stores all the datetimes in UTC(GMT). I am looking for a way to get the dates from the database into Local time for the catalog.
Any help would be much appreciated
Any help would be much appreciated