column whichdate new_value whichday noprint
select trunc(sysdate) whichdate from dual;
spool c:\...\File_&&whichday..txt

thanx greg for ur help

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.

thanx