Timestamp Question - Help

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 5 May 2007 08:15:54 -0700
Message-ID: <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 Received on Sat May 05 2007 - 10:15:54 CDT