Yes this worked. Thanks Abhishek!
On Thu, Dec 1, 2011 at 10:28 AM, Abhishek Pratap Singh <manu.i...@gmail.com>wrote: > hi Sonia, > > > Try this > > SELECT from_unixtime((unix_timestamp(TXN_DATE) - 28800), 'yyyy-MM-dd > HH:MM:SS') as TXNDATE > > 28800 is the 8 hours difference in seconds for PDT. > > > ~Abhishek > > On Thu, Dec 1, 2011 at 10:21 AM, sonia gehlot <sonia.geh...@gmail.com>wrote: > >> Hi All, >> >> I have Unix timestamp in my table in UTC format. Is there is any inbuilt >> function to convert it into PST or PDT in YYYY-MM-DD HH:MM:SS format? I >> know there are functions like from_unixtime to convert unixtime to date >> format, but I am not sure how to convert it to PST. >> >> Thanks in advance, >> >> Sonia >> > >
