Re: Timestamp Question - Help

"pankaj_wolfhunter_at_yahoo.co.in" <pankaj_wolfhunter_at_yahoo.co.in> wrote in news: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 Received on Sat May 05 2007 - 10:21:32 CDT