How to convert PST/PDT to UTC format without defining the +hh

[avinashelite]

Hi Experts,

In my data base, we have date and time stored in PST or PDT but we don't have the information whether its PST or PDT .

Now my requirement is , dynamically we need to identify PST or PDT and convert it to UTC

I have used converttolocaltime(field_name,'UTC') but its not giving me the proper result .

[marcus_sommer]

If you couldn't find a logic maybe through a longer sets of of to eachother belonging records and to see when happens a day-shift or from which user / IP is this record or any quite similar logics you won't be have a chance and needs to live with this blur.

By converting a time you need to use a proper syntax - not 'UTC' it needs to one of valid city-values which are listed within the help by this function.

- Marcus