time zone conversion SGT to UTC ****

[#1]

HI all,

I Have a time field Its contains time in SGT zone I want to convert it into UTC format. So that I used the below code

Timestamp(field - time#(8,'hh.mm.ss'))

But it give the result wit date and the time format is like AM/ PM

1. I dont want the  date in my resultant set

2. I want the result in 24 hrs format not in AM/PM

Please do me the needful ASAP

thnx

[Anonymous]

If Karla's suggestion does not work for you, in the load script you could use DATEADD(hh,+/-X,<timestamp>)