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?
Received on Sat May 05 2007 - 10:28:12 CDT
