Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: UNIX TIME STAMP
- From: Alexander Vysokovskih <av(at)ural(dot)org>
- To: Mageshwaran <j_mageshwaran(at)sifycorp(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: UNIX TIME STAMP
- Date: Tue, 3 Apr 2007 20:58:15 +0600
Hello, Mageshwaran. > Is there any function in postgresql7.1.3 to convert unix time stamp to > normal date and time format select date(timestamp 'epoch' + unixtime_column * interval '1 second') from Table; -- Regards, Alexander Vysokovskih mailto:av(at)ural(dot)org
- References:
- UNIX TIME STAMP
- From: Mageshwaran
- UNIX TIME STAMP
- Prev by Date: Re: recovering using a continuous archive backup doesn'twork on Windows
- Next by Date: plpgsql function question
- Previous by thread: UNIX TIME STAMP
- Next by thread: Re: recovering using a continuous archive backup doesn'twork on Windows
- Indexes: