Path: news.f.de.plusline.net!news-fra1.dfn.de!kanaga.switch.ch!switch.ch!news.in2p3.fr!in2p3.fr!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!news3.google.com!out01b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!in03.usenetserver.com!news.usenetserver.com!hwmnpeer01.phx!news.highwinds-media.com!hw-filter.phx!newsfe15.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> Organization: Your Company User-Agent: Xnews/5.04.25 Lines: 32 Message-ID: <0i1%h.224092$ZA5.217251@newsfe15.phx> Date: Sat, 05 May 2007 15:21:32 GMT NNTP-Posting-Host: 70.181.210.12 X-Complaints-To: admin@cox.net X-Trace: newsfe15.phx 1178378492 70.181.210.12 (Sat, 05 May 2007 08:21:32 MST) NNTP-Posting-Date: Sat, 05 May 2007 08:21:32 MST Xref: news.f.de.plusline.net comp.databases.oracle.misc:79115 "pankaj_wolfhunter@yahoo.co.in" wrote in news:1178378154.166500.88170@p77g2000hsh.googlegroups.com: > Greetings, > I am newly involved in a project. At one place, we > are using to_timestamp and to_char function which drill down to > something like this (example): > > SELECT TO_CHAR(TO_TIMESTAMP('03.54.17.77','HH24:MI:SS > FF4'),'SSSSS.FF4') FROM sometable; > > I tried it on dual and this is what i got as the output: > > TO_CHAR(TO_TIME > --------------- > 14057.7700 > > 1 row selected. > > 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