Timestamp for non-default time zone

How do I get the timestamp of non-default timezone in Informix. In Oracle we can get it by this select query : select current_timestamp at time zone 'utc' from dual. thanks,

Timezones are not supported in Informix. However, if you look on the IIUG Site, John Miller III did a presentation at one of the IIUG Conferences about creating UDRs and one of the examples is code to create a zoned datetime datatype. I don't remember if he had a function/operator included for returning the time in another zone, but it shouldn't be hard to add. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Nov 10, 2010 at 5:20 AM, PRADEEP KUMAR <pkyadav1@hotmail.com> wrote: > How do I get the timestamp of non-default timezone in Informix. > > In Oracle we can get it by this select query : > > select current_timestamp at time zone 'utc' from dual. > > thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e640d506714db70494b17828