SQL Time Zone problem

Hi,
When we advertise the Software & see the status through SMS Status messages we get proper time For eg:10:23 but if we query through SQL Database it shows timing 4:23.We are situated in (GMT -6 Central Time US, Canada) & i know the problem is also because of TimeZone problem as SQL database is taking GMT 0 time. I checked the regional settings, Date & Time of the machine also it is ok.Can anyone help me on this.....I hope i am able to clear the Question.

SMS2.0 Sp4
SQL2000