hello, <BR>i'm designing an MS SQL data base, but have one problem, <BR>i need date and time logged to two different column. <BR><BR>but in sql is the data feild type is DateTime. <BR>so how can i make onr column log date <BR>and another log only time. insted of both in one feild? <BR><BR>in access db i'm able to set for the date/time formats, <BR>is this possible in ms sql? <BR><BR>thanks in advance for your time!