Using sysdate in filename

[Cookies]

column whichdate new_value whichday noprint
can i create a spool file ,in same way, at server end for each client login to SQL.
with following details in it :
computer name or IP of that client,
session time, &
user name.

You can use sys_context to get almost any kind of information for
your spool file name:

  1  select
  2  sys_context('userenv','db_name') database_name,
  3  sys_context('userenv','host') host_name
  4* from dual
SQL> /

DATABASE_NAME   HOST_NAME
--------------- -------------------------------------
db01            MYHOSTNAME