Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
avinashelite
MVP
MVP
‎2015-08-04 08:57 AM

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

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 .

1,589 Views
0 Likes
1 Reply
marcus_sommer
MVP
MVP
‎2015-09-25 11:32 AM

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

1,238 Views
0 Likes