On May 5, 4:28 pm, "pankaj_wolfhun..._at_yahoo.co.in"
<pankaj_wolfhun..._at_yahoo.co.in> wrote:
> On May 5, 8:21 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
>
>
>
> > "pankaj_wolfhun..._at_yahoo.co.in" <pankaj_wolfhun..._at_yahoo.co.in> wrote innews:1178378154.166500.88170_at_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 -
>
> > - Show 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".
Received on Sun May 06 2007 - 09:20:59 CDT
