> <pankaj_wolfhun@yahoo.co.in> wrote:
> > On May 5, 8:21 pm, "Ana C. Dent" <anaced@hotmail.com> wrote:

> > > "pankaj_wolfhun@yahoo.co.in" <pankaj_wolfhun@yahoo.co.in> wrote innews: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- Hide quoted text -

> > >

> > Thanks Ana. Do we have some documentation on the same?

> Perhaps surprisingly, SQL is documented in the SQL Reference manual,
> which you should already have bookmarked. Look for "date format".- Hide quoted text -

>