On May 6, 7:20 pm, William Robertson <williamr2..._at_googlemail.com>
wrote:
> 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".- Hide quoted text -
>
> - Show quoted text -
Thanks All. It helped. Thanks again
Received on Tue May 08 2007 - 01:13:18 CDT
