Path: news.f.de.plusline.net!news-fra1.dfn.de!news-nue1.dfn.de!newsfeed.r-kom.de!newsfeed.freenet.de!newsfeed0.kamp.net!newsfeed.kamp.net!213.239.142.2.MISMATCH!feed.xsnews.nl!border-1.ams.xsnews.nl!68.142.88.75.MISMATCH!hwmnpeer01.ams!news.highwinds-media.com!hw-filter.phx!newsfe16.phx.POSTED!53ab2750!not-for-mail Newsgroups: comp.databases.oracle.misc Subject: Re: Timestamp Question - Help From: "Ana C. Dent" References: <1178378154.166500.88170@p77g2000hsh.googlegroups.com> <0i1%h.224092$ZA5.217251@newsfe15.phx> <1178378892.882450.112810@n59g2000hsh.googlegroups.com> Organization: Your Company User-Agent: Xnews/5.04.25 Lines: 24 Message-ID: Date: Sat, 05 May 2007 16:09:46 GMT NNTP-Posting-Host: 70.181.210.12 X-Complaints-To: admin@cox.net X-Trace: newsfe16.phx 1178381386 70.181.210.12 (Sat, 05 May 2007 09:09:46 MST) NNTP-Posting-Date: Sat, 05 May 2007 09:09:46 MST Xref: news.f.de.plusline.net comp.databases.oracle.misc:79117 "pankaj_wolfhunter@yahoo.co.in" wrote in news:1178378892.882450.112810@n59g2000hsh.googlegroups.com: >> > The output doesnt make sense and probably because I am not able to >> > get what is SSSSS stands for in TO_CHAR function. >> >> > Can anyone help? >> >> > DB Version Info: >> > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi >> > PL/SQL Release 10.2.0.3.0 - Production >> >> (3*60*60)+(54*60)+17.77 = 14057.77 >> 3 hours, 54 minutes, 17.77 seconds represented in total SECONDS- Hide >> quoted text - >> >> - Show quoted text - > > Thanks Ana. Do we have some documentation on the same? > > http://tahiti.oracle.com IIRC, SQL Reference Guide