Hi:

I have in table with the local date and time (colombia) of all the inserted records, but I need to do a select where I returned these records but that turns me the date and the local time in Date and Hour UTC (GMT) and show them in the select; have I no idea of as I can do it?

I hope that someone support me.

Thanx

I think u need to manipulate the datetime value with the time difference of colombia and GMT.U can use DateAdd function.

Bijgupt

 ok thanx for your support...this was very useful
Go to Top of Page

ok thanx for your support...this was very useful