Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c74g2000cwc.googlegroups.com!not-for-mail
From: mehaboob@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: command to display time in DATE format
Date: 6 Jun 2006 07:11:01 -0700
Organization: http://groups.google.com
Lines: 11
Message-ID: <1149603061.349299.173000@c74g2000cwc.googlegroups.com>
NNTP-Posting-Host: 15.203.169.125
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1149603066 313 127.0.0.1 (6 Jun 2006 14:11:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 6 Jun 2006 14:11:06 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: c74g2000cwc.googlegroups.com; posting-host=15.203.169.125;
   posting-account=t-Pqjw0AAAD1wih1fRxEyfEQBPguK2ZN
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268620

Hi,

In oracle DB table,I have a  varchar field which stores time in EPOCH
fomat
for eg:11652232 secs

Is there a command to display the above time in Date format? (something
like DD MM YY)

Mehaboob