Thanks. what about if i want to retrieve only the date,

for example the datetime '1/1/2002 11:00:00', is there a SQL function to retrieve only '1/1/2002', ignoring the time?